Import Excel to Google Sheets via CSV — Free Converter

Google Sheets and Excel should be best friends. They speak the same spreadsheet language, right? In practice, importing a .xlsx file into Google Sheets often causes formatting problems, formula errors, and missing data. The reliable workaround that everyone eventually discovers: convert Excel to CSV first, then import the CSV into Google Sheets. It works perfectly every time.

This guide shows you why CSV is the better bridge format and how to do the conversion free in your browser — no Excel license, no Google account tricks required.

Why Google Sheets Prefers CSV Over Direct Excel Import

Google Sheets can open .xlsx files directly, but "open" does not mean "import cleanly." Here is what commonly breaks when you skip the CSV step:

• Conditional formatting and data validation rules — Google Sheets interprets these differently from Excel and often drops or corrupts them
• Custom number formats — Excel's regional formats (currency symbols, date patterns) do not always translate to Sheets equivalents
• Embedded objects and shapes — anything that is not raw cell data gets ignored or misplaced
• Named ranges and structured references — Excel table references like Table1[Column] become plain text in Sheets

CSV strips all of that out. What you get is clean rows and columns of data — exactly what Sheets wants. Once the data is in Sheets, you can rebuild any formatting or formulas using native Sheets tools, and they will work correctly.

For pure data work — moving a dataset, sharing numbers with someone on Sheets, feeding data into a Sheets-based dashboard — CSV is the right format. It is smaller, faster to import, and produces zero surprises.

Step-by-Step: Excel to CSV to Google Sheets

The whole workflow takes about a minute.

Step 1 — Convert Excel to CSV in your browser

Open the free Excel to CSV converter and drag your .xlsx or .xls file onto it. No file is uploaded to any server — processing happens entirely in your browser using the SheetJS engine.

If your workbook has multiple sheets, a sheet picker appears. Select the sheet containing the data you want to import into Google Sheets. Click Download CSV to save it to your computer.

Step 2 — Import the CSV into Google Sheets

1. Open Google Sheets and create a new blank spreadsheet, or open an existing one
2. Click File in the top menu
3. Select Import
4. Click the Upload tab and drag your CSV file in (or click Browse)
5. On the import settings screen, choose Replace spreadsheet, Insert new sheet(s), or Append rows — whichever fits your workflow
6. Set the separator to Comma (it usually auto-detects)
7. Click Import data

Your data appears in Sheets immediately, clean and properly columned.

Sell Custom Apparel — We Handle Printing & Free Shipping

What Happens to Multiple Excel Sheets

A .xlsx file can contain dozens of sheets. CSV can only hold one. This is the key limitation to plan around before you start.

If you need all sheets in Google Sheets, you have two paths:

• Export each sheet separately — use the sheet picker in the converter to download each sheet as its own CSV, then import each one into a separate tab in Google Sheets
• Use "Download All Sheets" — the converter's Download All Sheets button generates a separate CSV file for every sheet in the workbook at once, packaged as individual downloads

If you only need one sheet — which is usually the case when moving data into Google Sheets — just select that sheet from the picker and download one CSV. Keep it simple.

The sheet name does not carry over into the CSV filename by default, so rename your downloaded files before importing to keep track of which is which.

Common Import Issues and How to Fix Them

Dates show as numbers

Excel stores dates as serial numbers internally (January 1, 1900 = 1). If Google Sheets imports a date column as plain numbers, select that column, click Format, select Number, then choose Date. Sheets will convert the serial numbers to readable dates.

Leading zeros disappeared

ZIP codes, employee IDs, and product codes that start with zero often lose that zero during CSV conversion because spreadsheets treat them as numbers. See our guide on preserving leading zeros when converting Excel to CSV — the fix happens before you export.

All data landed in one column

This means Sheets read your CSV as semicolon-delimited instead of comma-delimited. Go to File, Import again, and manually set the separator to Comma on the import screen. If your CSV was actually exported with semicolons (common in European Excel locales), see our guide on fixing the semicolon delimiter issue.

Special characters are garbled

Character encoding mismatch. The CSV converter outputs UTF-8 by default, which Google Sheets expects. If characters look wrong, make sure you are not opening the CSV in Excel and re-saving it before importing to Sheets — Excel can re-encode the file.

When to Skip CSV and Import Excel Directly

CSV is the right choice for data — rows and columns of values. But sometimes you are not moving data; you are moving a workbook. In those cases, direct .xlsx import into Google Sheets is actually correct:

• You need to preserve multiple sheets with their names and structure
• The workbook contains charts that need to stay connected to their data
• You are sharing the file with someone else and they need to edit it in Sheets, not just read the data
• You want to collaborate on the formulas themselves, not just the output values

For those situations, use File, Import, Upload, and choose the .xlsx file directly. Accept that some formatting may shift, and clean it up manually in Sheets once it lands.

For everything else — sending data to a Sheets dashboard, populating a Sheets template, or simply moving a dataset from one tool to another — CSV gives you a cleaner, more reliable result.

Frequently Asked Questions

Does Google Sheets import CSV without a Google account?

No — you need to be signed into a Google account to use Google Sheets, including importing CSV files. However, you can convert your Excel file to CSV using our browser-based converter without any account at all.

Will my Excel formulas work in Google Sheets after CSV import?

No. CSV stores only values, not formulas. The CSV import captures what was visible in your cells — the calculated results — not the formulas behind them. If you need formulas in Sheets, you will need to recreate them using Google Sheets syntax after importing the data.

Can I convert a password-protected Excel file to CSV?

Our converter cannot open password-protected Excel files — you would need to remove the password in Excel first (File, Info, Protect Workbook, Encrypt with Password, delete the password). Once unprotected, drag the file into the converter as normal.

What is the maximum file size the converter handles?

Because conversion happens in your browser using your device's memory, the practical limit depends on your device. Files up to 50MB work reliably on most computers. Very large workbooks with hundreds of thousands of rows may be slow to process on older hardware.