BizNavi HubConnexion

CSV tools

CSV Diff

Compare an OLD (before) CSV with a NEW (after) CSV by key. Detect added, removed, and changed rows — in your browser.

OLD / Before

Drop OLD CSV here

Or choose one file. Nothing is uploaded automatically.

No OLD CSV selected yet.

NEW / After

Drop NEW CSV here

Or choose one file. Nothing is uploaded automatically.

No NEW CSV selected yet.

Output encoding

Limits: 2 files, 20 MB each, 30 MB total, 200000 rows/file, 200 columns, 100 compared columns.

What CSV Diff does

CSV Diff compares an OLD (before) and NEW (after) CSV by a unique key column. It classifies rows as added, removed, changed, or unchanged, and lists each changed field. Column names can differ — map OLD.status to NEW.state. Comparison is exact and case-sensitive unless you enable optional trim.

How to compare old and new CSV files

  1. Select the OLD CSV and the NEW CSV.
  2. Choose a key column from each file and confirm column mappings (auto same-name plus optional manual pairs).
  3. Tap Compare to process both files in your browser.
  4. Download added.csv, removed.csv, changed.csv, unchanged.csv, or a ZIP of all four.

Added, removed, changed, and unchanged

added.csv keeps NEW row shape; removed.csv keeps OLD row shape; unchanged.csv uses NEW rows; changed.csv is one row per field change (key, column, before, after). Keys must be unique and non-blank in each file.

Unique keys required

Duplicate key values make row-level diff ambiguous, so comparison stops with a clear error. Use CSV Remove Duplicates first if needed. Blank keys also block processing.

Local browser processing

Both CSV files are compared locally in your browser. Files are not uploaded to BizNavi Hub for diff processing. Leaving or refreshing the page clears in-memory files.

Encoding and BOM

Input supports UTF-8 and UTF-8 with BOM. If UTF-8 decoding fails, some browsers can read Shift_JIS. Output defaults to UTF-8 with BOM for safer Excel interoperability; plain UTF-8 is available.

Limits

We allow two files up to 20 MB each (30 MB combined), 200,000 rows, 200 columns, and up to 100 compared column mappings so browsers stay stable.

Common reconciliation use cases

  • Find customers added or removed between monthly exports.
  • Detect status or amount changes for the same invoice ID.
  • Reconcile two system extracts when column names differ.

Limitations

This tool does not open Excel workbooks (.xlsx), does not fuzzy-match, does not coerce numbers or dates, and requires unique keys. It is not a line-by-line text diff of raw file order.

FAQ

How do I compare old and new CSV files online?
Choose OLD and NEW CSVs, pick key columns, map fields to compare, then download the result files from your browser. No server upload is required.
What if key columns have different names?
Select each file’s key separately — for example OLD.customer_id and NEW.id. Mapped compare columns can also use different names.
Are my files uploaded?
No. Diff runs in your browser. BizNavi Hub does not receive CSV contents for this step.
Why do duplicate keys block comparison?
Row-level diff becomes ambiguous when the same key appears more than once. Deduplicate first, then retry.
Is XLSX supported?
Not in this phase. Use CSV exports for now.

← All CSV tools