Updated
To convert CSV to Excel, drop the .csv or .tsv file, keep or change two options, and download an .xlsx workbook. Unlike the raw CSV, that workbook looks the same on every computer, whatever its regional settings.
Why opening the CSV directly goes wrong
When Excel opens a CSV, it guesses the layout from the regional settings of the machine. A computer configured for Germany or the Netherlands expects semicolons, so a comma file collapses into one column there. Text saved as UTF-8 without a byte order mark gets decoded wrongly, and a name like Jürgen comes out garbled. ZIP codes such as 02134 drop their first zero. A workbook leaves nothing to guess, because every cell is already defined.
How we read the CSV
We look at the first part of the file to find the separator. Commas, semicolons, tabs and pipes are recognized, and .tsv files are fine. We decode the text as UTF-8, byte order mark or not. Every line of the file becomes one row, and the sheet is named after the file. Row 1 comes out bold, which makes the header easy to spot; turn that off if the file has no header row.
Numbers, leading zeros and formulas
The setting "store numbers as numbers" is on by default. It turns plain values such as 18, -3 or 99.95 into real numbers, ready for sums and sorting. Everything that is not a plain number keeps its original text. So 0042 stays 0042, ZIP codes and phone numbers keep their zeros, and long account numbers are not rounded off, which is what Excel would do if it treated them as numbers.
Values written with a decimal comma or with thousands separators, such as 2.499,00, are kept as text as well. If they need to be calculated, change them inside Excel. With the setting off, every single cell is text.
Cells that start with = arrive as plain text. A CSV therefore cannot slip a working formula into your workbook.
Many exports at once
Drop several CSV files, or a folder of them, and every file gets a workbook of its own. Without an account a batch takes up to 5 files of up to 50 MB each, within 20 server jobs a day. A free account allows 10 files per batch and 50 jobs a day, and Pro allows 500 files of up to 500 MB with no daily allowance. Download the workbooks one by one or as one ZIP. One ceiling comes from Excel itself: a sheet holds at most 1,048,576 rows, so an extremely long CSV will not fit.
The conversion runs on our servers in Germany, not in your browser. Files travel over an encrypted connection, and we delete the CSV and the workbook automatically within two hours.
How to turn CSV files into workbooks
- Drop your .csv or .tsv files onto the page.
- Leave the number setting and the bold header on, or switch either one off.
- Click Convert.
- Download the workbooks one at a time or together as a ZIP.
FAQ
My CSV comes from a German system. Will it split correctly?
Yes. Semicolons are detected automatically, like commas, tabs and pipes.
Can several CSV files become tabs in one workbook?
No, not in a single run. Every CSV gets a workbook of its own.
Are column widths adjusted to the content?
No. In Excel, double-click a column border to fit it to its contents.
Can other spreadsheet programs open the result?
Yes. Other common spreadsheet programs, including free and online ones, open .xlsx files too.