How to Convert Excel to Google Sheets: 4 Easy Methods

To convert Excel to Google Sheets, upload the Excel file to Google Drive, double-click it to open the preview, and choose Open with, then Google Sheets. Then go to File and select Save as Google Sheets. Google creates a new Sheets copy and leaves your original Excel file unchanged.

That is the fastest method, but it is not the only one. You can also import a file from inside Sheets, turn on automatic conversion for every upload, or work on the Excel file directly. This guide walks through each method, explains what may change after conversion and offers a checklist to keep your data safe.

Before You Start

You need a Google account and a file in a common format such as .xlsx, .xls or .csv. Check that the file is not password protected, since Drive cannot open protected workbooks. Keep a backup of the original, even though the conversion does not alter it. If your workbook has macros, pivot tables or heavy formatting, read the section on compatibility before you convert.

Method 1: Upload to Google Drive and Save as Google Sheets

This is the most common route, and it works on any computer with a browser.

  1. Open Google Drive and sign in.
  2. Click New, then choose File upload.
  3. Select your Excel file and wait for the upload to finish.
  4. Double-click the uploaded file to open it in preview mode, then click Open with Google Sheets.
  5. In the Sheets menu, choose File, then Save as Google Sheets.

Sheets creates a separate Google Sheets file. The original Excel file remains in Drive, so you now have two copies. Rename or move the new file so you do not confuse them.

Method 2: Right-Click and Open With Google Sheets

If the Excel file is already in Drive, you can skip the upload.

  1. Find the Excel file in Drive.
  2. Right-click it and move to Open with.
  3. Choose Google Sheets.
  4. When the file opens, choose File, then Save as Google Sheets to create a native copy.

Until you save it as a Google Sheet, the file stays in Excel format. You can edit it, and Google marks it with an .xlsx label, but features that exist only in Sheets may not be available.

Method 3: Import From Inside Google Sheets

You can also start from Sheets and bring the data in.

  1. Open Google Sheets and start a blank spreadsheet.
  2. Click File, then Import.
  3. Choose the Upload tab and drag in your Excel file, or select it from Drive.
  4. Pick an import option, such as creating a new spreadsheet, inserting new sheets or replacing the current sheet.
  5. Click Import data.

This method is handy when you want to merge Excel data into an existing Google Sheet rather than create a fresh file.

Method 4: Turn On Automatic Conversion

If you convert files often, you can ask Drive to convert every upload.

  1. In Google Drive, click the gear icon and choose Settings.
  2. Find the option to convert uploaded files to Google Docs editor format.
  3. Turn it on and save your changes.

After that, spreadsheets you upload become Google Sheets automatically. Remember that the setting affects future uploads in that account, so turn it off if you sometimes want to keep files in Excel format.

Google also explains how to open and edit Microsoft Office files in its help article on editing Office files with Docs, Sheets and Slides, which is worth checking if the menu names change.

Convert Excel to Google Sheets on a Phone

You can do this on a phone or tablet too. Install the Google Sheets and Google Drive apps, upload the Excel file to Drive from your phone, then open it with Sheets. Use the file menu inside the app to save a copy as a Google Sheet. The menu names can differ slightly from the browser version, so look for the three-dot menu if you do not see them.

Compare the Four Methods

Method Best for Creates a separate Sheets file?
Upload and Save as Google Sheets One-time conversions Yes
Right-click, Open with Files already in Drive Only after you save as Sheets
Import from Sheets Adding data to an existing sheet Depends on the import option
Automatic conversion Frequent uploads Yes, automatically

What Can Change After Conversion

Google Sheets handles most standard Excel content well, including text, numbers, basic formulas, simple charts and cell formatting. Some advanced Excel features do not carry over cleanly. Check these items after converting.

Macros and VBA

Google Sheets does not run VBA. After conversion, macros stop working. To recreate that automation, you need to rewrite it in Google Apps Script, which uses JavaScript.

Formulas and Functions

Most common formulas work in both programs. Newer or Excel-only functions may show errors or behave differently. Open a few key formulas, compare results with the original and fix any that show an error.

Pivot Tables and Charts

Pivot tables and charts often convert, but styling can change. Rebuild any that look wrong. Rare chart types may not exist in Sheets.

Formatting and Fonts

Fonts, column widths, conditional formatting and number formats can shift slightly. Check dates and currency formats first, since they affect calculations.

Large Files

Excel handles very large datasets well, with up to 1,048,576 rows and 16,384 columns per sheet. Google Sheets has its own limits on total cells, and very large files can run slowly in a browser. If your workbook is huge, test it before you move your whole workflow.

A Quick Checklist After Converting

  • Compare totals and key numbers with the original.
  • Check that dates, currencies and percentages look correct.
  • Test a few formulas and look for error messages.
  • Review charts, pivot tables and conditional formatting.
  • Rewrite any macros with Apps Script if you still need them.
  • Share the file and set permissions for viewers and editors.

Tips for a Smoother Move

Clean your data before you convert. Remove blank rows, merge only when necessary and give each column a clear header. Name the new file clearly, such as “Sales 2026 (Sheets)”, so teammates know which version to use. If your team works on shared files all week, steady habits help, and our consistency quotes offer a little encouragement for routine work. For a lighter start to the workweek, you might also enjoy our funny Monday quotes.

Frequently Asked Questions

Can I convert Excel to Google Sheets for free?

Yes. A free Google account includes Google Drive and Google Sheets, so you can upload an Excel file and convert it without paying. Storage limits still apply, so check how much space your Drive has before you upload large files.

Does converting change my original Excel file?

No. When you use Save as Google Sheets, Google creates a new copy and leaves your original Excel file untouched. Keep both until you have checked the new file and are sure everything converted correctly.

Why do my formulas show errors after converting?

Some Excel functions are not available in Google Sheets or behave differently. Check which formulas fail, then look for a Sheets equivalent. Also confirm that cell references still point to the right sheets and ranges.

Will my Excel macros work in Google Sheets?

No. Google Sheets does not run VBA macros. You must rewrite them in Google Apps Script, which uses JavaScript. Simple tasks can often be rebuilt with built-in Sheets features instead of code.

Can I convert Excel to Google Sheets automatically?

Yes. In Google Drive settings, turn on the option to convert uploaded files to Google Docs editor format. After that, spreadsheets you upload convert to Google Sheets automatically, until you switch the setting off.

Can I convert a Google Sheet back to Excel?

Yes. In Google Sheets, choose File, then Download, then Microsoft Excel (.xlsx). The download creates an Excel copy. Check formatting afterward, since some Sheets features may not match perfectly in Excel.

Conclusion

Converting Excel to Google Sheets is simple: upload the file to Drive, open it with Sheets and choose Save as Google Sheets. You can also import files or turn on automatic conversion. Always check formulas, formatting and macros afterward, keep your original file as a backup, and rebuild any VBA tasks with Apps Script.

Leave a Comment