Skip to content
FeedBenchBY SMARTFACT

FREE CSV AND JSON FILE CHECKS

Compare two CSV files by key

Updated

Comparing two CSV files by key means matching records by the columns that identify them, such as a part number, instead of line by line, so row order makes no difference. FeedBench does this free in your browser, with no account, and reports added, removed, changed and ambiguous keys without guessing a match.

Free to use. No account, email address or trial. Works offline once prepared.

FeedBench comparison counts: 0 added, 1 removed, 1 changed, 1 unchanged and 1 ambiguous key
Two versions compared by key, with a repeated key kept ambiguous.
Compare two CSV files by key · 2:56 · Watch on YouTube

What counts as added, removed or changed?

An added key is in the current file only, a removed key is in the previous file only, and a changed key is in both with a different value somewhere in its record. A key that appears more than once in either file is ambiguous, and keys with an empty value are counted separately, as unmatched. The result gives whole-file counts, then the first 50 keys with their record numbers.

FeedBench comparison set-up with the earlier version chosen and part_number ticked under Key columns
One to four key columns identify each record.

Can I keep the result?

Download the diagnostic PDF, which keeps the counts and leaves your values out unless you choose to add records. Save the work on this device, or download a project backup.

FeedBench report section with the PDF report download and a problem list CSV
A report of the counts, without your values.

What FeedBench does not do

It changes neither file and no other system, and the comparison is not checked against a live database. Both files need the same delimiter and the same headers in the same order. Two JSON files are only checked for being exactly equal, not compared by key, and each file can hold up to 10,000 records.

WHO IT IS FOR

For engineering, planning and data owners comparing two exports of an item list, location list or bill of materials before passing the new one on.

WHY USE IT

Match by key, not by line

When rows are sorted differently, a line-by-line comparison can report almost everything as changed. FeedBench matches records by the key columns you choose, so row order makes no difference. A key that appears more than once is reported as ambiguous instead of being matched to the first row, and a removed key is a result to review, not an instruction to delete anything.

HOW IT WORKS

FeedBench in three steps.

  1. 01

    Load both files

    Choose the current file and check it, then load the previous file on the Compare step. Both files need the same delimiter and the same headers in the same order.

  2. 02

    Choose the key

    Tick one to four key columns, such as part_no, or job_id and unit_id together. Values are compared exactly, so 000017 and 17 are different keys.

  3. 03

    Review the result

    See whole-file counts of added, removed, changed, unchanged and ambiguous keys, and keys with an empty value, then the first 50 keys with their record numbers. The diagnostic PDF keeps the counts.

A CONCRETE EXAMPLE

A repeated key stays ambiguous

Last week's item list has 2,410 records and this week's has 2,412, keyed by part_no. FeedBench reports 2,371 unchanged, 36 changed, 3 added, 2 removed and 1 ambiguous: part_no B-220 appears twice in this week's file, at records 118 and 119. It does not pick either row. You decide which is correct in the source.

USED IN PRODUCTION

When the same file arrives every day.

FeedBench checks one file at a time, by hand. Two SmartFACT services handle the data work that repeats: keeping the lookup tables your applications need, and turning order exports into checked kits. Both are in early access, with scope agreed at onboarding.

Free tier

SmartFACT Data

If the same customer or supplier values keep changing, ConfigSheets gives your team a maintained reference table, checked edits and saved versions. It prepares reviewed files for LabelRules and KitProof; agree the receiving workflow during onboarding.

Free tier

KitProof

When an order export decides what goes into each kit, KitProof starts from a CSV export of your orders, builds each kit's checklist from approved plain English component rules and checks every scan against the expected parts and quantities.

BEFORE YOU START

Common questions.

Can I compare files with different columns?

No. Both files need the same headers in the same order and the same delimiter, or the comparison stops with a clear rule. If a column was added or renamed, align the headers in the source system first, or map one file to the other's layout and compare the downloaded preview.

Can it compare JSON files?

It tells you whether two JSON files are exactly equal, comparing object properties and array positions, with numbers kept as written. It does not match JSON records by key or list individual differences.

Does a removed key mean something was deleted?

Not necessarily. It means the key is in the previous file and not in the current one. FeedBench does not change either file or any system, and the comparison is not checked against a live database. What to do about it is a decision for the system that owns the data.

What are the current limits?

FeedBench checks and previews files. It does not import, repair or synchronise anything, and it never silently trims, pads, converts or approximately matches values. It reads UTF-8 CSV with a confirmed comma, semicolon or tab delimiter and a header row, and strict JSON, up to 5 MiB per file and 15 MiB per project. CSV checks cover up to 10,000 records and 64 columns, a reference file up to 5,000 records, and a check stops after ten seconds. Mapping uses source columns, exact constants and exact lookups only, with no formulas, unit conversion, splitting or merging. JSON is inspected and compared for exact equality, not mapped. The file-checking/mapping flow does not read XLSX, XML, EDI, other text encodings or CSV without a header row. Candidate checks for SmartFACT layouts never confirm a live import. Structured-data tools accept up to 1 MiB of UTF-8 input, 32 nesting levels and 50,000 JSON values/members or XML nodes, with output up to 5 MiB. Schema checks use a closed JSON Schema 2020-12 subset: type (excluding integer), properties, required, additionalProperties, items, string/item lengths, boolean schemas and string/boolean/null enum. References, patterns, formats, composition and numeric constraints are refused. XML support is formatting only, with no DTD, external entity, XSD or import support; indentation can change whitespace text nodes. Mixed text and xml:space-preserved subtrees remain unchanged. New structured inputs are temporary and are not included in saved file-checking projects or backups.

What happens to my data?

