The fastest way: drag and drop into Google Drive

Open Google Drive in your browser, then drag your Excel file directly onto the page. Google Sheets will convert it automatically and open it in a new tab. The file stays in your Drive, and you can start editing right away. This works for .xlsx, .xls, and .csv files.

If you're already in Google Sheets, you can also go to File > Open, click the Upload tab, and select your Excel file from your computer. Google Sheets converts it during the upload.

Key Takeaways

  • Dragging an Excel file into Google Drive is the quickest method and requires no special steps or settings.
  • Google Sheets preserves most formatting, formulas, and data when converting Excel files, though some advanced features may not transfer.
  • You can open an Excel file without converting it by using the preview feature in Google Drive, but you cannot edit it that way.
  • After conversion, your Google Sheets file and your original Excel file remain separate — changes in one do not affect the other.
  • Shared Excel files from OneDrive or Dropbox can be opened directly in Google Sheets using the file's web link.

What happens to your formatting and formulas

Google Sheets handles most Excel formatting during conversion: colors, bold text, borders, and number formats usually transfer without problems. Formulas convert as well, including common functions like SUM, IF, VLOOKUP, and AVERAGE.

Some advanced Excel features do not convert. Pivot tables become static data, macros are removed, and certain conditional formatting rules may not carry over. Charts convert to Google Sheets charts, which work differently but display your data. If your file relies heavily on these features, you may need to rebuild parts of it after conversion.

Opening an Excel file without converting it

If you want to view an Excel file in Google Drive without converting it to Google Sheets, right-click the file and select Open with > Google Sheets. This opens a preview you can read but not edit. The original Excel file stays unchanged in your Drive.

This approach is useful if you only need to check data quickly or if you want to keep your Excel file as the main version. To make edits, you will need to convert it or download it and open it in Excel or another spreadsheet program.

Converting files from cloud storage

If your Excel file is stored in OneDrive, Dropbox, or another cloud service, you can open it directly in Google Sheets without downloading it first. In Google Drive, click New > File upload, or paste the file's web link into the address bar if the service supports direct links. Google Sheets will fetch and convert the file.

Some services let you right-click the file and choose Open with Google Sheets directly. This creates a converted copy in your Google Drive while leaving the original file untouched in its original location.

Keeping your Excel file and Google Sheets version in sync

Once you convert an Excel file to Google Sheets, the two files are separate. Changes you make in Google Sheets do not update the Excel file, and vice versa. If you need both versions to stay current, you will have to manually download the Google Sheets file as Excel and replace the old one, or vice versa.

For ongoing collaboration, decide which version your team will use going forward. If you choose Google Sheets, download the Excel file one final time and archive it. If you keep Excel as your main file, download updates from Google Sheets periodically. Trying to maintain both creates confusion and version conflicts.

Troubleshooting common conversion problems

If your Excel file does not upload, check the file size — Google Drive has a 5 TB limit per file, but very large spreadsheets may time out during conversion. Try splitting the file into smaller sheets or removing unnecessary data before uploading.

If formulas show errors after conversion, check whether they reference external files or use Excel-specific functions that Google Sheets does not support. INDIRECT, OFFSET, and some array formulas may need adjustment. Look at the formula bar to see what changed, and rewrite it using Google Sheets syntax if needed. If charts look wrong, click on them and check the data range — sometimes the conversion shifts the range slightly.

Frequently Asked Questions

Can I edit an Excel file directly in Google Drive without converting it?

No. You can preview an Excel file in Google Drive, but you cannot edit it without converting it to Google Sheets first. If you convert it, the original Excel file stays in your Drive unchanged.

What file formats does Google Sheets accept?

Google Sheets converts .xlsx (modern Excel), .xls (older Excel), .csv (comma-separated values), .ods (OpenDocument), and .tsv (tab-separated values) files. Upload them the same way — drag into Drive or use File > Open > Upload.

Will my Excel macros work in Google Sheets?

No. Google Sheets does not support Excel macros. If your file relies on macros to automate tasks, you will need to recreate that logic using Google Apps Script or find a workaround using Google Sheets' built-in functions.

Can I convert a Google Sheets file back to Excel?

Yes. Open the Google Sheets file, go to File > Download, and choose Microsoft Excel (.xlsx). The file downloads to your computer as an Excel file that you can open, edit, and save in Excel or another spreadsheet program.

What happens if I share an Excel file link with someone who has Google Sheets?

If you share a link to an Excel file stored in Google Drive, the person can preview it or convert it to Google Sheets by opening it with Google Sheets. They cannot edit the Excel file directly without converting it first.