An Excel workbook (.xlsx or .xls) is a rich container: multiple sheets, formulas, colors, column widths, charts. A CSV file is just plain text — one row per line, values separated by commas. That simplicity is exactly why people convert: databases, import wizards, scripts and Google Sheets all read CSV without fuss.
The conversion itself is quick. The trouble is that CSV can't hold most of what a workbook holds, so something always gets dropped. Knowing what gets dropped is the difference between a clean file and a silent data problem you find three weeks later.
What Actually Happens When You Convert Excel to CSV
Before picking a method, know what you're signing up for:
- Only one sheet is exported. A CSV file has no concept of tabs. You get the sheet that's active (or the first one, depending on the method).
- Formulas become their current values.
=SUM(B2:B9)turns into the number it displayed. - Formatting disappears. Colors, bold, borders, merged cells, column widths and charts are all gone.
- Values are saved as displayed. A date shown as
03/04/2026is saved as exactly that text, not as a date serial number.
If any of those is a deal-breaker, CSV isn't the right target format — see CSV vs Excel: Which Format to Use for when to keep the workbook.
Method 1: Save As CSV in Excel
If you have Excel installed, this is the built-in route.
- Open the workbook and click the sheet you want to export.
- Go to File → Save As (or Save a Copy) and choose a location.
- In the file type dropdown, pick CSV UTF-8 (Comma delimited) (*.csv).
- Click Save. Excel warns that only the active sheet will be saved and that some features may be lost — confirm with OK / Yes.
The file type matters more than it looks. Excel offers several CSV variants, and the plain CSV (Comma delimited) option writes the file in your system's legacy code page rather than UTF-8. That's the root cause of most "my accents turned into garbage" complaints (more on that below).
Best for: a single sheet, when Excel is already open. Limitations: one sheet per save, so a 10-tab workbook means ten Save As rounds; and the output depends on your computer's regional settings.
Method 2: A Free Browser-Based Converter
If you don't have Excel handy, or you just want a clean result without thinking about file-type menus, upload the workbook to a converter. Our Excel to CSV converter runs entirely in your browser — the file is never uploaded to a server — and writes UTF-8 CSV by default. It reads the first worksheet of an .xlsx or .xls file.
Because it exports the first worksheet, put the sheet you need first (drag its tab to the far left) before converting a multi-sheet workbook. For sensitive files, local processing means nothing leaves your machine, which is a real advantage over upload-based online converters.
Best for: quick one-off conversions, machines without Excel, anything confidential. Limitations: first worksheet only; for several sheets, convert them one at a time.
Method 3: Use Google Sheets as the Converter
Google Sheets reads Excel files natively, so it can do the job for free:
- In Google Sheets, choose File → Import → Upload and drop in the
.xlsxfile (or upload it to Drive and open it with Sheets). - Pick Replace spreadsheet or Insert new sheet(s).
- Open the tab you want, then choose File → Download → Comma-separated values (.csv).
Sheets exports the current tab as UTF-8 CSV, so you get correct encoding without any menu hunting. It's also the natural path if the data is headed for Sheets anyway — though if so, you can skip CSV entirely; see How to Convert Excel to Google Sheets.
Best for: people who live in Google Workspace, and for cleaning up encoding on a file that came out garbled. Limitations: a few extra clicks per sheet; very large workbooks can be slow to import.
The Five Gotchas (and How to Dodge Them)
1. Garbled characters (é becomes é)
This is an encoding mismatch. The legacy CSV (Comma delimited) type saves in your system code page, but whatever opens the file next often assumes UTF-8. Always choose CSV UTF-8 when saving from Excel. If you already have a garbled file, see How to Fix CSV Encoding Errors.
2. Semicolons instead of commas
In regions where the decimal separator is a comma (much of Europe, Latin America and elsewhere), Excel uses a semicolon as the list separator, and that's what ends up in the "comma delimited" file. Everything lands in a single column when you open it elsewhere. Either change the separator in your operating system's regional settings before saving, or fix the delimiter afterwards — our guide to CSV delimiter problems walks through it.
3. Leading zeros that vanished
If a ZIP code like 02134 or an ID like 00417 was stored in Excel as a number, the zero is already gone before you save. Format those columns as Text before typing or pasting the values. Details in How to Preserve Leading Zeros in CSV Files.
4. Dates in the wrong format
CSV stores the text exactly as Excel displays it. A cell showing 4/3/26 is saved as 4/3/26, and whether that means April 3 or March 4 depends on whoever reads it next. For anything machine-bound, set the date column to an unambiguous format such as yyyy-mm-dd before exporting.
5. Commas, quotes and line breaks inside cells
A cell containing a comma — say Smith, John — has to be wrapped in quotes in the CSV or it splits into two columns. Excel and any decent converter handle this automatically; trouble only appears with hand-built files or scripts that don't quote properly. See 10 Common CSV Import Errors and Fixes if an import fails after conversion.
Quick Comparison
Pros:
- ✅Excel Save As: built in, no extra tools, full control over file type
- ✅Browser converter: no Excel needed, UTF-8 by default, file stays on your device
- ✅Google Sheets: free, correct UTF-8 export, ideal if the data is going to Sheets anyway
Cons:
- ❌Excel Save As: easy to pick the wrong CSV variant, one sheet at a time
- ❌Browser converter: first worksheet only
- ❌Google Sheets: extra import step, slower on very large files
Open the Result Without Re-Importing
Once you have the CSV, you often want to look at it or send it to Sheets. On a Mac, CSVtoSheets opens a CSV straight into Google Sheets with a double-click, with no upload dialog and no re-importing. To just inspect a file first, the free CSV viewer opens it in your browser.
Frequently Asked Questions
Q: How do I convert an Excel file with multiple sheets to CSV? A: CSV holds one table per file, so export each sheet separately. In Excel, select a sheet and Save As CSV UTF-8, repeat per sheet. With the browser converter, move the sheet you need to the first position before converting.
Q: Will formulas survive the conversion?
A: No. The CSV contains the calculated values, not the formulas. Keep your original .xlsx as the source of truth.
Q: Which CSV option should I choose in Excel? A: CSV UTF-8 (Comma delimited) in almost every case. The other variants (plain CSV, CSV Macintosh, CSV MS-DOS) use legacy encodings and are only needed for old software that requires them.
Q: Is there a row limit? A: Excel worksheets max out at 1,048,576 rows, and CSV itself has no limit, so a worksheet always fits. Opening a very large CSV back in Excel is subject to the same cap; see How to Handle Large CSV Files in Google Sheets for the Sheets-side limits.
Q: Can I convert CSV back to Excel? A: Yes — use the CSV to Excel converter. Note that the formatting and formulas lost on the way out won't come back.