how to upload a excel file to google sheets

Locate the search bar in the top right corner of the screen and search for GPT for Sheets and Docs.

Up next, you should be taken to the Google Workspace Marketplace. Locate and click on Extensions > Add-ons > Get Add-ons. It will think for a few seconds, then ask you about accessing web. You can also drag and drop the file into this window.

Click the blue button labeled Select a file from your computer, and choose the Excel file to upload. From the list of options, select the Import feature. Choose an import location, then click the Import data button. Select an Excel file from your Google Drive or upload it from your hard-drive. This action will allow you to work with the data, but the document will remain in Excel format, as indicated by the filename extension. Click Open with, then click Google Sheets. Create a new Google Sheets file or open an existing spreadsheet. Click File upload and navigate to the Excel document on your hard drive. The rest are not required parameters.You can skip them for the time being.įor the code to work, you must enable Drive API in Advanced Google Services in your script and in Developers Console (see How to Enable Advanced Services for details). Open a new Google Sheets spreadsheet on your computer. Click the File tab to open the dropdown menu. Here are the steps to import data from Excel to Google Sheets: Step 1.

Var newDocfromBlob = DocsList.createFile(docContentBlob) // this will create a pdf version of your doc //Optionalįor the second required parameter, it is simply a Var copyofDoc = DocsList.getFileById(doc.getId()).makeCopy('new copy of '+doc.getName()) // this will create a copy (google doc format) // Optional Var doc = DocumentApp.openByUrl('/edit')

How to upload a excel file to google sheets