Compare CSV by keys
Put the before table first. Match renamed columns, remove only the columns you exclude, and pick one or more key columns.
- Runs in your browser
- No upload
- Check before download
Files and cell values stay in this tab. Nothing is uploaded or saved. Closing or clearing the tab loses the inputs.
Put the before table first. Match renamed columns, remove only the columns you exclude, and pick one or more key columns. Decide how duplicate and empty keys are handled before you compare and export the change files.
UTF-8 only; BOM accepted. Cells and keys remain exact strings: 001 differs from 1. An empty cell is empty text, not inferred null; literal NULL stays text. Headers must be unique and nonempty. Quoted newlines are preserved. Formula-like cells remain unchanged; spreadsheets may execute them on opening.
First record is a header
Transforms: 8 files, 16 MiB per file and 32 MiB in total, 200,000 records, 128 columns, and 1,000,000 input or output cells. Split: 64 MiB, 1,000,000 records and 500 parts. A field can have up to 262,144 UTF-16 units and a record up to 1,048,576 characters. Output up to 128 MiB; the worker stops after 60 seconds. The ZIP bytes stay in memory, so this is not an unlimited disk stream.
Inspect the selected sources before choosing columns.
How to use it
- Choose files and delimiters
UTF-8 only; BOM accepted. Cells and keys remain exact strings: 001 differs from 1. An empty cell is empty text, not inferred null; literal NULL stays text. Headers must be unique and nonempty. Quoted newlines are preserved. Formula-like cells remain unchanged; spreadsheets may execute them on opening.
- Inspect and configure columns
Put the before table first. Match renamed columns, remove only the columns you exclude, and pick one or more key columns. Decide how duplicate and empty keys are handled before you compare and export the change files.
- Create and verify the native download
Keys and cells use exact text equality; missing columns differ from empty cells. Only mapped columns are compared. ZIP contains added, removed, changed-before, changed-after and changed-cells CSVs plus a manifest; presence flags distinguish absence from empty text.
Before exporting
CSV files
Files and cell values stay in this tab. Nothing is uploaded or saved. Closing or clearing the tab loses the inputs.
Empty-cell policy
UTF-8 only; BOM accepted. Cells and keys remain exact strings: 001 differs from 1. An empty cell is empty text, not inferred null; literal NULL stays text. Headers must be unique and nonempty. Quoted newlines are preserved. Formula-like cells remain unchanged; spreadsheets may execute them on opening.
Output
Transforms: 8 files, 16 MiB per file and 32 MiB in total, 200,000 records, 128 columns, and 1,000,000 input or output cells. Split: 64 MiB, 1,000,000 records and 500 parts. A field can have up to 262,144 UTF-16 units and a record up to 1,048,576 characters. Output up to 128 MiB; the worker stops after 60 seconds. The ZIP bytes stay in memory, so this is not an unlimited disk stream.