Are my data or files sent to the server?

No. CSV, TSV, TXT and JSON are read and processed locally in your browser. File names and contents are not uploaded.

Does it preserve values such as 001?

Yes. Table cells remain text by default, so identifiers and leading zeros are preserved.

What JSON can be converted to a table?

Objects, arrays of objects, arrays of primitives and scalar values. Nested objects can be flattened up to depth 5.

Can I remove duplicates from CSV data?

Yes. Deduplicate by full row or selected key columns while keeping the first occurrence.

How does list comparison normalize values?

Trimming, case and accent handling can be changed for matching without silently rewriting the preserved value.

Can I split or join columns without Excel?

Yes. Split one column by a literal separator or join several columns in a chosen order.

Which formats can I export?

Table modes export CSV, TSV and JSON. List comparison exports TXT, CSV and JSON.

Why is there a spreadsheet formula warning?

Values starting with =, +, - or @ can be interpreted as formulas by spreadsheet software. The tool preserves them and warns you to review them.

Data lists tool: CSV, JSON and tables

Privacy: everything is processed in your browser. Data and file names are not sent to the server or stored. Avoid pasting passwords, secrets or unnecessary personal data.

Paste data or open a local file to convert CSV, TSV, tables and JSON, compare lists, or split and join columns. Table cells remain text by default, including 001.

CSV, TSV / TableMaximum: 5 MiB, 100,000 rows, 200 columns and 2,000,000 cells. Open local fileRead only with browser APIs. It is not uploaded.

Interpret data

Delimiter Custom delimiterExactly one character. Headers Trim cell whitespace Remove completely empty rows

Deduplicate rows

Remove duplicates Deduplicate rows Case sensitive Ignore surrounding spaces when comparing

Output columns

No columns detected yet.

Output

Primary formatDefines what Copy result uses. CSV/TSV line ending Add UTF-8 BOM when downloading CSV/TSV

No result

CSV / Table ready. Configure the data and press Process.

Summary

Process a table to see rows, columns, duplicates and transformations.

No warnings.

Preview

No preview.

Copy and download

No result

JSON / Table ready. Configure the conversion and press Process.

Summary

No warnings.

Preview

No preview.

Copy and download

No result

Columns ready. Configure the transformation and press Process.

Summary

No warnings.

Preview

No preview.

Copy and download

Spreadsheet formula warning

Values beginning with =, +, - or @ are preserved exactly and flagged because spreadsheet programs may interpret them as formulas. Review them before opening exported CSV files.

CSV, TSV and tables

The parser supports quoted fields, embedded delimiters and line breaks, escaped quotes, UTF-8 BOM and CRLF/LF/CR endings. Deduplication keeps the first occurrence.

Nested JSON and types

JSON → Table accepts objects, arrays and scalar values. Nested objects can be flattened up to depth 5. Table → JSON keeps strings by default unless type inference is enabled.

Compare lists

Compare common and exclusive items, union and internal duplicates. Optional normalization affects matching only and keeps the first spelling by default.

Split and join columns

Split one column with a literal separator or join multiple columns in a chosen order. New names are made unique deterministically.

Privacy, exports and limits

Files are read with FileReader and downloads are generated locally. Preview is limited to 200 rows while exports use the complete processed dataset within the documented limits.

Improve this calculator

Found an error or missing a feature?

Send us the example so we can review this calculator and turn real cases into improvements or automated tests.

Summary

Preview

Copy and download

Summary

Preview

Copy and download

Summary

Results

Copy and download

Summary

Preview

Copy and download

Spreadsheet formula warning

CSV, TSV and tables

Nested JSON and types

Compare lists

Split and join columns

Privacy, exports and limits

Found an error or missing a feature?

You may also like

Online text cleaner