{ }
No signupJSON Formatter
Format, validate, and minify JSON with syntax highlighting.
Open tool⊞
Table to JSON
Convert a Markdown table or spreadsheet paste into JSON - format auto-detected.
table-to-json.tool
JSON output will appear hereNothing you paste here is ever sent to a server - conversion happens locally in your browser.
What is a table to json?
This tool converts a table - a Markdown table, or rows copied straight from Excel or Google Sheets - into structured JSON. It automatically detects the format, so you can usually just paste and go, whether that's pipe-delimited Markdown or tab-separated spreadsheet data.
How to use this tool
- 1Paste a Markdown table, or copy cells directly from Excel/Sheets and paste them here.
- 2Leave the format on Auto, or pick Markdown/Tab/Comma/Pipe explicitly if detection guesses wrong.
- 3Toggle whether the first row is headers, and whether to infer real types (numbers, booleans, null).
- 4Copy the JSON or download it as a .json file.
Common use cases
Turning a table from documentation or a README into usable JSON data
Converting a quick copy-paste from a spreadsheet into an API-ready format
Extracting structured data from a Markdown table in a wiki or notes app
Prototyping with real spreadsheet data without exporting a CSV file first
Good to know
Frequently asked questions
How does auto-detection decide the format?
It first checks for a Markdown table separator row (a line of dashes like |---|---|). If that's not found, it looks for tabs, then commas, then pipes, in that order - tabs are checked first since that's what a spreadsheet paste produces.
What if auto-detection picks the wrong format?
Just click Markdown, Tab, Comma, or Pipe directly to override it - the table re-converts immediately.
Does it support Markdown table alignment syntax?
Yes - separator rows using colons for alignment (like |:---|---:|) are recognized correctly and don't end up as a data row.
Is my data sent anywhere?
No - detection and conversion both happen entirely in your browser, whether you paste the table or upload a file.
quick_facts.json
{
"runs_in_browser": true,
"data_sent_to_server": false,
"signup_required": false,
"price": "free",
"category": "JSON Tools"
}