You can open an Excel file directly in Google Sheets without converting it first

Google Sheets can read Excel files (.xlsx and .xls formats) and open them as editable spreadsheets. You do not need to convert the file beforehand or use any third-party tools. The process takes about 30 seconds and preserves most of your formatting, formulas, and data — though some advanced Excel features may not translate perfectly.

The simplest route is to drag your Excel file into Google Drive, then open it from there. If your file is already on your computer, you can also upload it directly through Google Sheets itself. Both methods land you in the same place: a working spreadsheet you can edit, share, and save to the cloud.

Key Takeaways

  • Drag an Excel file into Google Drive, then double-click it to open it in Google Sheets without any conversion step.
  • You can also go to sheets.google.com, click the folder icon, select "Upload," and choose your Excel file to open it the same way.
  • Google Sheets preserves formulas, cell formatting, and most data, but some Excel-specific features like macros and certain chart types will not transfer.
  • Once open in Google Sheets, you can edit the file, save it as a Google Sheet, or download it back to Excel format whenever you need to.

Opening an Excel file by dragging it into Google Drive

Go to drive.google.com and sign in with your Google account. Open a new browser tab or window so you can see both Google Drive and your file folder at the same time. Locate your Excel file on your computer — it will have a name ending in .xlsx or .xls — and drag it directly into the Google Drive window.

Google Drive will upload the file and show you a progress bar. Once the upload finishes, the file appears in your Drive with an Excel icon next to its name. Double-click the file to open it. Google Sheets will load automatically, and your spreadsheet is ready to edit. You do not need to do anything else — Google Sheets handles the opening without asking you to convert or confirm anything.

Opening an Excel file through Google Sheets directly

If you prefer to stay in Google Sheets from the start, go to sheets.google.com and sign in. You will see a gallery of templates and a row of icons at the top left. Click the folder icon (it looks like an open file folder) to browse your files.

A menu will appear with options including "Upload." Click "Upload," then select "Files" from the submenu. A file browser window opens. Navigate to your Excel file, click it once to select it, then click "Open" at the bottom right of the window. Google Sheets uploads the file and opens it in the editor automatically. This method works the same way as dragging, just with a few more clicks.

What happens to your Excel formatting and formulas

Google Sheets converts most of what is in your Excel file. Cell values, text formatting (bold, italic, colors), column widths, and formulas all carry over. If your spreadsheet uses basic functions like SUM, AVERAGE, or IF statements, they will work exactly as they did in Excel.

Some things do not translate. Excel macros (automated scripts you recorded in Excel) will not run in Google Sheets — you would need to rewrite them using Google Sheets' scripting language if you need that functionality. Certain chart types, pivot table layouts, and conditional formatting rules may look different or need adjustment. If your file uses these advanced features heavily, open it in Google Sheets first to see what needs fixing before you rely on it for important work.

Saving your file after opening it in Google Sheets

When you open an Excel file in Google Sheets, you are working with a copy. Google Sheets saves your changes automatically to Google Drive — you do not need to click a save button. If you want to keep the file in Excel format on your computer, download it back to .xlsx before you close the tab.

To download, click the "File" menu at the top left, then hover over "Download" and select "Microsoft Excel (.xlsx)." A file will download to your computer in the same format you started with. If you want to keep both versions — one in Google Drive and one on your computer — download it. If you only need the Google Sheets version, you can delete the original Excel file from your computer to avoid confusion about which version is current.

When to convert your file to Google Sheets format

You do not have to convert your file. Google Sheets opens and edits Excel files without conversion. However, if you plan to share the file with others through Google Drive, or if you want to use Google Sheets' collaboration features (like real-time editing with multiple people), converting to Google Sheets format makes those features work better.

To convert, open your Excel file in Google Sheets, then go to "File" > "Save as Google Sheet." Google Sheets creates a new file in its native format and leaves your original Excel file untouched. From that point on, you are working in Google Sheets, and you would need to download it again if you want an Excel version. This is useful if you are moving away from Excel entirely, but unnecessary if you just need to view or make quick edits.

Troubleshooting when your file will not open

If you drag a file into Google Drive and it does not open in Google Sheets, the file may be corrupted or in a format Google Sheets does not recognize. Try downloading the file again from wherever you got it, then upload the fresh copy. If the file name ends in something other than .xlsx or .xls (like .xlsm, which is an Excel file with macros), Google Sheets may open it as a download instead of an editor. Rename the file to end in .xlsx and try again.

If you see an error message about permissions, make sure you are signed into Google with an account that has storage space available. Google Drive free accounts include 15 GB of storage shared across Drive, Gmail, and Photos. If you are out of space, delete files you no longer need or upgrade to a paid plan. Once you have space, try uploading again.

Frequently Asked Questions

Will my Excel file be changed if I open it in Google Sheets?

No. Opening an Excel file in Google Sheets creates a copy in Google Drive. Your original file on your computer stays exactly as it was. If you make changes in Google Sheets and want to keep them, you must download the file back to Excel format, which overwrites the original only if you choose to save it in the same location.

Can I open a file that is already in Google Drive?

Yes. If your Excel file is already uploaded to Google Drive, just double-click it. Google Sheets opens automatically. You do not need to upload it again or use any special steps.

What if my spreadsheet has multiple sheets or tabs?

Google Sheets preserves all of them. When you open an Excel file with multiple sheets, each sheet appears as a tab at the bottom of the Google Sheets editor, just like in Excel. You can click between them and edit each one the same way.

Can I share an Excel file opened in Google Sheets with other people?

Yes. Click the "Share" button at the top right, enter the email addresses of people you want to share with, and choose whether they can view, comment, or edit. They will see the file in Google Sheets format. If they need an Excel version, they can download it themselves from the File menu.

What happens to formulas that reference other Excel files?

Formulas that reference cells within the same file work normally. Formulas that link to other Excel files on your computer will break, because Google Sheets cannot access files on your local hard drive. You would need to upload those other files to Google Drive and update the formula references to point to the Google Sheets versions instead.