CSV to Excel Converter

Several CSVs, one workbook

This is the part other converters do not do. Exports usually arrive split: twelve monthly sales files, one CSV per region, a separate download for each report. Converting them one at a time gives you twelve separate workbooks that you then have to combine by hand, copying and pasting between windows.

Select them all at once here instead and they become a single .xlsx with a tab for each. Sheet names come from the filenames, so january.csv becomes a sheet called january — and Excel caps sheet names at 31 characters, so very long filenames are shortened to fit. Once it is one workbook you can write formulas across the sheets, which is usually the reason you wanted it in Excel rather than CSV in the first place.

Delimiters are detected for you

CSV is a looser standard than the name suggests. Files exported by European software typically separate fields with semicolons rather than commas, and some systems use tabs or pipes. Getting this wrong is what produces a spreadsheet with everything crammed into column A.

The delimiter setting defaults to Auto-detect, which samples the file and picks the character that behaves like a separator. That handles almost everything. If a file is unusual enough to confuse it — free-text fields full of semicolons, for instance — set the delimiter explicitly. You can also tell it whether the first row is a header, which decides whether that row becomes your column titles or an ordinary row of data.

One thing to watch: leading zeros

Excel treats anything that looks like a number as a number, and this conversion follows the same rule. A ZIP code stored as 01234 arrives as 1234, and a long product ID may be displayed in scientific notation. That is standard spreadsheet behaviour rather than something unique to this tool, but it is worth knowing before you convert a file full of postcodes, phone numbers or account references.

If a column must keep its exact original text, format it as Text in Excel after opening, or keep the CSV as the authoritative copy and use the workbook for analysis only.

Related tools

Excel to CSV Converter converts in the other direction, with delimiter and encoding options for whatever system is receiving the file. JSON to CSV Converter flattens JSON into the same tabular shape when your data comes from an API.