How to Convert Excel to CSV — 4 Methods Compared

Why Convert Excel to CSV?

Excel's .xlsx format is powerful for calculations and formatting, but it creates problems when you need to share data with other systems. CSV strips everything down to plain values — no formulas, no formatting, no macros — which makes it universally readable. Common reasons to convert:

Database imports — MySQL, PostgreSQL, SQLite, and most databases accept CSV directly
CRM and marketing tools — Mailchimp, HubSpot, Salesforce all import CSV for bulk contact uploads
API uploads — many APIs accept CSV for batch data ingestion
File size — CSV removes formatting and formulas, often reducing file size by 70–90%
Compatibility — any programming language reads CSV without a special library

Method 1: Excel's Built-In Save As (Fastest for One Sheet)

For a single sheet, Excel can export to CSV directly:

Open your .xlsx file in Excel
Go to File → Save As (or press F12)
In the "Save as type" dropdown, select CSV (Comma delimited) (*.csv)
Click Save. Excel will warn you that the CSV format does not support multiple sheets or formatting — click Keep Current Format

Limitation: This only saves the currently active sheet. If your workbook has multiple sheets, you must repeat this for each one. It also uses your system locale's list separator (semicolon in many European locales), which can cause issues when the file is opened on a different system.

Method 2: Power Query (Best for Recurring Conversions)

If you regularly need to convert Excel files to CSV as part of a workflow, Power Query can automate it:

Open a blank Excel workbook
Go to Data → Get Data → From File → From Workbook
Select your source .xlsx file and choose the sheet to import
Click Load to bring the data into Excel
Now use File → Save As → CSV to export the result

Power Query's real power is in transforming data before export — removing columns, filtering rows, changing data types. If your conversion workflow involves any data reshaping, this is the right tool.

Method 3: Python (Best for Bulk or Automated Conversions)

For converting many files at once, or as part of a data pipeline, Python with pandas handles it in a few lines:

import pandas as pd

# Convert a single sheet
df = pd.read_excel('data.xlsx', sheet_name='Sheet1')
df.to_csv('output.csv', index=False, encoding='utf-8-sig')

# Convert all sheets in a workbook
xl = pd.ExcelFile('data.xlsx')
for sheet in xl.sheet_names:
    df = xl.parse(sheet)
    df.to_csv(f'{sheet}.csv', index=False, encoding='utf-8-sig')

The encoding='utf-8-sig' adds a UTF-8 BOM (Byte Order Mark) so Excel opens the CSV without encoding issues.

Method 4: Free Excel to CSV Converter (No Software Needed)

If you don't have Excel installed, need to convert on a shared computer, or want to avoid installing Python, the ExcelErrorFinder Excel to CSV Converter runs entirely in your browser:

Open the free converter — no signup or account needed
Drag and drop your .xlsx or .xls file
Choose your delimiter (comma, semicolon, tab, or pipe)
Select which sheet to convert
Preview the first rows to check the output
Click Download CSV

Your file is processed entirely within your browser using JavaScript — it never leaves your device. This makes it safe for confidential spreadsheets.

Which Delimiter Should You Use?

The default comma works for most situations, but there are cases where another delimiter is better:

Comma (,) — standard; use unless your data contains commas in cell values (like addresses or descriptions)
Semicolon (;) — standard in European locales; use when the destination system expects semicolons, or when your data has commas
Tab (\t) — best when your data contains both commas and semicolons; tab characters rarely appear in data values
Pipe (|) — common for database exports and EDI formats; useful when importing into systems with strict format requirements

Common Issues When Converting Excel to CSV

Dates Appear as Serial Numbers

Excel stores dates as integers (e.g., 45000 for a date in 2023). When exported to CSV without proper handling, these appear as numbers. Fix: ensure date columns are formatted as "Date" (not "Number") in Excel before exporting, or use the date_format parameter in pandas.

Garbled Characters (Encoding Issues)

Characters like é, ñ, or Chinese/Japanese text can appear as â€ or similar when the CSV encoding doesn't match what the recipient expects. Use UTF-8 with BOM (utf-8-sig) for maximum compatibility with Windows Excel.

Numbers Lose Leading Zeros

ZIP codes, phone numbers, and product codes stored as text with leading zeros (e.g., 01234) will lose those zeros when converted to CSV if the column is treated as numeric. Ensure these columns are formatted as Text in Excel before converting.