How to Convert Excel to Google Sheets: Step-by-Step Methods and Fixes

To convert Excel to Google Sheets, upload the .xlsx file to Google Drive, open it with Google Sheets, then choose File and Save as Google Sheets. That creates a separate, editable Google Sheet and leaves your original Excel file untouched. You can also import the file into an existing spreadsheet, or open it from Drive and keep it in Excel format while you work.

The conversion works well for most everyday workbooks. Complex files that use macros, Power Query or advanced charts need extra checks, because Google Sheets does not support everything Excel does. This guide walks through each method, then shows what to verify afterward and how to fix common problems.

Before You Start

  • Keep a backup. Copy the original Excel file before you convert it.
  • Use a Google account. A free personal account works, and so does a Workspace account.
  • Check the file type. Common formats are .xlsx, .xls, .xlsm, .csv and .ods. Macro-enabled files will lose their macros.
  • Note the file size. Very large workbooks may open slowly or fail, and Google publishes limits for spreadsheet size that you should check on its help pages.

Method 1: Upload to Drive and Save as a Google Sheet

This is the method most people use, and it is the closest match to the question of how to convert Excel to Google Sheets with the fewest surprises.

  1. Go to Google Drive and sign in.
  2. Select New, then File upload, and choose your Excel file. You can also drag the file into the Drive window.
  3. When the upload finishes, double-click the file. Drive usually previews it, or opens it in Sheets in compatibility mode.
  4. If the file opens with an .xlsx label next to the title, choose File, then Save as Google Sheets.
  5. A new Google Sheet opens in a new tab. The original Excel file stays in Drive as a separate item.

After conversion, the title no longer carries the .xlsx extension, and Sheets saves changes automatically.

Method 2: Import into an Existing Google Sheet

Use this when you want to add Excel data to a spreadsheet you already have.

  1. Open the target Google Sheet.
  2. Select File, then Import.
  3. Choose Upload and select your Excel file, or pick it from Drive.
  4. Choose how to import: create a new spreadsheet, insert new sheets, replace the spreadsheet, replace the current sheet, or append rows to the current sheet.
  5. Select Import data.

The import tool also accepts CSV files, where you can choose the separator and decide whether to convert text to numbers and dates.

Method 3: Open Excel Files Directly in Sheets

You can open an .xlsx file from Drive and edit it without converting it at first. Sheets edits the file and keeps the Excel format, which is handy if collaborators still use Excel. Use File, then Save as Google Sheets later if you decide to move fully to Sheets.

Method 4: Use Google Drive for Desktop

If you work with many files, Google Drive for desktop syncs a folder from your computer. Files saved there appear in Drive, and you can open them in Sheets from the browser. This works well for teams that keep Excel files in a shared folder but want to review them online.

What to Check After Conversion

Formulas

Most common functions such as SUM, VLOOKUP, IF and INDEX/MATCH convert correctly. Review any formula that returns an error, a blank cell or a different number from Excel. Functions that exist only in Excel will show an error, and some array formulas behave differently in Sheets.

Formatting

Fonts, number formats, borders and conditional formatting usually survive, but small differences in column width, theme colors and cell styles can appear. Scan each sheet quickly.

Charts

Basic charts convert, though they may change look or lose specific styling. Rebuild any chart that does not match the original.

Pivot tables

Pivot tables generally convert, but the layout and calculated fields may differ. Compare totals with the Excel version.

Data validation and drop-down lists

These usually carry over. Test each drop-down to confirm the options appear.

Dates and numbers

Date systems and regional formats can cause small shifts. Confirm your locale under File, then Settings, so dates and currency display as expected.

What Does Not Convert Well

  • VBA macros: Excel macros do not run in Google Sheets. The equivalent is Google Apps Script, which you would rewrite.
  • Power Query and Power Pivot: These data tools are not available in Sheets.
  • Some advanced chart types: Waterfall or map-style charts may differ or be missing.
  • External links: Links to other workbooks often break. Replace them with IMPORTRANGE in Sheets where needed.
  • Workbook-level features: Some Excel add-ins, custom views and form controls are not supported.

Excel Versus Google Sheets: A Quick Comparison

Topic Excel Google Sheets
Collaboration Possible through cloud storage Built in, with live editing and comments
Macros VBA Apps Script
Large data analysis Strong, with Power Query Lighter, with size limits
Offline use Native Needs offline mode set up
Access Desktop app and web Browser and mobile app

How to Fix Common Problems

The file will not open

Check that the file is not password protected or corrupted. Try opening it in Excel first and saving a fresh copy. Very large files may need to be split into smaller ones.

Formulas show errors

Click the cell to see the error message. Common causes are unsupported functions, references to other workbooks or differences in array handling. Rewrite the formula with a supported function.

Formatting looks different

Reapply number formats, column widths and fonts. Using a template in Sheets can help standardize the look.

Numbers appear as text

Select the column, choose Format, then Number, and apply the correct number type. If the cells contain extra spaces, use TRIM or VALUE to clean them.

Collaborators cannot edit

Use the Share button, add their email addresses and choose Editor access. Avoid public links unless the data is safe to share.

Converting Back From Google Sheets to Excel

If a colleague needs an Excel copy, open the Google Sheet and choose File, then Download, then Microsoft Excel (.xlsx). Check the downloaded file, since Sheets-only functions may not work in Excel.

Tips for a Smooth Switch

  1. Clean your workbook first by deleting unused sheets and blank rows.
  2. Convert a small test file before moving your most important workbook.
  3. Document any macros and plan replacements in Apps Script.
  4. Set sharing permissions carefully, especially for financial or personal data.
  5. Train your team on version history in Sheets so they can recover earlier edits.

Google publishes official help pages for Sheets and file import, which you can find through the Google Docs Editors Help center. For a story about two technology founders who built a product people used for daily work, read this profile of a BlackBerry co-founder and this one on his business partner.

Frequently Asked Questions

How do I convert an Excel file to Google Sheets?

Upload the file to Google Drive, open it with Google Sheets, then choose File and Save as Google Sheets. This makes a new, editable Google Sheet and keeps your original Excel file unchanged.

Will my Excel formulas work in Google Sheets?

Most common formulas work, including SUM, IF, VLOOKUP and INDEX/MATCH. Excel-only functions and some array formulas may show errors, so review each sheet after you convert and fix any problem cells.

Do Excel macros work in Google Sheets?

No. VBA macros do not run in Google Sheets. The closest replacement is Google Apps Script, which means rewriting the automation instead of converting it directly.

Can I convert multiple Excel files at once?

Yes. Upload several files to Drive and save each as a Google Sheet. For large batches, test one file first and check formulas and formatting before you convert the rest.

Is converting Excel to Google Sheets free?

Yes for standard use. A free Google account lets you upload and convert files, subject to Drive storage and Google’s file limits. Workspace plans add more storage and admin controls.

Can I turn a Google Sheet back into an Excel file?

Yes. Open the sheet, choose File, Download, then Microsoft Excel (.xlsx). Review the downloaded file, since some Sheets-specific features may not carry over.

Conclusion

To convert Excel to Google Sheets, upload the file to Drive, open it in Sheets and save it as a Google Sheet. Then check formulas, charts and formatting, and plan a rewrite for any macros. Keep your original file as a backup until you have confirmed that every sheet and calculation works.

Leave a Comment