Skip to content

CSV to Excel

Paste CSV or TSV data and download it as an Excel XLSX, an older XLS or an OpenDocument ODS file. The delimiter is detected automatically or chosen by you, and numbers and ISO dates can be stored as real numbers and dates so formulas and sorting work right away.

Reset

Frequently asked questions

Which delimiters are supported?

Comma, semicolon, tab and pipe. With automatic detection the tool looks at the data and picks the most likely of these four. Quoted fields with delimiters, quotes and line breaks inside them are handled as in RFC 4180.

How are numbers and dates detected?

With type detection on, plain numbers such as 42, -3.5 or 1e6 become numbers and dates written as YYYY-MM-DD become date cells in XLSX and XLS files. Values with leading zeros, such as 00123, and values with spaces around them stay text, so ZIP codes and IDs keep their zeros. Turn the option off to keep every cell as text.

Why do dates stay text in ODS files?

The library that writes ODS files does not write the date format reliably, so dates are kept as text there to avoid wrong display. XLSX and XLS files get real date cells formatted as YYYY-MM-DD.

What can I name the sheet?

Up to 31 characters, the limit Excel sets. The characters [ ] : * ? / and the backslash are not allowed in sheet names and are removed.

What are the limits of the XLS format?

The older XLS format holds at most 65,536 rows and 256 columns per sheet. For larger data choose XLSX, which this tool fills up to 50,000 rows.

What are the limits?

Up to 2,000,000 characters of input, 50,000 rows, 1,000,000 cells and 32,767 characters per cell, which is the most a cell in Excel can hold.

About OneClick Pro

OneClick Pro is a free collection of more than 150 web tools for everyday work: converting images and units, formatting and validating code, checking domains and SEO, and working with text, dates and numbers. Every tool runs without registration or subscription, and what you enter is only used to calculate your result and is never stored. Use it as a quick toolbox for one-off tasks, or bookmark the tools you rely on every day.