Excel to CSV
DataConvert Excel files to CSV with custom delimiter options and batch sheet conversion. Export data for databases or scripts via SheetJS, in the browser.
Related Tools
About Excel to CSV
This Excel to CSV converter uses SheetJS to transform xlsx and xls files into CSV text locally in your browser. The conversion follows RFC 4180, correctly handling fields with commas, quotes, and newlines via double-quote wrapping and escaping. It supports custom delimiters (comma, tab, semicolon, pipe) and batch export of multiple worksheets. CSV is the most universal spreadsheet exchange format, readable by Excel, Google Sheets, database import tools, and analytics platforms, and because everything runs locally it is discarded as soon as you finish. Two pitfalls show up often in practice. First, match the delimiter to the target system — regions like Germany and France default to semicolons, and a mismatch crams every column into one cell or shifts everything sideways. Second, watch the encoding: older Excel opens CSV in ANSI by default, so UTF-8 content with Chinese characters can read as mojibake; use a BOM-prefixed encoding when needed. Fields containing commas or newlines are automatically quoted, so validate a small sample before batch-loading into a database or analytics pipeline.
How to Use
- Open the Excel to CSV tool
- Import or paste the data to process
- Adjust the output options as needed
- Click the Process button; results appear in real time
- Copy or export the result
Use Cases
- Database import — Convert Excel data to CSV for MySQL or PostgreSQL LOAD DATA bulk import commands.
- Data analysis import — Transform Excel data to CSV for direct loading by Python pandas read_csv or R language.
- Cross-system data exchange — Convert Excel reports to CSV as a universal data exchange intermediate format between systems.
- Batch multi-sheet export — Export multi-worksheet Excel files as independent CSV files, one per sheet.
- Version-control friendly — Convert Excel config data to CSV text format for easy Git diff tracking of data changes.
- Long-term archival — Export Excel data to CSV as a stable archive so data remains readable even as file formats evolve.
FAQ
How are special characters in CSV handled?
Following RFC 4180, field values containing commas, quotes, or newlines are wrapped in double quotes; quotes within fields are escaped as two consecutive double quotes.
Can I customize the delimiter?
Yes. Besides the default comma, tab (TSV), semicolon, and pipe are supported, adapting to different regional and system CSV conventions.
What happens if I pick the wrong delimiter?
The delimiter must match the target system, since regions like Germany and France default to semicolons; a mismatch crams everything into one cell or misaligns columns.
Why is my exported text showing garbled Chinese?
Older Excel opens CSV in ANSI by default, so UTF-8 content can look garbled; switch to a BOM-prefixed encoding or specify UTF-8 when importing.
How are multiple worksheets exported?
The tool lists all worksheets; you can select a specific sheet or export all sheets one by one as independent CSV files.
What is the difference between CSV and Excel?
CSV is plain text preserving only data values without formatting, formulas, or charts; Excel is binary preserving full formatting. CSV is lighter and more universal.
Are the files uploaded?
No. All parsing and conversion run locally via SheetJS; your file never leaves the device, safe for sensitive reports.