CSV or TSV JSON

To get started, upload or paste your data from Excel (saved as CSV or TSV).


Download Copy to clipboard

More Details

  • 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.

© Copyright 2020- by Collegeek. All Rights Reserved.