How to Convert Excel to CSV (and When to Do It)

CSV (Comma-Separated Values) is the lingua franca of data. Every database, CRM, analytics tool and programming language can read it. Excel XLSX is great for working with data — but when you need to hand data off to another system, CSV is almost always the right format. Here is when and how to convert.

When to convert Excel to CSV

  • Database imports. MySQL, PostgreSQL, SQLite — all have native CSV import support. Importing a raw XLSX is rarely an option.
  • API and data pipelines. Pandas, Python scripts, R, and most ETL tools read CSV natively.
  • CRM and e-commerce platforms. Shopify, Salesforce, Mailchimp — their bulk-import tools expect CSV, not XLSX.
  • Sharing with non-Excel users. Google Sheets, LibreOffice Calc and Apple Numbers all open CSV perfectly.

What gets lost when converting to CSV

CSV stores only the raw values in the active sheet — nothing else survives:

  • Formulas become their computed values
  • Formatting — fonts, colors, borders — is stripped
  • Multiple sheets — only the active sheet is exported
  • Charts, images, pivot tables — all dropped

If you need to preserve any of these, keep the XLSX and export to CSV only as a copy.

How to convert Excel to CSV online

  1. Open the Excel to CSV converter.
  2. Upload your .xlsx or .xls file.
  3. Click "Convert" — the active sheet is exported as a UTF-8 CSV.
  4. Download the file. No registration required.
Ad slot — enable ads in public/ads.js · article-mid

Watch out: text encoding

The most common CSV problem is encoding. UTF-8 is the correct choice for any modern system — it handles all languages, special characters and symbols. If you open the CSV in older versions of Excel on Windows, it may misread accented characters unless you tell Excel the encoding (File → Import → Delimited → UTF-8). The CSV from Converters.live uses UTF-8 without BOM, which is the safest choice for most tools.

Need to go back to Excel?

Use the CSV to Excel converter to turn a CSV back into a spreadsheet with proper columns. It auto-detects delimiters (comma, semicolon, tab) and encoding.

Comma vs semicolon: a regional gotcha

In locales where the decimal separator is a comma (much of continental Europe), Excel uses a semicolon as the field separator in CSV instead of a comma, to avoid ambiguity with decimal numbers. A CSV exported on a US or UK system and opened on a system set to a European locale can appear as one giant unsplit column, or vice versa — the fix is telling the receiving tool which delimiter the file actually uses rather than assuming.

Row and column limits

CSV itself has no built-in row limit — it's just text, so it can hold millions of rows if the receiving tool can handle the file size. Excel, however, caps a single worksheet at 1,048,576 rows; a CSV larger than that will get truncated silently if reopened in Excel, so very large exports are better handled by database tools or scripts that read CSV directly rather than round-tripping through a spreadsheet.