how to upload an excel file to google sheets

I think this is because the app script refuses to create the file in a shared folder.Īnyway, I have tens of very short Excel files that I want to read and concatenate in a single Sheet, So I don't think creating that many intermediate Sheet files is efficient. The error message comes from the (config, blob) instruction. GoogleJsonResponseException: API call to failed with error: File not found: 1mxYU55TOX1gp2ABzmSpB_lEWSw2FGa7v It’s a very much handy and useful way to do it. You can use Google Drive to import data from Excel to google sheets. Here is my implementation for a single test file : function importFile() Using Google Drive to Import Data from Excel. I found this sample code and tried to adapt it to my use case.

Add the fields you want, share the form with your colleagues or followers, and the results will show up in your spreadsheet automatically. I want to import their content inside a single Google Sheet spreadsheet. Step 1: Create a spreadsheet To create a new spreadsheet: Open the Sheets home screen at . Click Tools > Create a New Form in Google Sheets, and the Google Forms editor will open with a new form thats automatically connected to your spreadsheet. I have several Excel files in a shared Google Drive.

How to upload an excel file to google sheets