Convert your SQL table or database export to JSON or JavaScript.

1) Copy/paste or upload your SQL export to convert it. 2) Convert to JSON or JavaScript (one variable is created per table). 3) Copy and paste back to your computer. 4) Save your result for later or for sharing.

Upload a SQL file Select a file...

Or paste your SQL here

Output format

JSON JavaScript Minify

Result

Download Copy
Bug or suggestion?

About SQL to JSON

Works by detecting CREATE TABLE and INSERT INTO statements, in order to create an object representation of the tables.

Change Log

Jan 26, 2019 Improvement: Removed 64k limit on download button.
Jan 8, 2018 Support escaped quotes: GitHub issue #26. Thank you lbottoni for reporting.
Dec 18, 2017 Bug fix: Convert a NULL value to null.
Dec 18, 2017 Improvement: Added option to minify or compact JSON. GitHub issue #21
Dec 13, 2017 Parsing bug fix not to split when detecting a comma in a string value: GitHub Issues #17 and #25. Thank you Idafe and Jay Vince Serato for reporting the issue.
Sep 4, 2017 Parsing bug fix: GitHub Issue #22.
Sep 29, 2016 Bug fix GitHub Issue #11 - support multile values in single-line INSERT INTO statement.
Jan 12, 2014 Initial release.

Feedback

Code available on GitHub. Report bugs or ask for improvements through GitHub issues.