Secure and easy CSV Data Conversion

NEW - Site redesigned! You may find the Old Site if needed. Buy ConvertCSV a Coffee at ko-fi.com

Special Features

Card image cap

Convert to/from
HTML, JSON, XML Text, KML, YAML, MediaWiki, Markdown
plus many more.

Card image cap

CSV Viewer and Editor
can read or edit any Excel file.
Including large files.

Card image cap

Copy and paste Excel data
into our tools as Tab separated (TSV). Read and Convert Excel to CSV automatically.

Card image cap

Use SQL to query CSV
and write to CSV or JSON.
Field separators auto-detect mode is default.

Card image cap

Extract emails
or urls from webpages.
Write the data to CSV.

Card image cap

Query or Sort CSV
filter data to include/exclude records. Order data either alphabetically or numerically.

Card image cap

Optional double or single quotes
around values. All double/single-quotes can be treated as data

Card image cap

Backslash escaping support
for input data.

Card image cap

CSV Template Engine
Built-in Scripting Engine for custom output

Card image cap

Checks for correctness
of CSV files.

Card image cap

Fully supports
RFC 4180 CSV standard.

Card image cap

Data privacy is assured.
Our tools run on the completely on the client-side. your data never leaves your computer

FAQ

What is CSV?
Comma Separated Values (CSV) is a format for tabular data in a plain text file. Each data value is separated by a comma. If the value contains a comma (delimiter), line break, or double-quote, then the value is enclosed by double-quotes. If the value is surrounding by double-quotes and contains a double-quote then each embedded double-quote is doubled to two double-quotes. This tool also support the popular tab-delimited (TSV) data format used by Excel, and other delimiters such a colon, semi-colon, caret, spaces, and vertical bar.
Example:

id,name,amount,Remark
1,"Johnson, Smith, and Jones Co.",345.33,Pays on time
2,"Sam ""Mad Dog"" Smith",993.44,

Do you have command-line tools (CLI)?
Yes - we now have Command Line Tools for JSON to CSV, JSON to XML, XML to CSV, and YAML to CSV and more. Contact Us for more information.

Do you have an API?
Not yet, but coming soon in 2020.

What is a Delimited File?
A Delimited File is a data format with values separated by a delimiter. CSV is an example. Other examples are files delimited by Tabs (TSV), semi-colon, and the bar character |. Though the strict definition of CSV defines comma as the separator, in general CSV refers to other delimiters also. Our site uses the the term CSV in the broad definition. Our online tools support all these formats and more.

How do I use this tool with Excel data?
You must copy cells from Excel and paste into this tool. The copied data will be Tab-Delimited. Likewise you can copy from this tool and paste into Excel. Choose TSV as the output format or save the file and import it into Excel.

How do I force Excel to import a number to text?
This is a common problem in Excel when reading CSV files and not using the Import Text Wizard. When Excel determines a field is a numeric value, it automatically formats the field as numeric. Placing double-quotes around the field does not help, neither does adding spaces around the number. The only method that works is starting the field with a equal sign and then double-quoting the field. If the value has a comma though, then you must follow the CSV rules and enclose in double quotes.
Our tools will read and write fields formatted with beginning equal signs. See the CSV-to-Delimited tool to prepare your CSV files for Excel.

For developers - What is the CSV MIME type?
The quick answer is "text/csv" but for best results, use this in your web pages:

Content-Type: text/csv; name=“filename.csv”
Content-Disposition: attachment; filename=“filename.csv”