Your files stay in this browser. A temporary project keeps them in memory while the tab is open; Save on this device keeps the project, source files included, until you delete it. Nothing is uploaded, and there is no account or email step. Default reports leave out your values, file names and hashes. Google Analytics is optional and loads only after you accept; it never receives file contents, file names, values or results. Use Analytics settings to change your choice; see /privacy/.

FREE TO USE

Put FeedBench to work.

Open the free tool and start with one known example.

Check a file free →

THE SMARTFACT SUITE

SmartFACT services
and free tools.

Automate factory decisions with rules you describe in plain English. Explore focused SmartFACT services, plus free tools for everyday checks. The free tools need no account.

Free tierSuggested next step

SmartFACT Data

Maintain reference tables with ConfigSheets or bring shop orders into SmartFACT through reviewed connectors. Check changes and deliver data to the products that use it.

Explore SmartFACT Data ↗
Free tier

LabelRules

Describe label rules in plain English. Automatically select layouts, resolve customer codes and check each job before printing.

Explore LabelRules ↗
Free tier

KitProof

Turn plain English component rules into automatic kit checklists, then check scans against the expected parts and quantities.

Explore KitProof ↗
Free tier

WorkSteps

Turn plain English rules into automatic step selection for each unit, with required evidence and a record of completed work.

Explore WorkSteps ↗
Free tier

FactorySpec

Apply approved product rules and calculations automatically to turn dimensions and options into manufacturing requirements.

Register early-access interest ↗
Early access

ParcelOffice

Scan the work order and the parcel choice to book the courier and print the labels. Approved plain English rules recommend or choose the parcel.

Explore ParcelOffice ↗
Free tier

RefillFlow

Scan an empty container to send the right refill request to stores. Approved plain English rules set the stores queue, priority, ticket printer and escalation.

Explore RefillFlow ↗
Free tier

RemnantRack

Label each offcut, find a suitable length before cutting new stock and record what you used. Approved plain English rules decide what to keep and where it goes.

Explore RemnantRack ↗
Free tier

ToolCustody

Check a shared tool before handover, record who has it and keep damaged or overdue tools out of the next issue. Start free with one crib.

Explore ToolCustody ↗
Free tier

StoresFlow

Receive, put away, reserve and issue stores material with barcode checks, keeping held, reserved and available stock apart. Start free with one stockroom.

Explore StoresFlow ↗
Free tier

LotTrail

Follow a lot or serial number through the records your factory already keeps, with the source of each link and the gaps shown. Start free with two declared sources.

Explore LotTrail ↗
Early access

CheckStation

Scan an identified unit to get its approved final-inspection checks, then record exact readings with their result, holds and release history.

Register early-access interest ↗
Free tier

ReclaimStation

Book returned units in, recover and label the usable parts, release them independently and record the unit each goes into. Start free with one product family.

Explore ReclaimStation ↗
Free tier

SmartFACT Purchasing

Collect purchase requests, approve supplier orders and track what is still to arrive. Start free at one site.

Explore Purchasing ↗
Free tier

SmartFACT Automation

Describe, test, approve and audit the automation rules of every SmartFACT product in one place. Included with each product’s paid plan, or on its own.

Explore Automation ↗
Free tool

ScannerBench

See the text and key events your keyboard scanner sends. Compare them with the value you expected.

Test a scanner ↗
Free tool

PrintBench

Print a known PDF, measure its reference marks and compare scans from the printed codes.

Check a print ↗
Free tool

CardBench

Create 100 × 50 mm bin and rack cards with Code 128 or QR, from one record or a CSV.

Make bin cards ↗
Free tool

CountBench

Count stock by location with a barcode scanner, compare it with a stock file and export the results.

Start a free count ↗
Free tool

BarcodeBench

See exactly what a scanned barcode contains, with hidden characters shown and GS1 fields, check digits and dates explained.

Inspect a barcode ↗
Free tool

MatchBench

Scan a reference and each label, see an exact match or the first difference, and download the results.

Start a free comparison ↗
Free tool

TagBench

Scan an item or location, note what needs attention, print a review tag and keep a review list.

Make a free tag ↗
Free tool

FindBench

Load your own parts and locations CSV, scan a code and see every location it lists.

Start a free lookup ↗
Free tool

ManifestBench

Check cartons, pallets or serial numbers against a list with a phone or scanner and see what is missing.

Start a free check ↗
Free tool

FeedBench

Check CSV and JSON files exactly as written, preview a column mapping and compare two versions by key.

You are here
Free tool

CycleBench

Time work cycles and changeovers on a phone, record interruptions with reasons and download the results.

Start a free study ↗
Free tool

OffcutBench

Label the offcuts on your rack, find a piece long enough before cutting new stock and record what you used.

Track offcuts free ↗
Free tool

TraceBench

Load one or two CSV exports and follow a lot or serial forwards or backwards, with the row behind every link.

Start a free trace ↗
Free tool

ReclaimBench

Record the parts recovered from each return, label them with a QR code, check them and record the unit each one goes into.

Track recovered parts free ↗
Free tool

GuidBench

Generate GUIDs, UUID v4 and v7, ULIDs and Nano IDs, format and download batches, or inspect a UUID in your browser.

Generate identifiers ↗
Free tool

OctetBench

Inspect and edit text, hex, Base64 and binary bytes in your browser, reveal hidden characters and compare byte sequences.

Inspect some bytes ↗
Free tool

PatternBench

Test JavaScript regular expressions in your browser, inspect matches and captures, preview replacements and check expected cases.

Test a pattern ↗
Help

SmartFACT Help

Step-by-step guides and interactive demonstrations for the SmartFACT suite. Read the instructions, watch a task or practise with real product screens and sample data.

Open SmartFACT Help ↗