Skip to content
FeedBenchBY SMARTFACT

FREE CSV AND JSON FILE CHECKS

Map CSV columns to an import layout

Updated

CSV column mapping turns one system's export into the column layout another system imports, by declaring where each new column's values come from. FeedBench previews the new file free in your browser, with nothing uploaded: each new column comes from a column of your file, an exact fixed value or an exact lookup in a reference CSV.

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

FeedBench mapped CSV preview for CardBench bin and rack cards, with the local checks that passed and those not checked
The new file, previewed with what was and was not checked.
Map CSV columns to an import layout · 2:38 · Watch on YouTube

Where can each column come from?

Each target column has one declared source: a column from your file, an exact text constant or a lookup that matches one to four key columns exactly against a reference CSV. A source column feeds one target only, and every column you leave out must be acknowledged, so nothing is dropped by accident.

FeedBench new layout table, with location_id filled from the bin column of your file
Every new column, with its declared source.

Can I reuse the mapping for the next file?

Yes. Download the mapping as a recipe and import it for the next file, which is still checked from the start. You can also download the CSV preview, a PDF report or a project backup, or save the work on this device.

What FeedBench does not do

It previews files and never imports them: the receiving application still checks access, its own settings and its existing records. Mapping uses source columns, exact fixed values and exact lookups only, with no formulas, unit conversion, splitting or merging, and the mapping flow does not read XLSX, XML or EDI files.

WHO IT IS FOR

For integrators, IT generalists and technically minded supervisors who turn one system's export into another system's import layout, often with a code lookup in between.

WHY USE IT

Declare where each column comes from

Automatic column matching is quick, but a wrongly matched column or code is hard to spot afterwards. In FeedBench every target column has one declared source: a column from your file, an exact text constant or an exact lookup in a reference CSV. A source column feeds one target only, every column you leave out must be acknowledged, and the result is a new comma-separated file. The original bytes are never changed.

HOW IT WORKS

FeedBench in three steps.

  1. 01

    Check the source

    Check the source file first so FeedBench knows its headers. Then add each target column the receiving layout needs, in the order it expects.

  2. 02

    Declare each column

    For each target choose a source column, an exact text constant or a lookup that matches one to four key columns exactly against a reference CSV. A missing or repeated reference key stops the preview instead of picking a match.

  3. 03

    Preview and reuse

    Acknowledge the columns you leave out, choose Check now and review the derived preview. Download the CSV preview, and download the mapping as a recipe to import for the next file.

A CONCRETE EXAMPLE

A missing reference value stops the preview

An order export has a column cust with codes such as ACME-01, and the receiving layout needs customer_code with internal codes. A reference CSV maps ACME-01 to C0042. When record 37 holds ACME-02, which the reference does not contain, the preview stops at record 37 and reports a missing reference value. FeedBench never picks the nearest spelling.

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 change a single value?

Yes, as an explicit change in the derived file. Choose the record and field and type the replacement. Each change records the value it replaces and is tied to that exact source file, so it cannot be applied to a different file by mistake. A project holds up to 1,000 changes.

Does it check files for SmartFACT products?

The destination list includes candidate local checks for CardBench bin and rack cards, WorkSteps units and KitProof source maps. They are previews, not an approval: the receiving application checks access, its current settings, existing records and the import itself. WorkSteps and KitProof checks also need a declared context file that you load.

Can it convert units or split columns?

No. FeedBench maps source columns, exact constants and exact lookups only. It does not calculate, convert units, split or merge columns, run formulas or match codes approximately. Make those changes in the source system, or as explicit changes to individual values.

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 ↗