CSV, TSV, JSON and XML Converter

About the Data Converter

Converts between Column (one value per line), CSV, TSV, JSON and XML, in any direction. It can auto-detect the input format, accepts a file upload, and lets you choose the quote style of CSV and TSV output.

How to use it

1. Paste your data or upload a .csv, .tsv, .json or .txt file.
2. Leave auto-detect on, or choose the input format yourself.
3. Pick the output format and, for CSV or TSV, the quote style.
4. Click Convert, then copy the result or download it.

Good for

• Turning a spreadsheet export (CSV) into JSON for an API or mock server
• Pasting a column of values from Excel and getting a JSON array
• Converting JSON API responses back into CSV for analysis
• Converting an XML export into JSON, or a JSON payload into XML

Tip: When a CSV has commas inside values, make sure those values are quoted; otherwise the columns shift. In XML, repeated elements such as <item> become rows. Check the first few converted rows before using the output.

Frequently asked questions

How do I convert CSV to JSON?

Paste the CSV with its header row, choose JSON as the output format and click Convert. Each row becomes a JSON object keyed by the header names.

Can it convert JSON back to CSV?

Yes. Choose JSON as the input and CSV as the output. The JSON should be an array of objects with the same keys.

What happens to commas inside values?

Quoted values such as "Doe, John" are read as one field, and values that need it are quoted again in CSV output.

More free tools

• Test Data GeneratorCreate realistic fake records for testing, demos and database seeding, then export them as JSON, CSV, XML, HTML, SQL inserts, Python or JavaScript.
• Random Password and Key GeneratorGenerate strong random passwords and keys with your choice of length and character sets, using your browser’s cryptographically secure random number generator.
• JavaScript Minifier and ValidatorCompress JavaScript with Terser for a smaller file, or validate code and see syntax errors with their line numbers.
• JSON Formatter and ValidatorBeautify and validate JSON, find the exact line of an error, and convert JavaScript object literals into strict JSON.
• SQL Formatter and BeautifierMake SQL queries readable or minify them to one line, for Standard SQL, MySQL, PostgreSQL and Transact-SQL.
• Diff Checker: Compare Two TextsCompare two blocks of text or two files and see what changed, line by line.
• Case ConverterChange text to UPPERCASE, lowercase or Title Case in one click.
• camelCase, PascalCase, snake_case and kebab-case ConverterTurn any phrase into programming naming styles as you type: camelCase, PascalCase, snake_case, kebab-case and Capitalized Case.
• YAML ValidatorCheck YAML files for syntax errors before they break a deployment, from Kubernetes manifests to GitHub Actions workflows.