The fastest way to move your spreadsheet

You can convert an Excel file to Google Sheets in three ways: upload it directly to Google Drive and open it as a Sheet, use Google Sheets' import function, or open Excel in Google Sheets and save it there. The simplest route is uploading to Drive — Google converts the file automatically and you can start editing right away. All three methods preserve your data, formulas, and basic formatting, though complex Excel features like macros and some conditional formatting may not transfer perfectly.

The conversion itself is free and takes less than a minute for most files. You do not need to install anything or use a third-party tool. Your original Excel file stays on your computer or in your cloud storage — Google Sheets creates a separate copy that lives in your Google Drive.

Key Takeaways

  • Uploading your Excel file to Google Drive and opening it as a Sheet is the fastest method and requires only a Google account.
  • Google Sheets preserves data, formulas, and basic formatting, but Excel-only features like macros and some chart types will not transfer.
  • Your original Excel file remains unchanged — the conversion creates a new file in Google Drive.
  • If your spreadsheet uses advanced Excel features, test the converted version before deleting the original.
  • You can convert back to Excel anytime by downloading the Sheet as an .xlsx file.

Method 1: Upload to Google Drive and convert automatically

Go to drive.google.com and sign in with your Google account. Click the New button on the left side, then select File upload. Find your Excel file (.xlsx or .xls) on your computer and open it. Google Drive uploads the file and shows it in your file list with an Excel icon.

Right-click the uploaded file and select Open with, then choose Google Sheets. Google converts the file and opens it in the Sheets editor. The file now appears in your Drive with a Sheets icon and a new name — usually your original filename with no change to the extension. You can rename it by right-clicking and selecting Rename.

This method works for files up to 5 million cells. If your file is larger, Google Drive will reject it. For very large spreadsheets, you may need to split the data across multiple Sheets or use a different tool.

Method 2: Use Google Sheets' import function

Go to sheets.google.com and click Create new spreadsheet or open an existing Sheet. Click File in the menu, then select Import. A dialog box appears with three tabs: Upload, Search, and By URL.

Click the Upload tab and select your Excel file from your computer. Google shows you import options: you can replace the current sheet, insert the data into a new sheet, or create a new spreadsheet. Choose your preference and click Import data. Google converts the file and places it where you specified.

This method is useful if you already have a Google Sheet open and want to add Excel data to it. The import function also lets you import from a URL or search Google Drive for a file you have already uploaded.

Method 3: Open Excel directly in Google Sheets

If your Excel file is already in Google Drive, you can open it directly in Google Sheets without uploading again. Right-click the file and select Open with, then choose Google Sheets. Google opens the file in the Sheets editor and converts it on the fly.

This method does not create a separate copy — you are viewing and editing the original file as a Sheet. If you want to keep both an Excel and a Sheets version, read the converted file as a new .xlsx file instead of editing the original.

What transfers and what does not

Google Sheets handles most of what Excel can do, but not everything. Your data, cell values, and basic formulas transfer perfectly. Formatting like bold, italics, colors, and borders stays intact. Named ranges, data validation, and most functions work the same way. Charts convert to Google Sheets charts, though the appearance may change slightly.

Excel features that do not transfer include macros (VBA code), some conditional formatting rules, certain chart types, and password protection. Pivot tables convert to static data, so you lose the ability to pivot them — you can rebuild them in Google Sheets if you need to. Some complex formulas that use Excel-specific functions may break and show an error. If your spreadsheet relies on these features, test the converted version before relying on it.

You can see a detailed conversion report by opening the file in Google Sheets and clicking File, then See version history. This shows you when the file was converted and any issues Google encountered.

How to keep both Excel and Google Sheets versions

If you want to work in Google Sheets but keep your original Excel file, convert the file and leave the original where it is. Your Excel file on your computer or in OneDrive does not change when you convert it to Sheets. You now have two separate files: the original Excel file and the new Google Sheets version in your Google Drive.

To create an Excel copy from Google Sheets, open the Sheet and click File, then read. Select Microsoft Excel (.xlsx). Google downloads the Sheet as an Excel file to your computer. You can now have both versions and edit them separately.

If you edit the Google Sheets version and want to update the Excel file, read it again. The two files do not sync automatically — changes in one do not appear in the other.

Troubleshooting conversion problems

If your file does not convert or shows errors, first check the file size. Google Sheets has a limit of 5 million cells and 10 million cells per spreadsheet. If your file is close to these limits, delete unused rows and columns before converting.

If formulas show errors after conversion, check whether they use Excel-only functions. Google Sheets supports most common functions like SUM, AVERAGE, and VLOOKUP, but some advanced functions may not exist in Sheets. Open the file in Google Sheets and look for cells showing #NAME? error — this means the function is not recognized. You may need to rewrite the formula using Sheets equivalents.

If formatting looks wrong, Google Sheets may have dropped some conditional formatting or cell styles. Check the original file in Excel and the converted version side by side. You can reapply formatting manually in Google Sheets if needed.

Frequently Asked Questions

Can I convert an Excel file without uploading it to Google Drive?

No, you need a Google account and Google Drive to convert Excel to Sheets. You can use the free tier of Google Drive, which gives you 15 GB of storage. If you do not want to use Google Drive, you would need a different tool or service.

What happens to my original Excel file after I convert it?

Your original file stays exactly where it is and does not change. If the file is on your computer, it remains there. If it is in OneDrive or Dropbox, it stays there. Converting to Google Sheets creates a new file in Google Drive — it does not modify or delete the original.

Can I convert a Google Sheet back to Excel?

Yes. Open the Google Sheet, click File, then read. Select Microsoft Excel (.xlsx). Google downloads the Sheet as an Excel file to your computer. You can now open it in Excel or any spreadsheet program.

Will my Excel macros work in Google Sheets?

No, Google Sheets does not support Excel macros or VBA code. If your spreadsheet relies on macros, they will not transfer. You can use Google Apps Script to automate tasks in Sheets, but you would need to rewrite the logic from scratch.

What if my file is too large to convert?

If your file exceeds 5 million cells, Google Drive will reject it. Split the data across multiple files or remove unused rows and columns. You can also try opening the file in Excel, deleting unnecessary sheets, and saving a smaller version before converting.