CSV or Comma Separated Values is widely used for tabular data and often associated to spreadsheet applications like Excel.
Many data reporting tools output to CSV format.
From APIs to configuration files, JSON is now everywhere.
SQL stands for Structured Query Language and is the standard language for relational database management systems.
SQL is one of the most-used languages in the tech industry.
As a developer, format conversion is something we sometimes have to do. We often look online for solutions and tools finding they only cover partly our needs. Flatfile is proud to offer csvjson, a do-it-yourself csv converter to the community for free. Its best feature? You can save your session for later, and share it with a co-worker.
Upgraded to Bootstrap 5.
Integrated design for sponsorship by Flatfile.
csv2json now available as a npm package.
Improvement: Removed 64k limit on download button.
Confidentiality statement and improvements on Data Janitor.
Added a new tool Data Janitor to perform Excel and Google Sheets data cleaning and transformation.
Added a copy-to-clipboard button and upgraded underscore and backbone to latest versions.
Added a new tool JSON Validator to validate and format JSON. Integrates a beautiful code editor (CodeMirror) with interactive JSON linting.
Improvements to CSV converters to support CSVJSON format variant (csvjson.org).
Added a new converter: JSON to CSV.
New button to report a bug or ask for improvements.
SQL to JSON parsing bug fix. Convert
SQL to JSON parsing bug fix. Do not split when detecting a comma in a string value: GitHub Issue #25.
SQL to JSON parsing bug fix: GitHub Issue #22.
CSV to JSON improvement: GitHub Issue #13 - Added option to parse number values or not to retain original number formatting.
JSON Beautifier bug fix and improvement: GitHub Issue #12 - Inline short arrays bug fix and improvement. Added nesting depth option.
SQL to JSON bug fix: GitHub Issue #11 - support multile values in single-line INSERT INTO statement.
JSON Beautifier bug fix: Inline short arrays was not working properly. GitHub issue #9
CSV to JSON bug fix: If no text is present in a csv field, it was assigned 0 (zero) by default.
CSV to JSON bug fix: strings containing quotes and commas were prematurely cut.
Make the GitHub repository public again. Re-opened to community.
Added options to CSV to JSON:
Any data pasted and converted on csvjson remains local on your computer. Data is never sent to the server.
Three exceptions are: