On-device AI — professional-grade, fully private.

Documents

How to Convert CSV to Excel (XLSX) Online, With Zeros, Dates and Accents Intact

Convert CSV to Excel online free: a real XLSX with the right delimiter and encoding, leading zeros and long IDs kept as text, and dates typed as dates.

Updated November 8, 20269 min read

To convert CSV to Excel online for free, add the file to a CSV to XLSX converter, check that the preview shows proper columns, and download the workbook. The part that matters is what happens in between: the converter has to pick the right delimiter and text encoding, decide which values are numbers or dates, and leave codes such as zip codes, phone numbers and 18-digit order IDs exactly as written. This guide walks through the conversion with the CSV to Excel converter, explains each setting in plain terms, and lists the cases where a file still comes out wrong and what to change.

CSV to Excel: what a real XLSX gives you

A CSV is plain text: rows on lines, values separated by a character, and nothing else. It has no column types, no frozen header, no filters and no column widths. When Excel opens one directly, it guesses all of that on the spot, which is why the same file can look fine on one computer and broken on another. An XLSX stores the decisions instead. A date is saved as a date with a date format, a number as a number, and a code as text, so the workbook opens the same way for everyone who receives it. Converting once, carefully, is how you stop every colleague from re-importing the file by hand.

If you only need to read the file, the CSV Viewer shows it as a table without making anything. If your question is why Excel mangles a CSV when you double-click it, the companion guide on opening a CSV in Excel correctly explains each failure. This page is about producing a clean workbook.

Converting a CSV to XLSX, step by step

1

Add the file

Open the CSV to XLSX converter and drop in a .csv, .tsv or .txt file, or press Choose file. The delimiter, quote character and encoding are detected as soon as the file is read.

2

Read the preview

The Preview grid shows the first rows exactly as the spreadsheet will hold them, with each cell marked as text, number, date, percent, currency or true/false. If everything sits in one column, or accented letters look like random symbols, fix that before anything else.

3

Correct what looks wrong

Change Delimiter, Encoding or Number format, set Skip leading rows if a report title sits above the real header, and use the type control in any column's header to force it to Text, Number or Date.

4

Set up the sheet

Leave First row is header, Freeze the header row, Add filter buttons and Fit column widths to content on unless you have a reason not to. Type a Sheet name if the default is not useful.

5

Convert and download

Press Convert to XLSX, then Download XLSX. It all runs on your device, not our servers, so a customer list or payroll export is never uploaded to be converted.

Free: one CSV, TSV or TXT file up to 25 MB, with every delimiter, encoding, type and formatting option. Pro: up to 50 files at once, merged into one workbook or downloaded as one ZIP. Runs on your device.

Convert CSV to Excel

The settings, and when to touch them

Most files need no settings at all. When one does, the preview tells you which. This table maps what you see to the control that fixes it.

SettingChange it whenWhat it does
DelimiterAll data is in one column, or columns are split in the middle of valuesAuto, Comma, Semicolon, Tab or Pipe. Auto tests a sample of the whole file and ignores separators inside quotes
Quote characterStray quote marks stay at the start or end of cellsDouble quote, apostrophe or none
Encodingé, ü, ñ or ç show as two odd symbolsAuto-detect, UTF-8, UTF-16 LE/BE, Windows-1252, ISO-8859-1. A byte-order mark in the file always wins
Skip leading rowsA title or export date sits above the headerStarts the sheet at the real header row
Number formatAmounts come out 1,000 times too big or smallChooses between 1,234.56 and 1.234,56
Date orderDates such as 03/04 land on the wrong monthDay first, Month first or Year first, used only where a column gives no clue
Detect numbers, dates and typesYou want every cell kept exactly as writtenOff writes everything as text
Trim empty rows / columnsThe export has blank rows or columns at the endDrops them so the sheet ends where the data does

When auto-detection is unsure of the delimiter, the tool says so: a note reports which separator it used and what share of rows matched. Below a clear majority, set the delimiter by hand. Semicolon files are common from European spreadsheets, because there the comma is the decimal mark. Tab-separated files often arrive with a .txt extension, which the converter accepts.

Leading zeros, long numbers and what stays text

A spreadsheet number cannot hold a leading zero, and Excel keeps only 15 significant digits. Convert 00742 to a number and it becomes 742; convert a 19-digit card number and the last digits turn into zeros. Neither can be undone from the workbook. The converter therefore keeps three kinds of value as text even with type detection on:

  • A zero followed by another digit, such as 007, 00123 or 0044. Zip codes, SKUs and extension numbers keep their zeros.
  • More than 15 significant digits, such as IMEI numbers, card numbers and long order IDs, which a number would silently change.
  • A leading plus sign, such as +44 20 7946 0000, because that is a dialling prefix far more often than a positive sign.

These rules hold even if you turn Detect numbers, dates and types off. If you really want 007 to become the number 7, set that column to Number in the preview header. The reverse case is a column of reference numbers that look like ordinary numbers, such as invoice numbers 10452 and 10453: they would be converted, so set the column to Text if you never do arithmetic on them.

Value in the CSVBecomesWhy
1,234.56 or (250.00)Number (negative for the brackets)An unambiguous amount, finance-style negative
12%0.12 shown as 12%A real percentage you can calculate with
$19.99 or €19.99Number with a currency formatThe symbol becomes formatting
TRUE / FALSEExcel true/falseYes and No stay text, because they are words
A-1, 10-20, May 2024TextA part number, a size and a period label, not dates
30/02/2026TextThe date does not exist, so it is not shifted to March

Getting dates right

The date 03/04/2026 is 3 April in most of the world and March 4 in the United States. The converter settles this per column from the data: if any date in the column has a part above 12, such as 25/04/2026, the order is known and nothing needs setting. Only when a column is ambiguous from top to bottom does Date order decide. ISO dates such as 2026-12-31 are always read as written. Every converted date gets a date format, so it displays as a date rather than as a serial number like 46022, and columns are widened so the cell does not show a row of hash signs.

Which output format to choose

XLSX is the right answer for nearly everyone. The Output format menu offers others for systems that ask for them.

FormatMax sizeUse it forCaveat
XLSX1,048,576 rows × 16,384 columnsExcel, Google Sheets, Numbers, most softwareNone
XLSM1,048,576 × 16,384A system that insists on a macro-enabled fileA CSV has no macros to carry
XLSB1,048,576 × 16,384Binary workbooks some Excel setups preferNo filter buttons
XLS (97-2003)65,536 rows × 256 columnsVery old softwareNo filter buttons; larger files are trimmed
ODS (OpenDocument)1,048,576 × 16,384LibreOffice and OpenDocument workflowsNone

If a file has more rows or columns than the chosen format can hold, the tool says so next to the format menu, with the row and column counts, before you convert. For a CSV over a million rows, no spreadsheet format will hold it whole; break it up with Split CSV and convert the parts.

When the result still looks wrong

  • Everything is in column A. The delimiter was misread. Set it by hand; if the file came from a European export, try Semicolon first.
  • Accented letters show as é or similar. The encoding is wrong. Try UTF-8, then Windows-1252. If the tool notes that the file declares an encoding, that byte-order mark was obeyed and the file itself may have been damaged earlier.
  • Letters show as question marks or empty boxes. The characters were lost before the CSV reached you. No encoding brings them back; export the source again as UTF-8.
  • The header is a report title. Set Skip leading rows to the number of lines above the real header.
  • Amounts are wrong by a factor of 1,000. The number format is reversed. Set Number format to match the file.
  • A column of codes became numbers. Set that column to Text in the preview and convert again.
  • The sheet name came out shorter or different. Excel allows at most 31 characters and no characters such as / ? * [ ] in a sheet name, so the converter strips them and caps the length. Pick a shorter name.

To confirm the result without opening desktop Excel, load the workbook in the Excel Viewer. Going back the other way later is a job for Excel to CSV.

One file free, batches and merging with Pro

Every option that decides whether the spreadsheet is correct is free: delimiter, quote character, encoding, type detection, per-column types, frozen header, filters, column widths, trimming, sheet name and output format. Free converts one file at a time, up to 25 MB. Pro adds scale: up to 50 files at once with shared settings, Combine into one workbook to put each CSV on its own sheet named after its file, and one ZIP download for the whole batch. If you change a setting after converting, finished files are marked out of date so you can re-apply in one press.

Frequently asked questions

How do I convert CSV to Excel online for free?

Add the CSV to the converter, check the preview for proper columns and readable characters, adjust the delimiter, encoding or column types if needed, and press Convert to XLSX. Free covers one file up to 25 MB with every option.

How do I convert CSV to XLSX without losing leading zeros?

Values that start with a zero followed by another digit, such as 00742, are kept as text automatically, so the zeros survive. For a column the rule does not catch, set its type to Text in the preview header before converting.

Why do long numbers end in zeros after conversion?

Excel stores numbers with 15 significant digits, so a longer value loses its last digits when turned into a number. The converter keeps anything over 15 digits as text, so card numbers, IMEIs and long order IDs arrive unchanged.

Why are my dates the wrong way round?

The column contains only dates such as 03/04 that read both ways. Set Date order to Day first or Month first. If any date in the column has a day above 12, the order is worked out from the data and needs no setting.

Can I convert several CSV files into one Excel workbook?

Yes, with Pro. Add up to 50 files and turn on Combine into one workbook: each CSV becomes its own sheet, named from its filename. Free converts one file at a time.

Is it safe to convert a CSV with personal data?

The file is read, typed and written as XLSX on your device, not on our servers, so the rows are not uploaded in order to be converted.

Keep reading

More in Documents →