---
title: "Importing data from MS Excel to Google Sheet with Google Apps Script"
author: "Martin Hawksey"
date: 2022-04-26T08:58:12+00:00
modified: 2022-04-26T08:58:16+00:00
canonical_url: https://pulse.appsscript.info/p/2022/04/importing-data-from-ms-excel-to-google-sheet-with-google-apps-script/
markdown_url: https://pulse.appsscript.info/p/2022/04/importing-data-from-ms-excel-to-google-sheet-with-google-apps-script.md
categories:
  - "Drive"
  - "Intermediate"
  - "Sheets"
  - "Solutions"
  - "V8"
tags:
  - "@barrielroberts"
  - "bazroberts.com"
featured_image: https://pulse.appsscript.info/files/2022/04/53-Import-Excel-data-to-Sheets-1.png
description: "Similar to the post on converting a PDF document to text, this tutorial from Baz Roberts uses a similar approach of using the Google Drive API for file conversion, this time converting a MS Excel file into Google Sheets to make it possible to easily extract and update a master spreadsheet."
---

# Importing data from MS Excel to Google Sheet with Google Apps Script

![Importing data from MS Excel to Google Sheet with Google Apps Script](https://pulse.appsscript.info/files/2022/04/53-Import-Excel-data-to-Sheets-1.png)

> [https://www.bazroberts.com/2022/04/24/importing-amazon-royalty-data-from-excel-to-google-sheet/](https://www.bazroberts.com/2022/04/24/importing-amazon-royalty-data-from-excel-to-google-sheet/)
> In this post we’re going to look at how we can get data from an Excel spreadsheet and import some of it into a Google Sheet. As an example, we’re going to upload an Excel which contains the current month’s royalty data from Amazon and add it to a central sheet which contains all the previous month’s royalties.

Similar to the [post on converting a PDF document to text](https://pulse.appsscript.info/p/2022/04/how-to-extract-text-from-pdf-files-with-google-apps-script-digital-inspiration/), this tutorial from Baz Roberts uses a similar approach of using the Google Drive API for file conversion, this time converting a MS Excel file into Google Sheets to make it possible to easily extract and update a master spreadsheet. The post includes a detailed explanation of the shared code.

Source: *[Importing Amazon royalty data from Excel to Google Sheet – Learning Google Workspace & Apps Script*](https://www.bazroberts.com/2022/04/24/importing-amazon-royalty-data-from-excel-to-google-sheet/)

---

*Published by [Martin Hawksey](https://pulse.appsscript.info/p/author/admin/) on [Pulse](https://pulse.appsscript.info/). Original article: [https://pulse.appsscript.info/p/2022/04/importing-data-from-ms-excel-to-google-sheet-with-google-apps-script/](https://pulse.appsscript.info/p/2022/04/importing-data-from-ms-excel-to-google-sheet-with-google-apps-script/)*