← Blog 5 min read

How to Convert Excel to CSV

You have data in an Excel spreadsheet and you need it in CSV format. Maybe you are importing contacts into a CRM, uploading product data to an e-commerce platform, feeding data into a database, or sharing information with someone who does not have Excel. CSV is the universal language of structured data.

What is CSV and why does it matter?

CSV stands for Comma-Separated Values. It is the simplest possible format for tabular data: each row is a line of text, and columns are separated by commas. No formatting, no formulas, no macros - just raw data.

This simplicity is its strength. Every programming language can read CSV. Every database can import it. Every spreadsheet application supports it. When you need to move data between systems, CSV is almost always the safest choice.

The problem with Excel's built-in CSV export

Excel can save as CSV natively (File > Save As > CSV). But there are several gotchas that trip people up:

  • Only the active sheet is exported. If your workbook has multiple sheets, you need to save each one separately.
  • Formatting is lost. Dates, currency formats, and number formats may change. A date formatted as "May 12, 2026" might become "46148" (Excel's internal date number).
  • Encoding issues. Excel's default CSV export often uses a locale-specific encoding, which can break special characters like accents, umlauts, or non-Latin scripts.
  • You need Excel installed. If you are on a phone, a Chromebook, or a computer without Microsoft Office, you cannot use this method.

Convert Excel to CSV online

PrivConvert's Excel to CSV converter handles all of these issues. Drop your .xlsx or .xls file, and you get a properly formatted CSV with correct encoding and preserved data types.

The conversion handles multi-sheet workbooks by letting you select which sheet to export. Dates and numbers are converted to their displayed values, not Excel's internal representations. And the output uses UTF-8 encoding, which supports every character set.

As with all PrivConvert tools, the conversion happens in your browser. Your spreadsheet data stays on your device.

Common pitfalls when converting

Even with a good converter, there are things to watch out for:

  • Leading zeros get stripped. If your spreadsheet has ZIP codes like "01234" or product codes like "007", CSV treats these as numbers and drops the leading zeros. The fix: wrap these columns in quotes or prefix with an apostrophe in the source.
  • Commas in data cause problems. If a cell contains "New York, NY", a naive CSV export breaks the column structure. Proper converters handle this by quoting fields that contain commas.
  • Formulas export as values. CSV stores only values, not formulas. Make sure your formulas have calculated correctly before converting.
  • Merged cells cause blank rows. Unmerge cells in your spreadsheet before converting for cleanest results.

What to do with your CSV

Once you have your CSV, the possibilities open up. You can:

Going the other direction

Need to go from CSV back to Excel? That is equally common - you exported data from a system as CSV and now need to work with it in a spreadsheet. PrivConvert's CSV to Excel converter creates a properly formatted .xlsx file from your CSV data, complete with auto-detected column types.

Convert Excel to CSV now