How to use the Excel to CSV Converter
- 1. Choose a workbookPick an .xlsx, .xlsm, .xls or .ods file; its sheets are listed.
- 2. Pick optionsSheet, delimiter, formatted or raw values, and the UTF-8 marker.
- 3. ConvertDownload one CSV, or a ZIP with a CSV for every sheet.
What you get
Each sheet becomes a CSV with the values Excel last calculated (formulas aren't kept, because CSV has no formulas). With values as shown on, dates and numbers come out as they look in Excel; with it off, you get raw values and dates as YYYY-MM-DD. Choose a semicolon for European systems or a tab for database imports. The optional UTF-8 marker makes Excel display Hindi, Tamil and other scripts correctly when the CSV is reopened. Files are read by your browser and never uploaded.
Worked example
A workbook with sheets Dashboard, Data and How to use (like the one from our dashboard template generator) converted with All sheets gives a ZIP of three CSVs named after the workbook and sheet. Choose just the Data sheet and you get a single CSV of its rows, with blank rows at the end left out.
Limits
- Password-protected workbooks can't be read.
- Merged cells keep their value only in the top-left cell.
- Charts, images and formatting don't carry over to CSV.
- Hidden sheets and hidden rows are exported too, because CSV has no way to hide them.
Which delimiter should I pick?
Comma is the default for most tools and databases. Pick semicolon if the file will be opened by Excel set to a European language, where commas are decimal points. Tab is safest when your data itself contains many commas, such as addresses, and pipe suits some banking and government upload formats.
Frequently asked questions
Why are some numbers rounded?
With 'values as shown' on you get Excel's displayed format. Turn it off for the full stored value.
Can I convert Google Sheets?
Download it as .xlsx from Google Sheets (File → Download) and convert that.
Is the Excel to CSV converter free?
Yes. You can open the Excel to CSV converter, load files and set every option without signing up. When you convert a file for the first time, we ask once for your name and WhatsApp number; after that it, and every other Uncodemy tool, opens straight away.