CSV or TSV JSON

Embed all the functionality of csvjson in any web application with Flatfile. Auto-match columns, validate data fields, and provide an intuitive CSV import experience.

• This function is available as a npm package
• CSV stands for Comma Separated Values. Often used as an interchange data format to represent table records, one per line. CSV is plain text.
• The CSV format is documented in an RFC memo RFC-4180.
• The first line is often the header, or column names. Each subsequent row is a record and should have the same number of fields.
• Fields containing the separator character, line breaks and double-quotes must be enclosed inside double quotes ".
• Other separator are often used like tabs \tor semi-colons ;. TSV or Tab Separated Values is used to store table data in Clipboards. When data is copied from Excel for example, it is stored as TSV in the Clipboard.
• With CSVJSON you can parse values as numbers or JSON. Turn on respective Parse Numbers and Parse JSON switches to convert valid numbers and JSON (null, false, true, [] and {}).
• With CSVJSON you can transpose the csv before conversion. Rows become columns, and columns become rows.
• With CSVJSON you can output a hash (or object) instead of an array. In that case, the hash key will be the first column.

View Change Log