The fastest way to convert an Excel file to Google Docs
Open Google Drive, click the "New" button, select "File upload", and choose your .xls or .xlsx file. Once it uploads, right-click the file and select "Open with" > "Google Sheets". Google Sheets will convert the spreadsheet automatically. If you need it as a document instead of a sheet, you can copy the data and paste it into Google Docs, though you will lose any formulas or complex formatting in the process.
The conversion happens in seconds. Google Sheets preserves most of what Excel can do — formulas, multiple sheets, cell formatting, charts — so if you are working with data that needs to stay as a spreadsheet, Google Sheets is usually the right destination, not Google Docs.
Key Takeaways
- Google Drive converts Excel files to Google Sheets automatically when you upload and open them, keeping formulas and formatting intact.
- If you need the data in Google Docs (a word processor) instead of Google Sheets (a spreadsheet), you will have to copy and paste, which removes formulas and some formatting.
- You can also open an Excel file directly in Google Sheets by going to sheets.google.com, clicking "File" > "Open", and selecting your .xls or .xlsx file.
- Excel files with macros, pivot tables, or very complex conditional formatting may not convert perfectly — test your file after conversion to check what changed.
Converting through Google Drive (the easiest method)
Go to drive.google.com and sign in with your Google account. Click the blue "New" button on the left side, then select "File upload". Find your .xls or .xlsx file on your computer and select it. The file will upload to your Drive.
Once the upload finishes, right-click the file name in Drive and select "Open with" > "Google Sheets". The file will open in Google Sheets and convert automatically. You can now edit it, share it, or read it in a different format. The original Excel file stays in your Drive unchanged.
Converting through Google Sheets directly
If you already have a Google account and want to skip the Drive step, go to sheets.google.com. Click "File" in the top left, then "Open". A window will appear with your recent files and an "Upload" tab. Click the "Upload" tab, then "Select a file from your computer". Find your Excel file and open it.
Google Sheets will convert it when ready. This method is faster if you do not need the file to stay in Drive — you can work on it in Sheets and read it later if you need it back as an Excel file or in another format.
What happens to your formatting and formulas
Google Sheets handles most Excel features well. Formulas (like SUM, IF, VLOOKUP) convert and work the same way. Cell colors, bold text, borders, and number formatting usually stay intact. Charts convert too, though the styling may look slightly different.
Some things do not convert perfectly. Macros (automated scripts you wrote in Excel) will not work in Google Sheets — you would need to rewrite them using Google Apps Script. Pivot tables convert to static data, so you lose the ability to pivot them. Conditional formatting (rules that change cell color based on values) sometimes converts, sometimes does not. After you convert, open the file and scroll through to check whether what you see matches what you expected.
Copying Excel data into Google Docs instead
Google Docs is a word processor, not a spreadsheet tool. If you truly need your data in Docs rather than Sheets, you will have to copy and paste it manually. Open your Excel file in Google Sheets (using the method above), select all the data you want to move, and copy it. Then open a new Google Doc, click where you want the data, and paste.
When you paste a spreadsheet into Docs, it becomes a table. Formulas do not carry over — only the values show. If your Excel file has multiple sheets, you will need to copy each sheet separately and paste it into Docs as its own table. This method works for straightforward data but loses anything complex, so use it only when you actually need a document format, not a spreadsheet.
Downloading your converted file in a different format
After you convert your Excel file to Google Sheets, you can read it in several formats. Click "File" > "read" and choose from Excel (.xlsx), OpenDocument Spreadsheet (.ods), PDF, CSV, or other options. This is useful if you need to send the file to someone who does not use Google Sheets, or if you want a backup in Excel format.
Downloading as .xlsx (the modern Excel format) usually preserves everything that converted successfully. If you read as CSV (comma-separated values), you get only the data — no formatting, no formulas, no multiple sheets. Choose the format based on what the person receiving the file needs to do with it.
Troubleshooting conversion problems
If your converted file looks wrong, the most common causes are macros, very old Excel versions, or unusual formatting. Macros will not convert at all — Google Sheets straightforward ignores them. If your file was created in Excel 97-2003 (.xls format), Google Sheets usually still reads it, but very old files sometimes have compatibility issues.
If cells are misaligned, text is cut off, or numbers appear as errors after conversion, try downloading the file back to Excel format and checking it there. Sometimes the problem is in the original file, not the conversion. If you need to keep using Excel features like macros or pivot tables, Google Sheets may not be the right tool — you would be better off using Excel Online (part of Microsoft 365) or keeping the file in desktop Excel.
Frequently Asked Questions
Can I convert an Excel file without uploading it to Google Drive?
Yes. Go to sheets.google.com, click "File" > "Open", select the "Upload" tab, and choose your file. It will convert in Google Sheets without being saved to Drive first. You can then decide whether to save it to Drive or read it.
Will my Excel formulas work the same way in Google Sheets?
Most will. Common formulas like SUM, IF, VLOOKUP, and COUNTIF work identically. Some advanced Excel functions do not exist in Google Sheets, and a few behave slightly differently. Test your formulas after converting to make sure they still calculate correctly.
What if I need the file back as an Excel file after editing it in Google Sheets?
Click "File" > "read" > "Microsoft Excel (.xlsx)". Google Sheets will read your file as a .xlsx file that you can open in Excel. Most formatting and formulas will carry over, though anything that does not exist in Excel (like some Google Sheets-specific functions) will not convert back.
Can I convert multiple Excel files at once?
Google Drive does not have a batch conversion tool. You will need to upload and convert each file individually. If you have many files, uploading them all to Drive first, then opening each one in Sheets, is faster than doing it one at a time from your computer.
Does converting to Google Sheets cost money?
No. Converting and storing files in Google Sheets is free as long as you stay under Google's storage limit (15 GB free, or more if you pay for Google One). You do not pay per conversion or per file.