Free online CSV and TSV tools

Change CSV DelimiterChange the field delimiter of CSV data, for example to semicolons or pipes, with quoting handled correctly. Sort CSV ColumnsSort the columns of CSV alphabetically by their header name. Convert CSV to JSONConvert CSV to a JSON array of objects using the header row as keys. Convert Text to CSVTurn plain text columns separated by spaces or any delimiter into CSV. Extract CSV ColumnsExtract the columns you need from CSV by number or range, in the order you list them. Remove CSV QuotesRemove the quotes around CSV fields when they are not needed. Validate CSVValidate CSV: find unbalanced quotes and rows with the wrong number of fields. Convert JSON to CSVConvert a JSON array of objects to CSV, with nested objects flattened into dot-notation columns. Convert CSV to XMLConvert CSV rows to XML records, one element per column. Convert CSV to YAMLConvert CSV to a YAML list of mappings using the header row as keys. Convert CSV to TSVConvert CSV to TSV, handling quoted fields and commas inside values correctly. Convert TSV to CSVConvert TSV (tab-separated values) to CSV, quoting fields that contain commas. Convert CSV to TextTurn CSV into a neatly aligned plain-text table. Generate Random CSVGenerate random CSV test data with names, cities, ages, scores and flags. Convert CSV to Base64Encode CSV data as Base64. Convert Base64 to CSVDecode Base64 back into CSV data. URL Encode CSVPercent-encode every field of CSV for use in URLs. URL Decode CSVDecode percent-encoded fields in CSV. Delete CSV CommasRemove the delimiters from CSV and join the fields with spaces or any text. Prepend CSV ColumnsAdd new columns to the start of every row in CSV. Append CSV ColumnsAdd new columns to the end of every row in CSV. Insert CSV ColumnsInsert a new column at any position in CSV; {row} inserts the row number. Replace CSV ColumnsReplace the values of a CSV column, everywhere or only where they match. Delete CSV ColumnsDelete columns from CSV by number or range, like 2 or 3-5. Swap CSV ColumnsSwap two columns in CSV. Convert CSV Columns to RowsTurn the columns of CSV into rows, flipping the table on its side. Convert CSV Rows to ColumnsTurn the rows of CSV into columns, so each record becomes a column. Transpose CSVTranspose CSV so rows become columns and columns become rows. Truncate CSV ColumnsKeep only the first N columns of CSV, or cut every field to a maximum length. Trim CSV ColumnsTrim spaces from the start and end of every field in CSV. Add CSV QuotesWrap every field of CSV in quotes, escaping quotes inside. Change CSV QuotesChange the quote character used in CSV, for example from double to single quotes. Analyze CSVAnalyze CSV: count rows, columns and empty fields, and detect column types. Test CSVTest whether text is well-formed CSV with the same number of fields on every row. Find Incomplete CSV RecordsFind rows in CSV that have fewer (or more) fields than the header. Fill Incomplete CSV RecordsPad short rows in CSV with a filler value so every row has the same number of fields.

Test TSVTest whether text is well-formed TSV with the same number of fields on every row. Sort TSV ColumnsSort the columns of TSV alphabetically by their header name. Delete TSV TabsRemove the delimiters from TSV and join the fields with spaces or any text. Convert Text to TSVTurn plain text columns separated by spaces or any delimiter into TSV. Transpose TSVTranspose TSV so rows become columns and columns become rows. Analyze TSVAnalyze TSV: count rows, columns and empty fields, and detect column types. Change TSV DelimiterChange the field delimiter of TSV data, for example to semicolons or pipes, with quoting handled correctly. Generate Random TSVGenerate random TSV test data with names, cities, ages, scores and flags. Extract TSV ColumnsExtract the columns you need from TSV by number or range, in the order you list them. Delete TSV ColumnsDelete columns from TSV by number or range, like 2 or 3-5. Quote TSV ColumnsWrap every field of TSV in quotes, escaping quotes inside. Unquote TSV ColumnsRemove the quotes around TSV fields when they are not needed. Swap TSV ColumnsSwap two columns in TSV. Convert TSV to TextTurn TSV into a neatly aligned plain-text table. Convert TSV to Base64Encode TSV data as Base64. Convert Base64 to TSVDecode Base64 back into TSV data.