If the imported spreadsheet contained formatting, the formatting will also be imported. or append the data starting at the selected cellĬlick Import Data and the data will be imported in the specified location Step 5.replace the current spreadsheet entirely.Not all filetypes and files will have all options, but in general you can choose to do the following: Select where you’d like to import the data from the dropdown. Google Sheets can import any non-password protected file in the following formats: You can select a file from your Google Drive or upload a file. In the Import window, choose the file to import. Open the Google Sheet you want to import into, then open the File menu and choose Import Here’s how to import a spreadsheet into Google Sheets: Step 1 How to Upload a Spreadsheet to Google Sheets (in 5 Steps) That way you can be certain you’re getting all the data, and also take advantage of carrying over any formatting in the original file.

While you could copy and paste the data manually, it’s typically easier to simply import the data. Google Sheets is a great tool for collaborating and working in the cloud.īut many people and services still use other spreadsheet formats like Microsoft Excel files or CSV files (comma separated value files).īecause often you will find you need to transfer data from one of these spreadsheets into Google Sheets. Can I import a file into Google Sheets?.Can I import an Excel spreadsheet into Google Sheets?.How to Upload a Spreadsheet to Google Sheets (in 5 Steps).How To Import Spreadsheet Into Google Sheets.

Upload an excel file to google sheets