csvjson.com Open in urlscan Pro
2606:4700:20::ac43:4929  Public Scan

Form analysis
0 forms found in the DOM

Text Content

Turnkey CSV Importer • Installs in minutes


THE EASY, CONFIDENTIAL ONLINE DATA CONVERTER

Csvjson helps you quickly convert popular data formats to the format you need.
Data pasted and converted remains local on your computer.

Csv to json Json to csv Json beautifier
Json validator Sql to json Csvjson to json



ABOUT DATA FORMATS

CSV

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.

JSON

JSON stands for JavaScript Object Notation and has become the defacto computer
format readable by humans to store structured data.

From APIs to configuration files, JSON is now everywhere.

SQL

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.


ABOUT CSVJSON

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.

View Change Log

2022-1-21

Upgraded to Bootstrap 5.

2019-10-01

Integrated design for sponsorship by Flatfile.

2019-07-15

JSON 2 CSV bug fix. BOM was missing causing the lost of accented characters in
Excel. Fix for GitHub issue #78. Thanks to EL BAZA for reporting.

2019-06-25

JSON Beautifier improvement. Variable width when inlining short arrays. For fix
GitHub issue #76. Thanks to galileo-pkm for reporting.

2019-06-06

Fixed bug where uploading a file went to the result box instead of the json box.
GitHub issue #75. Thanks to Emily for reporting.

2019-03-20

CSV to JSON bug fix: Detect duplicate column headers and make them unique.
GitHub issue #71. Thanks to Summer for reporting.

2019-02-03

Function json2csv now available as a npm package. Function json_beautifier now
available as a npm package.

2019-02-02

Function csv2json now available as a npm package.

2019-01-26

Improvement: Removed 64k limit on download button.

2018-12-26

Confidentiality statement and improvements on Data Janitor.

2018-12-01

Added a new tool Data Janitor to perform Excel and Google Sheets data cleaning
and transformation.

2018-11-18

Added a copy-to-clipboard button and upgraded underscore and backbone to latest
versions.

2018-09-13

Added a new tool JSON Validator to validate and format JSON. Integrates a
beautiful code editor (CodeMirror) with interactive JSON linting.

2018-04-03

Added a new tool CSVJSON to JSON to support conversion of the new CSVJSON
format, a CSV variant proposed by Dror Harari.

2018-03-31

Improvements to CSV converters to support CSVJSON format variant (csvjson.org).

2018-01-24

Added a new converter: JSON to CSV.

New button to report a bug or ask for improvements.

2018-01-08

Support escaped quotes in SQL to JSON: GitHub issue #26. Thank you lbottoni for
reporting.

2017-12-18

SQL to JSON parsing bug fix. Convert NULL to null.

Added a minify option to compact JSON by removing spaces and new lines. Fix for
GitHub Issue #21. Thank you Myat Min Soe for requesting this feature.

2017-12-13

SQL to JSON parsing bug fix. Do not split when detecting a comma in a string
value: GitHub Issue #25.

2017-10-07

Abimbola Idowu added single quote option. GitHub issue #23

2017-09-04

SQL to JSON parsing bug fix: GitHub Issue #22.

2016-09-27

CSV to JSON improvement: GitHub Issue #13 - Added option to parse number values
or not to retain original number formatting.

2016-09-27

JSON Beautifier bug fix and improvement: GitHub Issue #12 - Inline short arrays
bug fix and improvement. Added nesting depth option.

2016-08-29

SQL to JSON bug fix: GitHub Issue #11 - support multile values in single-line
INSERT INTO statement.

2016-08-22

JSON Beautifier bug fix: Inline short arrays was not working properly. GitHub
issue #9

2016-07-09

CSV to JSON bug fix: If no text is present in a csv field, it was assigned 0
(zero) by default.

2016-06-20

CSV to JSON bug fix: strings containing quotes and commas were prematurely cut.

2016-03-19

Make the GitHub repository public again. Re-opened to community.

2015-11-25

Added options to CSV to JSON:

 * Transpose: You can now transpose the csv data before conversion.
 * Output object instead of array: By default an array of objects is output. You
   can now output an object or hash. The first column becomes the hash key.


CONFIDENTIALITY

Any data pasted and converted on csvjson remains local on your computer. Data is
never sent to the server.

Three exceptions are:

 1. You upload a file. Data is sent to the server and downloaded back for use.
    The uploaded file gets deleted and is not tracked.
 2. You Save a permalink to your session to share with co-workers. Your data
    gets persisted on the server. It can be deleted by clearing the data and
    saving again.
 3. For instrumentation purposes, we save column headers when you convert CSV to
    JSON. The content is never saved.



 * Rage designed and built with love by the Flatfile team with the help of our
   contributors.

CONVERT

 * CSV to JSON
 * JSON to CSV
 * SQL to JSON
 * CSVJSON to JSON

VALIDATE & TRANSFORM

 * JSON Validator
 * JSON Beautifier
   

COMMUNITY

 * Github
 * Change Log
 * Issues
 * Docs
 * Corporate sponsor