CSV to JSON Converter: CSV to SQL & Markdown Online

Convert a CSV or Excel file to a JSON array, SQL INSERT statements or a Markdown table, or turn JSON back into CSV. Free, private, no upload.

Related tools

JSON string converterTurn objects into JSON strings and back, or tidy messy JSON. CSV to PDFPrint your spreadsheet data as a clean PDF table. Bulk QR codesMake a QR code for every row of a list in one go. Typing speed testCheck your WPM for data entry and clerk jobs.

Free CSV to JSON converter online

CSV (comma-separated values) is the file format almost every spreadsheet can export, but websites, APIs and databases usually want something else. This converter turns the CSV you paste or upload into formatted JSON, ready-to-run SQL INSERT statements, or a Markdown table in one click. Everything happens inside your browser, so your data is never uploaded to a server.

How to use the CSV converter

  1. Paste your CSV into the box, or click Upload .csv file and choose a file from your computer.
  2. Make sure the first row holds your column names (for example Name, Role, Department).
  3. Click To JSON, To SQL or To Markdown.
  4. Use Copy to put the result on your clipboard, or Download to save it as a file.

Example

Input CSV:

Name,Role
Ann,Developer
"Smith, John",Tester

JSON output:

[
  { "Name": "Ann", "Role": "Developer" },
  { "Name": "Smith, John", "Role": "Tester" }
]

What each output is good for

  • JSON: an array of objects, one per row, with your column names as keys. Use it to seed a web app, test an API, or load data into JavaScript, Python or Node.
  • SQL: a ready-made INSERT INTO my_table statement with all your rows, written with MySQL-style quoting. Rename the table to match yours. A quick way to import a spreadsheet into a database.
  • Markdown: a clean table you can paste into a README, a GitHub issue, a wiki or a documentation page.

CSV to SQL, Excel to JSON and CSV to Markdown table

The same tool covers several common searches. Use it as a CSV to SQL INSERT generator to load a spreadsheet into MySQL or SQLite, as an Excel to JSON converter (upload the .xlsx file directly), or as a CSV to Markdown table converter for README files and documentation. The JSON output is an array of objects, which is the format most APIs, front-end apps and database import tools expect.

Common uses

  • API development and testing: turn a spreadsheet of sample records into JSON for mock data and request bodies.
  • Database import: create INSERT statements, or a JSON array that import tools such as MongoDB's can read.
  • Charts and dashboards: feed JSON into libraries like Chart.js or D3.
  • Documentation: paste a Markdown table into GitHub, GitLab or a wiki.

Who uses it

Developers moving spreadsheet data into a project, analysts preparing a quick import, support teams sharing a table in a ticket, and students who just need a CSV in another format. Because there is nothing to install and no sign-up, it is handy for one-off jobs.

Tips for clean results

  • Keep one header row and make column names unique, so the JSON keys and SQL columns are clear.
  • Wrap any value that contains a comma in double quotes, for example "Smith, John". The converter understands quoted fields.
  • Excel files (.xlsx, .xls, .ods) can be uploaded directly; the first sheet is loaded and you can switch sheets.
  • Check the SQL output before running it on a live database, and change my_table to your own table name.

Frequently asked questions

How do I convert a CSV file to JSON?

Paste the CSV into the box or upload the .csv file, make sure the first row has your column names, then click To JSON. Copy the result or download it as a file.

How do I convert Excel to JSON?

Upload the .xlsx file directly with the Upload button, pick the sheet if there is more than one, then click To JSON.

Can I convert JSON to CSV?

Yes. Paste a JSON array into the box and click JSON to CSV. Nested objects become columns such as address.city, and lists are kept as JSON text in one cell.

Is my data uploaded anywhere?

No. The conversion is done by JavaScript in your own browser. Your rows never leave your device, so it is safe for private or work data.

Is there a file size limit?

The site sets no limit. Because your browser does the work, very large files depend on your computer's memory. Files with tens of thousands of rows convert quickly on most devices.

Are commas inside quotes handled correctly?

Yes. A value such as "Paris, France" stays in one column instead of being split in two.

Can I convert an Excel (.xlsx) file?

Yes. Upload the .xlsx, .xls or .ods file directly. The sheet is turned into CSV in the box, and you can pick another sheet from the list. If you only have a PDF table, try the PDF to Excel tool in the PDF Toolkit.

Which databases does the SQL output work with?

It is a standard INSERT INTO statement and column names are wrapped in backticks, which MySQL and SQLite accept. For PostgreSQL, replace the backticks with double quotes. Always rename the table and review values before running it.

Is it free?

Yes, it is free to use with no account needed.

More free tools

Bulk QR code generator · Image compressor and converter · PDF toolkit · Read the guide: converting CSV to JSON