Excel to CSV Converter

About Excel to CSV Converter

Excel to CSV converts the sheets of an .xlsx workbook into CSV files that other programs can import: CRMs, email marketing services, online shops, accounting software, databases and data tools. Excel can save as CSV itself, but only one sheet at a time, often in an old encoding that turns ć, ü or Cyrillic text into question marks, and with dates and numbers written the way they are displayed on your computer, such as 15.3.2024 or 1.234,50, which another system may read differently or not at all. This tool reads the workbook directly and lists every sheet with its row count, so you can choose which ones to export; hidden and empty sheets are unticked by default. Each selected sheet becomes its own CSV file, and several sheets or several workbooks are downloaded together as a ZIP. Dates and times are written in the international format 2024-03-15 and 14:30:00, which every database and import tool understands, and numbers are written as stored, without currency signs or thousand separators. Text is saved as UTF-8 with a signature so Excel and other programs show accented letters correctly, and you can switch the signature off for strict tools. The separator can be comma, semicolon for European Excel versions, or tab. Empty rows inside the data are kept so row positions match the original, and cells with commas, quotes or line breaks are quoted correctly. Everything happens in your browser, so financial and personal data never leaves your computer. For the opposite direction use CSV to Excel Converter, and to stack the resulting CSV files into one table use Merge CSV Files.

Most systems that import data ask for CSV, not Excel, because CSV is plain text that any program can read without a licence. The catch is that a CSV has to be written in a form the receiving program expects, and Excel's own Save As often gets that wrong for anyone outside the United States. Three settings matter. The encoding should be UTF-8, the only encoding that covers every language; older options store text in a regional code page, which is why names arrive in the CRM with question marks. The separator should match the importer, which is a comma in almost every web service and database. The date format should be unambiguous, because 03/04/2024 means 4 March in the US and 3 April in Europe; ISO dates like 2024-04-03 remove the doubt. This converter uses those defaults. It also leaves the values themselves alone: a formula is exported as its last calculated result, a number formatted as currency is exported as the plain amount, and a percentage is exported as its stored fraction, so 25% becomes 0.25. If you need a value exactly as displayed, format that column as text in Excel before converting. When a workbook has several sheets with the same columns, for example one per month, convert them all and then combine the CSV files into one table with Merge CSV Files. If the sheet is a contact list, CSV to vCard Converter can turn it into a .vcf for phones without going through CSV at all.

How to use Excel to CSV Converter

  1. Drop one or more .xlsx workbooks
  2. Tick the sheets to convert and choose the separator
  3. Download the CSV, or a ZIP when you convert several sheets

Frequently Asked Questions

How do I convert an Excel file to CSV?
Drop the .xlsx file onto the tool. All sheets are listed with their row counts and a preview. Tick the sheets you need, choose the separator and click Download CSV. One sheet downloads as a .csv file, several sheets as a ZIP with one CSV each.
How do I convert all sheets of a workbook to CSV at once?
Load the workbook and leave all sheets ticked. Each sheet becomes a separate CSV named after the workbook and the sheet, for example Sales - January.csv, and they are downloaded together in a ZIP. Excel itself only saves the active sheet when you choose CSV.
Why do my accented letters turn into question marks?
Excel's plain CSV option saves in an old Windows encoding that cannot hold every character. This converter always writes UTF-8, which supports every language, and adds a small signature at the start so Excel recognises it when opening the file again.
How are dates written?
As 2024-03-15 for dates, 14:30:00 for times and 2024-03-15 14:30:00 for both. This ISO format is read correctly by databases, Google Sheets, CRMs and import tools regardless of the country settings of the computer. Excel shows them as dates again when you open the CSV.
Should I use a comma or a semicolon?
Use a comma for databases, Google Sheets, CRMs and most web services. Use a semicolon only if the CSV will be opened by Excel set to a European language such as German, French or Serbian, which uses the comma as a decimal mark. Tab is a safe choice when cells contain many commas.
Does it work with .xls files?
Only the modern .xlsx format is supported. Open an old .xls file in Excel, LibreOffice or Google Sheets and save it as .xlsx first, then convert it here.
Is the workbook uploaded?
No. The file is unpacked and converted inside your browser, and the CSV is created on your device. Nothing is sent to ToolBox.

Related Tools