sodcalculator

10 Tech How-To

How to Import Excel to Google Sheets

Guide 10-54527 · Updated · Step by step

Importing an Excel file into Google Sheets lets you work with your data online, collaborate in real time, and access it from any device without losing your original formatting. This guide walks you through the entire process, from uploading the file to cleaning up any conversion issues, so you can switch seamlessly.

What You’ll Need

  • A Google account (free) to access Google Drive and Google Sheets.
  • The Excel file you want to import, saved as .xlsx, .xls, .csv, or .ods.
  • An internet connection and a web browser (Chrome, Firefox, Safari, or Edge).

Step-by-Step

  1. Open Google Sheets – Go to sheets.google.com in your browser and sign in with your Google account. If you’re already in Google Drive, you can skip to step 2.
  2. Start a new import – Click the folder icon in the top-right corner (next to the Google Sheets logo) or go to File > Import. Alternatively, you can drag and drop the Excel file directly onto the Google Sheets homepage.
  3. Choose your file – In the file picker, navigate to your Excel file. You can also click Upload tab and drag the file from your computer. Select the file and click Open or Upload.
  4. Select import options – After uploading, a dialog box appears with options:
    • Create new spreadsheet – Makes a brand new Google Sheets file with the imported data.
    • Insert new sheet(s) – Adds the data as a new tab in your current spreadsheet.
    • Replace spreadsheet – Overwrites the current sheet with the imported data (use carefully).
    • Replace current sheet – Replaces only the active tab.

    Choose the option that fits your needs. For most cases, Create new spreadsheet is safest.

  5. Click “Import data” – Once you’ve selected the option, click the blue Import data button. Google Sheets will process the file and open your new spreadsheet.
  6. Check the result – Review the imported data. Look for any missing columns, broken formulas, or formatting issues. Google Sheets usually converts Excel formulas, but some advanced functions may not work.
  7. Clean up formatting – If the original Excel file had specific fonts, colors, or conditional formatting, you may need to reapply them in Google Sheets. Use Format > Conditional formatting to recreate rules.
  8. Save and share – Google Sheets autosaves to Google Drive. To share, click the Share button in the top-right and add collaborators with appropriate permissions.

Common Mistakes

  • Choosing “Replace spreadsheet” accidentally – This overwrites your existing Google Sheets data. Always double-check the import option before clicking.
  • Ignoring file size limits – Google Sheets can handle up to 10 million cells, but very large files may slow down or fail. If your Excel file is huge, consider splitting it into smaller parts.
  • Forgetting to check formulas – Some Excel functions like VLOOKUP work fine, but array formulas or macros (VBA) will not transfer. You’ll need to recreate those manually.
  • Not converting .xls files – Older .xls files (Excel 97-2003) sometimes import with quirks. Save them as .xlsx in Excel first for best results.

Tips

  • Use File > Import in an existing Google Sheet to merge data into a specific location, rather than creating a new file every time.
  • If you have multiple Excel files, you can upload them all to Google Drive first, then right-click each and choose Open with > Google Sheets.
  • For CSV files, Google Sheets will automatically parse commas and put data into columns. Make sure your CSV uses UTF-8 encoding to avoid character issues.
  • After importing, use File > Version history to track changes if you’re collaborating.

Troubleshooting

  • File won’t upload – Check that the file is not corrupted and is under the 100 MB limit for spreadsheets. Try converting the file to .xlsx or .csv and upload again.
  • Data appears in one column – This often happens with CSV files that use semicolons instead of commas. Open the file in a text editor, replace semicolons with commas, and re-import.
  • Formulas show errors – Some Excel functions like IFERROR work, but others like INDEX(MATCH()) may need adjustment. Replace unsupported functions with Google Sheets equivalents (e.g., FILTER instead of array formulas).
  • Formatting looks off – Google Sheets doesn’t support all Excel formatting (e.g., certain chart types). Use Format > Clear formatting to start fresh, then reapply styles manually.
  • File is too large – Split the data into multiple sheets or use Google Sheets’ File > Import to append data in chunks.

Frequently Asked Questions

Can I import an Excel file with macros?

No, macros (VBA code) are not supported in Google Sheets. You’ll need to recreate the functionality using Google Apps Script or manual steps.

Will my Excel charts transfer?

Basic charts usually import as images or simple charts, but complex chart types may not convert perfectly. You may need to recreate them in Google Sheets.

Can I edit the imported file in Excel later?

Yes, you can download the Google Sheet as an Excel file by going to File > Download > Microsoft Excel (.xlsx).

How do I import a password-protected Excel file?

Google Sheets cannot open password-protected files. Remove the password protection in Excel first, then import.

What happens to conditional formatting?

Simple conditional formatting rules usually transfer, but complex rules with custom formulas may not. Check and reapply them if needed.

Can I import multiple sheets from one Excel file?

Yes, Google Sheets will create separate tabs for each sheet in the Excel file. Choose the “Insert new sheet(s)” option to keep them all.

Related

General steps for current mainstream versions; menus can differ by device and version. See the disclaimer or report an error.

More in this bed

The whole Tech How-To bed →