Table to JSON Converter — Free Online Tool
tab2json.com is a free online tool that converts table data into JSON format. Paste directly from Excel, Google Sheets, or any spreadsheet — the tool automatically detects your delimiter and generates clean, valid JSON. It also handles CSV, TSV, pipe-separated, and custom-delimited files. All processing happens in your browser, so your data stays completely private.
How to convert a table to JSON online
- Copy your table: Select your data in Excel, Google Sheets, or any spreadsheet and copy it (Ctrl+C / Cmd+C).
- Paste it here: Click the input box and paste (Ctrl+V / Cmd+V). You can also drag and drop a .csv or .tsv file.
- Choose your delimiter: Use auto-detect or manually select tab, comma, semicolon, or pipe.
- Convert: Click "Convert" to instantly transform your table into valid JSON.
- Copy or download: Use "Copy" to copy to clipboard, or "Download" to save as a .json file.
Supported Formats
- Excel (tab-separated when pasted)
- Google Sheets (tab-separated when pasted)
- CSV (comma-separated values)
- TSV (tab-separated values)
- Pipe-delimited files
- Semicolon-delimited files
- Whitespace-delimited data (2+ spaces)
Common Use Cases
- API development: Convert spreadsheet data to JSON for API responses.
- Data migration: Transform tables from Excel or Google Sheets into JSON for NoSQL databases like MongoDB or Firebase.
- Web development: Convert data tables to JSON for use in React, Vue, or Angular applications.
- Configuration files: Transform tabular config data into JSON format for application settings.
- Testing: Quickly create JSON test fixtures from spreadsheet data.
Frequently Asked Questions
Is my data safe?
Yes. All conversion happens directly in your browser using JavaScript. Your data is never uploaded to any server, stored anywhere, or transmitted over the internet.
Can I convert CSV to JSON?
Yes. The tool supports multiple delimiters including commas. Select "Comma" as your delimiter or use auto-detect.
What about Excel and Google Sheets?
When you copy data from Excel or Google Sheets, it is tab-separated. Our tool detects this automatically — just paste and convert.
Please enable JavaScript to use the converter tool.
About | Privacy Policy | Excel to JSON Guide