FeedBenchBY SMARTFACTFREE CSV AND JSON FILE CHECKS
Compare this week's CSV export with last week's by the key columns you choose. FeedBench reports added, removed, changed and ambiguous keys without guessing a match. Free, in your browser.
Free to use. No account, email address or trial. Works offline once prepared.
Record 214 · part_no
000017
Record 215 · description
Washer M8␣
Fictional values from an illustrative item list. FeedBench never trims, pads or changes the original file.
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.
A USEFUL STARTING POINT
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.
FROM QUESTION TO EVIDENCE
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.
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.
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.
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
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.
Early accessIf every file needs the same code lookup, ConfigSheets lets your team keep that table in Google Sheets and makes it available as structured data your applications can query, from customer and supplier code mappings to tables and grids.
Early accessWhen 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
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.
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.
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.
FeedBench checks and previews files. It does not import, repair or synchronise anything, and it never 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. XLSX, XML, EDI, other text encodings and CSV without a header row are not read. Candidate checks for SmartFACT layouts never confirm a live import.
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/.
ONE SMALL JOB, DONE WELL
Open the free tool and start with one known example.
THE SMARTFACT SUITE
Automate factory decisions with rules you describe in plain English. Explore focused SmartFACT services, plus free tools for everyday checks.
Early accessSuggested next stepMaintain configuration in Google Sheets and make it available as structured data your applications can query.
Register early-access interest ↗
Early accessDescribe label rules in plain English. Automatically select layouts, resolve customer codes and check each job before printing.
Explore LabelRules ↗Early accessTurn plain English component rules into automatic kit checklists, then check scans against the expected parts and quantities.
Explore KitProof ↗
Early accessTurn plain English rules into automatic step selection for each unit, with required evidence and a record of completed work.
Explore WorkSteps ↗
Early accessApply approved product rules and calculations automatically to turn dimensions and options into manufacturing requirements.
Register early-access interest ↗
Early accessTurn plain English rules into automatic order checks and destination selection, with controlled production release.
Register early-access interest ↗
Early accessScan 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 ↗
Early accessScan 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 ↗
Early accessLabel 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 toolSee the text and key events your keyboard scanner sends. Compare them with the value you expected.
Test a scanner ↗
Free toolPrint a known PDF, measure its reference marks and compare scans from the printed codes.
Check a print ↗
Free toolCreate 100 × 50 mm bin and rack cards with Code 128 or QR, from one record or a CSV.
Make bin cards ↗
Free toolCount stock by location with a barcode scanner, compare it with a stock file and export the results. No account needed.
Start a free count ↗
Free toolSee exactly what a scanned barcode contains, with hidden characters shown and GS1 fields, check digits and dates explained. No account needed.
Inspect a barcode ↗
Free toolScan a reference and each label, see an exact match or the first difference, and download the results. No account needed.
Start a free comparison ↗
Free toolScan an item or location, note what needs attention, print a review tag and keep a review list. No account needed.
Make a free tag ↗
Free toolLoad your own parts and locations CSV, scan a code and see every location it lists. No account needed.
Start a free lookup ↗
Free toolCheck cartons, pallets or serial numbers against a list with a phone or scanner and see what is missing. No account needed.
Start a free check ↗Free toolCheck CSV and JSON files exactly as written, preview a column mapping and compare two versions by key. No account needed.
You are here
Free toolTime work cycles and changeovers on a phone, record interruptions with reasons and download the results. No account needed.
Start a free study ↗
HelpStep-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 ↗