Export Excel to CSV: No-Data-Loss Guide

The dashboard presentation was in two hours. I opened the file my colleague had exported overnight, ran the date filter, and nothing matched. Every date in the Order Date column had come through as a text string — 2024-09-14 sitting there, inert, completely invisible to the filter. That's not an Excel bug. That's what happens when someone clicks Save As without understanding what CSV actually does to your data. If you're here because you need to export Excel to CSV and you want the file to actually work on the other end, you're in the right place.

A CSV (comma-separated values) is plain text. No formatting, no formulas, no colors, no multiple sheets. Just raw values separated by delimiters, usually commas. That simplicity is the point: every system can read it. But that simplicity is also where things go quietly wrong, and most tutorials skip that part entirely.

Before you touch anything: make sure the correct sheet is active. CSV exports one sheet only — whichever one is visible when you save. If your workbook has your sales data on Sheet 2 and a summary on Sheet 1, and Sheet 1 is active, that's what you're exporting. Check first.

---

Why CSV Strips Your Formatting (and Why That's Usually Fine)

Here's the thing: CSV doesn't save what you see — it saves the raw underlying values. A cell displaying $1,250.00 exports as 1250. A percentage showing 84% may export as 0.84. Formulas become their last calculated result, then freeze there permanently. For most data transfer purposes — feeding a database, importing into another tool, sharing with a developer — this is exactly what you want. The problem is when the raw value isn't what you assumed it was, which is what Step 2 covers.

If you're new to how Excel handles different file types, the guide to Excel file formats (XLSX, XLS, CSV) breaks down when to use each one. And if you're still getting comfortable with Excel broadly, the Excel for Beginners starter guide is worth a read before going further with file exports.

---

Step 1: Save Your Excel File as CSV Using File > Save As

Once you've confirmed the right sheet is active, the actual export is a few clicks — but the confirmation dialogs matter, and most people dismiss them without reading.

On Windows

1. Go to File → Save As. If you're using a recent version of Microsoft Office, you may see a simplified pane rather than a full dialog. Click More options... to get the full Save As window.
2. In the Save as type dropdown, select CSV (Comma delimited) (*.csv). You'll also see "CSV UTF-8 (Comma delimited)" — more on why that one matters in Step 2.
3. Name your file, choose your save location, and click Save.
4. Excel will warn you that the selected file format doesn't support workbooks with multiple sheets. This is expected. Click Keep Current Sheet. It's not deleting your other sheets — your original .xlsx is untouched as long as you didn't overwrite it.
5. A second prompt may ask whether you want to keep the format. Click Yes.

On Mac

1. Go to File → Save As.
2. In the File Format dropdown, select CSV UTF-8 (Comma-delimited). On Mac, this is available directly and is the better default: it handles special characters cleanly.
3. Name the file and click Save.
4. The same prompt about multiple sheets will appear. Keep the current sheet and don't panic — your original workbook is fine.

One mistake I see constantly: people save as CSV, close the file, and realize Excel is now working in the CSV — and they've lost access to the .xlsx. After you export, go back to File → Open and reopen the original. Better yet, save the CSV to a separate folder before you start. The Excel file management guide has a solid system for keeping exports organized.

---

Step 2: Fix the Three Things That Quietly Break Your CSV Export

Getting the file saved is the easy part. What trips people up is opening that CSV somewhere else and finding the data looks nothing like what they exported. These three issues cause the vast majority of those surprises.

Leading Zeros Disappearing

If your Region Code column contains values like 00742 or 01189, those leading zeros are gone the moment the file is saved. CSV has no concept of text-formatted numbers — it sees a number, drops the zeros, and moves on. The fix isn't in the export step itself. Format those cells as text in Excel before you save. If you're the one consuming the CSV, re-import with the column explicitly typed as text rather than letting Excel autodetect it.

Semicolons Instead of Commas

This one came up constantly after a data conference I attended. Colleagues from Germany and France were getting CSVs that opened as single-column disasters. The problem: Excel uses your system's list separator setting as the CSV delimiter. In most European locales, that separator is a semicolon, not a comma. A file exported on a US machine and opened on a European machine can parse completely wrong, and neither party did anything incorrect.

The fix on Windows is to change the list separator in Region Settings → Additional Settings, or use a macro that forces comma output regardless of locale. If you regularly share files internationally, this is worth solving at the system level rather than fixing case by case.

Special Characters Coming Out Garbled

If your data includes accented characters (café, naïve, São Paulo), Cyrillic, or any non-Latin script, encoding matters. The plain CSV (Comma delimited) format on Windows defaults to your system's local encoding — often Windows-1252 — which breaks when the file is opened on a system expecting UTF-8. The fix: explicitly choose CSV UTF-8 (Comma delimited) in the file format dropdown. It's been available in Excel since 2016 and should be your default for anything going outside your own machine. Unicode's UTF-8 FAQ explains why the encoding difference matters at the byte level, if you want the full picture.

---

Common Mistakes When You Export Excel to CSV

Even with the right steps, a few things still catch people out regularly. The wrong sheet getting exported is the most common — and the most avoidable. Click on the correct sheet tab before you open the Save As dialog. It sounds obvious. I've gotten it wrong twice under deadline pressure, and I build data pipelines for a living.

Bulk exporting is the other gap most tutorials don't address. Since CSV is one sheet per file, exporting an entire workbook means saving each sheet individually — or using a VBA macro to loop through sheets and save each one. There's no native "export all sheets to CSV" button in Excel as of 2026. If you need to do this regularly, a macro is worth the investment. Doing it manually for a ten-sheet workbook is exactly the kind of repeated manual work that introduces errors.

Excel for the Web can export a CSV from the browser, but it currently only supports ASCII encoding. Any data containing accented characters, special symbols, or non-Latin scripts may be corrupted silently. For anything with international character sets, use the desktop app and select CSV UTF-8 explicitly.

The error is rarely where you think it is. A CSV that breaks downstream isn't a problem with the receiving system — it's a problem with decisions made at export. Getting those decisions right the first time means nobody has to clean up the file on the other end.

---