Locate Excel file and right-click on it.

To do so, on your Google Drive, click on +New icon > File Upload. In case, you do not have Excel file in Google Drive, upload them first. This method is best when you want to edit the Excel workbook in Sheets while having the same Excel format. If you have Excel files in your Google Drive, you can simply open them as Google Sheets.

Finally, click on Open Now if prompted.

It applies if you have opened an existing sheet.

Replace spreadsheet: It replaces everything on your current spreadsheet with the Excel data.

Insert new sheet(s): This option replaces the present theme of your Google sheet.

Create new Spreadsheet: Imports Excel data in New Spreadsheet.Now, on Import File, pick any one Import Location.On Import file window, head to Upload Tab and click on Browse.Then, open Existing sheet or create New sheet. Using this, you can import the Excel files into Sheets and edit the spreadsheet as per your preference. Google Sheet has a default Import option which makes downloading any files easier. Method 1: Import Excel File to Google Sheets Also, while importing, your record should be less than 5 millions cell. For Instance, if your Excel workbook contains rare charts like Pie-of-Pie charts, Google Sheets does not support it.

Warning: When you upload the Excel file to Google Sheets, you may lose some Excel functionalities. Check out four effective approaches to import Excel in Sheets in this article. This allows you to view, edit, share, and collaborate on the sheets. As an avid Excel user, you may encounter colleagues or collaborators who prefer using Google Sheets instead, or vice-versa.Įither way, it’s useful to know how to sync Excel files with Google Sheets.įor this, you can directly import Excel files or convert them into Sheets format. Microsoft Excel and Google Spreadsheets are the two most popular spreadsheets.

Import excel into google sheets