CSV to Excel Converter

About CSV to Excel

CSV to Excel fixes the two things that go wrong when you double-click a CSV: everything lands in column A, or the text turns into strange symbols. The separator (comma, semicolon, tab or pipe) is read from the data, and so is the encoding, so UTF-8 files with or without a BOM, Chinese GBK exports, Traditional Chinese Big5, Japanese Shift-JIS and Windows-1252 files with the accented letters of an older European PC all come out readable. If the export comes as JSON instead, JSON to Excel flattens it into a spreadsheet.

Add several CSV or TSV files and, with Several CSVs as the sheets of one workbook on, they arrive as one .xlsx with a sheet per file, each named after its file; switch it off for one workbook per CSV, all of them also in one ZIP. Numbers become real numbers that keep their look: 412.50 keeps its two decimals and 18.6% stays a percentage. Phone numbers, ID numbers and codes with leading zeros stay text, so 007 doesn't turn into 7 and a long ID doesn't become 1.38E+10, and dates are kept exactly as written. With First row is the header on, the top row is bold and frozen, with filter buttons on every column.

How to use CSV to Excel

1. 1
   Add the CSV files

   Choose or drop one or more .csv, .tsv or .txt files, such as exports from online banking, a shop back end or a survey tool. Up to 20 files go in one task, or 50 with VIP.

2. 2
   Check the options

   First row is the header and Several CSVs as the sheets of one workbook are on by default. Turn off the first if your files start straight away with data, and the second for a separate workbook per file.

3. 3
   Click CSV to Excel

   We detect the separator and encoding of each file, then build the workbook on our server.

4. 4
   Open it in Excel

   Download the .xlsx, or the ZIP of workbooks. Sheets are named after your files and the columns are already sized to fit.

Why use Cubfile for this

• Right columns, right characters

  The separator is read from the data, and UTF-8, GBK, Big5, Shift-JIS and Windows-1252 files are decoded correctly.

• Many CSVs, one workbook

  A month of daily exports becomes one .xlsx with a sheet per file, named after it, or one workbook each if you prefer.

• Numbers that add up, IDs intact

  Amounts and percentages become numbers in their own format, while leading zeros and long phone or ID numbers stay text.

• A header ready to filter

  The first row is bold and frozen, with filter buttons on every column, so you can sort and filter straight away.