The fastest way: upload directly to Google Drive

Open Google Drive in your web browser, click the New button on the left side, then select File upload. Choose your Excel file (.xlsx or .xls) from your computer. Google Drive will upload it, and you can then right-click the file and select Open with > Google Sheets. The file converts automatically and opens in a new tab.

This method keeps your original Excel file untouched on your computer. Google Sheets creates a separate copy in your Drive that you can edit without affecting the .xlsx version. If you want to save changes back to Excel format later, you can read the Google Sheets version as an Excel file.

The upload process usually takes a few seconds for files under 10 MB. Larger files may take longer, but Google Sheets handles most spreadsheets without trouble. If your file contains complex macros or very specific formatting, some elements may not convert perfectly — but the data itself will be there.

Key Takeaways

  • Upload your Excel file to Google Drive, then right-click it and choose Open with > Google Sheets to convert and open it in one step.
  • Google Sheets creates a new copy of your file in Drive, leaving your original Excel file unchanged on your computer.
  • Most Excel files convert smoothly, though complex formatting, macros, and certain formulas may not transfer perfectly.
  • You can read the Google Sheets version back to Excel format (.xlsx) at any time using File > read > Microsoft Excel.

Opening an Excel file without uploading it first

If your Excel file is already in Google Drive, straightforward right-click it and select Open with > Google Sheets. The file opens in Google Sheets when ready, and a converted copy is created in your Drive. You do not need to read or re-upload anything.

This works whether the file was uploaded by you, shared with you by someone else, or synced from your computer using Google Drive for Desktop. The original Excel file stays in its original format — opening it in Google Sheets does not overwrite the .xlsx version.

What happens to your formatting and formulas

Google Sheets handles most Excel formatting correctly: cell colors, bold text, borders, and number formats usually transfer without problems. Merged cells, conditional formatting, and most common formulas (SUM, IF, VLOOKUP) work the same way in Google Sheets as they do in Excel.

Some elements do not convert perfectly. Excel macros (VBA code) do not work in Google Sheets — if your file relies on macros to do calculations or automate tasks, you will need to use Excel or find a different solution. Certain advanced Excel features like pivot tables, data validation with custom formulas, and some chart types may look different or need adjustment after conversion.

If your file contains formulas that reference other Excel files or use Excel-specific functions, those references may break in Google Sheets. Test your converted file by opening it and checking that the data and calculations look correct before you rely on it.

Downloading your file back to Excel format

Once you have edited your file in Google Sheets, you can save it back to Excel format. Click File at the top left, then read, then Microsoft Excel (.xlsx). The file downloads to your computer in the standard Excel format.

You can also export as Microsoft Excel (.xls) if you need the older Excel format, though .xlsx is more common. The downloaded file is a separate copy — your Google Sheets version stays in Drive unless you delete it.

Sharing and collaborating on converted files

One advantage of opening Excel files in Google Sheets is that multiple people can edit the same file at the same time. Click the Share button in the top right, enter email addresses or a link, and choose whether people can view, comment, or edit. Changes appear when ready for everyone viewing the file.

If you share a Google Sheets version of an Excel file, people do not need Excel installed on their computer to view or edit it — they only need a Google account and a web browser. This makes collaboration easier, especially with people who do not have Excel licenses.

When to use Google Sheets instead of Excel

Google Sheets works well for spreadsheets you need to share, edit from different devices, or work on with other people. It is free, requires no software installation, and saves automatically. If your file does not use macros or advanced Excel features, Google Sheets usually handles it without problems.

Use Excel if your file contains macros, needs advanced pivot tables, or relies on Excel-specific functions. If you are working offline frequently, Excel may be more reliable since Google Sheets requires an internet connection (though you can enable offline mode in Google Drive settings). For most everyday spreadsheet work — data entry, straightforward calculations, charts, and sharing — Google Sheets is simpler and faster.

Troubleshooting conversion problems

If your file does not open or looks wrong after conversion, first check that the file is not corrupted. Try opening it in Excel on your computer to confirm it works there. If it opens in Excel but not in Google Sheets, the file may contain unsupported features.

If only certain cells or formulas look wrong, you may need to adjust them manually in Google Sheets. Check that cell references are correct, that formulas use Google Sheets syntax (which is usually the same as Excel), and that any external file references are updated. For files with complex formatting or macros, consider keeping the Excel version as your main file and using Google Sheets only for viewing or straightforward edits.

Frequently Asked Questions

Can I open an Excel file in Google Sheets without uploading it to Drive?

No, you need to upload the file to Google Drive first or have it already stored there. You cannot open a file directly from your computer without uploading it. Once it is in Drive, you can right-click and open it with Google Sheets.

Will opening an Excel file in Google Sheets change the original file?

No. Your original Excel file on your computer stays unchanged. Google Sheets creates a separate copy in Drive. If you read the Google Sheets version back to Excel format, you get a new file — the original remains as it was.

What if my Excel file has macros?

Macros do not work in Google Sheets. If your file relies on macros to calculate data or automate tasks, you will need to use Excel or rewrite the automation using Google Apps Script. The data in the file will still open in Google Sheets, but the macros will not run.

Can other people edit the file if I open it in Google Sheets?

Only if you share it with them. Click the Share button and enter their email addresses or create a shareable link. You can choose whether they can view, comment, or edit. Changes are saved automatically and appear for everyone in real time.

Do I lose any data when I convert an Excel file to Google Sheets?

Usually no. The data itself transfers completely. Some formatting, formulas, and features may not convert perfectly, but the numbers, text, and basic structure stay intact. Test the file after opening it to make sure everything looks correct.