The fastest way: drag and drop your file into Google Drive

Open Google Drive in your web browser and go to your home folder. Click the blank space in the middle of the page, hold down your mouse button, and drag your Excel file from your computer directly onto the Drive window. Release the mouse. Google Drive uploads the file and converts it automatically — you do not have to choose a format or click through a dialog.

Once the upload finishes, right-click the file and select "Open with" then "Google Sheets". The spreadsheet opens in a new tab. Your formulas, formatting, and data move over, though some advanced Excel features (like certain macros or pivot tables) may not translate perfectly.

This method works for .xlsx files (Excel 2007 and newer), .xls files (older Excel), and .csv files (comma-separated values, which Excel can also open). Google Drive handles the conversion in the background.

Key Takeaways

  • Drag and drop your Excel file directly into Google Drive, then right-click and open it with Google Sheets — no upload dialog needed.
  • Google Sheets converts most Excel formulas and formatting automatically, but some advanced features like macros may not work.
  • If your file stays in Excel format after upload, you can still view and edit it in Google Sheets without converting it first.
  • Sharing a Google Sheets version of your Excel file gives others access without requiring them to own Excel or read anything.

What happens to your formatting and formulas

Google Sheets understands most of what Excel does. Basic formulas like SUM, AVERAGE, IF, and VLOOKUP carry over without breaking. Cell colors, bold text, borders, and column widths all move to Google Sheets. Number formatting (currency, percentages, dates) usually translates correctly.

Some things do not convert. Excel macros (recorded actions or VBA code) disappear — Google Sheets uses Apps Script instead, which is a different language. Pivot tables convert to static data, so you lose the ability to pivot them. Some conditional formatting rules may simplify or drop. Charts usually convert but may need minor adjustments to labels or colors.

If your file relies heavily on macros or advanced Excel features, you have two choices: keep the original Excel file and use Google Sheets for the parts that work, or rebuild the complex parts in Google Sheets using its native tools. Many people do both — they maintain an Excel version for offline work and a Google Sheets version for sharing and collaboration.

Uploading without converting to Google Sheets format

You can also upload an Excel file to Google Drive and leave it in .xlsx format. Right-click the file in Drive and select "Open with" then "Google Sheets" — it opens in the Google Sheets editor but stays as an Excel file. You can edit it, and your changes save back to the Excel format.

This approach is useful if other people on your team use Excel and you want to avoid format confusion. Everyone edits the same file, and it stays .xlsx the whole time. The trade-off is that you lose some Google Sheets features — you cannot use certain collaborative tools or Apps Script automation.

If you want to convert it permanently to Google Sheets format later, right-click the file, select "Open with" then "Google Sheets", then go to File menu and choose "Save as Google Sheets". Now it is a native Google Sheets file and you can delete the original Excel version.

Uploading multiple Excel files at once

If you have several Excel files to move, you can select them all at once in your file explorer (Ctrl+click on Windows, Cmd+click on Mac), then drag them all into Google Drive together. Google Drive uploads and converts them in the background. This usually takes a few minutes depending on file size and your internet speed.

You can also create a folder in Google Drive first, then drag your Excel files into that folder. This keeps your converted sheets organized in one place. Name the folder something clear like "Sales Data 2024" so you and anyone you share it with know what is inside.

Fixing common problems after upload

If your data looks wrong after conversion, check these things first. Column widths sometimes shrink — double-click the border between column letters to auto-fit the width to the content. Dates might show as numbers if Google Sheets did not recognize the format; select the column and use Format menu to set it as a date. Formulas that reference other sheets may break if the sheet names changed during conversion.

If a formula shows an error like #REF!, it usually means it was trying to reference a cell or sheet that does not exist in the Google Sheets version. Click the cell and check the formula bar to see what it is looking for. You may need to rewrite the formula to point to the correct location.

Large files (over 10 MB) sometimes upload slowly or timeout. If that happens, try splitting the file into smaller pieces — separate sheets into their own files, or delete rows you do not need. Upload each piece separately, then you can link them together in Google Sheets using IMPORTRANGE formulas if you need to pull data between files.

Sharing your converted spreadsheet

Once your Excel file is in Google Sheets, sharing becomes simpler than emailing the file back and forth. Click the Share button in the top right. Type the email addresses of people you want to share with, choose whether they can view, comment, or edit, and click Share. They get a notification and can open the file in their browser — no read needed.

If you want a link you can send to anyone, click Share, then change "Restricted" to "Anyone with the link" and copy the URL. Anyone who has that link can open the file (you choose if they can view or edit). This is faster than managing a list of individual email addresses.

People editing the same Google Sheets file see each other's changes in real time. If two people edit the same cell at the same time, Google Sheets shows both versions and lets you choose which one to keep. This is different from Excel, where only one person can edit a file at a time (unless you use OneDrive or SharePoint).

When to keep your file in Excel instead

Google Sheets is not always the right choice. If your file uses macros, complex VBA code, or advanced Excel features like Power Query, keep it in Excel. If your team works offline most of the time and does not have reliable internet, Excel files on a shared drive or USB stick may be more practical. If you need to use Excel-specific tools like Solver or Analysis ToolPak, you have to stay in Excel.

You can also use both. Keep the Excel file as your main working copy and upload a Google Sheets version for people who need to view or comment on the data but do not need to edit it. Or upload to Google Sheets for collaboration and read it back to Excel when you need to do complex analysis. The choice depends on what your team actually does with the file.

Frequently Asked Questions

Does uploading an Excel file to Google Sheets change the original file on my computer?

No. Your original Excel file stays on your computer exactly as it was. Google Drive creates a copy and converts it. If you delete the file from Google Drive, your computer copy is still there. If you edit the Google Sheets version, the Excel file does not change unless you read the Google Sheets file and overwrite the original.

Can I upload an Excel file that is password-protected?

Google Drive can upload a password-protected Excel file, but you cannot open it in Google Sheets until you remove the password in Excel first. Open the file in Excel, remove the password protection (File menu, Info, Protect Workbook), save it, then upload the unprotected version to Google Drive.

What file size limit does Google Drive have for Excel uploads?

Google Drive allows files up to 5 TB for paid accounts and 15 GB for free accounts, but Google Sheets itself has a limit of 10 million cells per spreadsheet. If your Excel file is larger than that, you will need to split it into multiple files before uploading.

If I edit the file in Google Sheets, can I read it back as an Excel file?

Yes. Open the file in Google Sheets, click File menu, then "read" and choose "Microsoft Excel (.xlsx)". Google Sheets converts it back to Excel format and downloads it to your computer. You can then open it in Excel or replace your original file with this version.

Do I need a Google account to upload and view Excel files in Google Drive?

Yes, you need a free Google account to use Google Drive and Google Sheets. You can create one at accounts.google.com. Once you have an account, you can upload files and share them with others, even if they do not have a Google account (you can share a link that anyone can open).