2.1 Work with Excel files in Drive
There are different ways to work with Microsoft Excel files. You can:
- Import Excel data into Sheets. Learn more
- Convert Excel files to Sheets. Learn more
- Edit Excel files in Drive without converting them. Learn more
- Convert Sheets files to Excel or other formats. Learn more
2.2 Use Excel and Sheets together
If your team uses Microsoft Excel® and Sheets, here are some best practices for when to use each product.
Convert existing Excel spreadsheets to Sheets if:
- You need to collaborate or simultaneously edit with your team.
- Your data set is five million cells or fewer.
Continue working in your existing Excel spreadsheets if:
- Your data set is more than 5 million cells.
- You’re using the Hyperion add-on with Excel.
- If you use rare chart types, such as 3D pyramid charts or pie-of-pie charts.
2.3 Edit Excel files in Sheets
Open an Excel file from Drive and edit it in Sheets. Any changes you make are saved in the original Excel format.
Chrome browser only
- Make sure that the Office editing for Docs, Sheets and Slides extension is not installed:
- Open the Chrome browser and, at the top-right corner, click More
More tools
- If you see the Office editing for Docs, Sheets and Slides extension, click Remove.
- In Drive, double-click an Excel file.
A preview of your file will open.
- At the top, click Open with Google Sheets.
You can now edit, share, view version history, collaborate in real time with others and more. All changes that you make are saved to the original Microsoft Office file.
2.4 Import Excel data into Sheets
You can import data from an Excel file to a new (or existing) Sheets file. Your Excel file won’t be changed, even as you change the Sheets file.
- In Sheets, create a new or open an existing spreadsheet.
- Click File
- Choose the Excel file and click Select.
- Choose an import option:
- Create new spreadsheet
- Insert new sheet(s)
- Replace spreadsheet
- Click Import data.
- If prompted, click Open now.
2.5 Convert Excel files to Sheets
Instead of importing data, you can convert an Excel file to Sheets and keep working on it in Sheets. Your Excel file won’t be changed.
- Open Driveand double-click an Excel file.
A preview of your file will open.
- At the top, click Open with Google Sheets.
- Click File
To convert all future uploads of Office files to Google Sheets automatically:
- In Drive, at the top, click Settings
- Next to Convert uploads, turn on Convert uploaded files to Google Docs editor format.
Note: Previously uploaded files will not be converted.
Tip: Use these icons to differentiate quickly between Sheets and Excel files in Drive:
Sheets
Excel
2.6 Share a copy of a Sheets file in Excel format
You can work on a spreadsheet in Sheets and then send a copy by email as an Excel file (or a PDF).
- In Sheets, open the file.
- Click File
Under Attach as, choose Microsoft Excel.
- Enter the email address, subject and message.
- (Optional) Tick the Send a copy to myself box.
- Click Send.
You can also download a copy of the Sheets file in Excel, PDF, CSV, ODS or other formats.
- In Sheets, click File
- Select the file format that you want to download.
Google, Google Workspace and related marks and logos are trademarks of Google LLC. All other company and product names are trademarks of the companies with which they are associated.