Skip to content
FindBenchBY SMARTFACT

FREE BARCODE LOCATION LOOKUP

Barcode lookup from Excel: scan a code, see every match

Updated

To look up a scanned barcode in an Excel list, save the sheet as CSV and load it into a lookup tool: scan a code and see every row that matches, not just the first one a lookup formula returns. FindBench does this free in the browser on any phone, tablet or PC, with no upload or account.

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

FindBench showing 4 exact matching rows for the code 000017, with a warning that the file gives it different descriptions
Every matching row for one scanned code, on a phone, handheld or scan station.
Barcode lookup from Excel: scan a code, see every match · 2:59 · Watch on YouTube

How does a barcode lookup in Excel work?

A USB or Bluetooth barcode scanner types into Excel like a keyboard: the code goes into the selected cell, usually followed by Enter or Tab. A VLOOKUP or XLOOKUP formula beside that cell then finds the code in your list and returns a value from the same row, such as its location. That works for one match, but the formula returns only the first matching row, and a code stored as a number loses its leading zeroes.

Why every match, not the first?

A part can be kept in more than one place, such as a main bin and an overflow, and a list often repeats a row or gives one code two descriptions. FindBench lists every row that matches the scanned code exactly, each with its location, description, note and row number in your file, and flags identical repeats and conflicting descriptions.

FindBench list of the rows matching 000017, each with its location, description and source row
Each matching row, with its location and row number.

How do I prepare the list?

In Excel, format the code column as text so that leading zeroes survive, then save the sheet as CSV UTF-8 with one header row. In FindBench, choose the file, check the first five rows as they were read, and choose the code column, then the description, location and note columns if your file has them. Give the reference a title and the date it was exported, then load it.

FindBench column choices before loading: Part as the code, Text as the description and Bin as the location
Mapping the columns once, in the preview.

What about leading zeroes?

Codes are matched as exact text, so 000017 and 17 are different codes, and a code with a space at the end does not match one without. If nothing matches, FindBench says Not found in this reference: the code is not in your file, which says nothing about stock.

FindBench result for the code 17: an M8 washer at RACK-C, source row 6
17 is not 000017: a different part.

Can I keep it for the next shift?

Yes. Save on this device keeps the reference in this browser between visits, or download a backup and import it on another phone, tablet or PC. The backup holds the mapped columns and row numbers, not the original file. To update the reference, export a fresh CSV and load it.

FindBench save options, confirming Saved on this device
A reference saved on this device for the next shift.

What FindBench does not do

FindBench shows what your file lists. It does not read .xlsx workbooks, connect to a live sheet, Google Sheets or your ERP, or run macros, and it never refreshes the file. It shows the current lookup only, with no timed log of every scan. It is not a stock system: there are no quantities, stock levels or movements, and a listed location is not proof that a part is there.

WHO IT IS FOR

For stores supervisors, inventory administrators and small manufacturers who keep a parts and locations list in a stock system or spreadsheet and want people on the floor to use it.

WHY USE IT

How FindBench reads your file

FindBench reads your file exactly as text. It keeps leading zeroes, case and spaces, refuses malformed rows and duplicate headers instead of guessing, and shows the first five rows and any unmapped columns before you load. The title and declared source date you enter appear with every result and in every PDF, so people can see which version of the list they are using.

HOW IT WORKS

FindBench in three steps.

  1. 01

    Export a UTF-8 CSV

    Save the sheet or stock system export as CSV UTF-8 with one header row. Comma, semicolon and tab separators are supported. Save XLSX workbooks as CSV first.

  2. 02

    Map and review

    Choose the code column, then description, location and note if your file has them. FindBench suggests common column names for you to confirm. Add a title and the date the data was exported.

  3. 03

    Keep it for the next shift

    Save on this device for repeat use, or download a backup and import it on another phone or PC. The backup holds the mapped columns and row numbers, not the original file.

A CONCRETE EXAMPLE

An export mapped once and used on the floor

An administrator exports 2,480 rows with 12 columns from the stock system as a semicolon-separated CSV, maps item_code, description, bin and notes, titles the reference Main stores parts list and declares the export date as 6 October 2026. The preview lists the 8 columns left out. A backup file moves the same reference to the stores tablet, where every lookup shows that title and date.

USED IN PRODUCTION

Keeping locations stocked and reference tables maintained.

FindBench answers one question from a file you load. Two SmartFACT services handle work that repeats every day: keeping line-side locations refilled from stores, and maintaining checked reference tables for supported label and kit workflows. Both are in early access, with scope agreed at onboarding.

Free tier

RefillFlow

FindBench looks up where a part is kept. Keeping that place stocked is RefillFlow's job: scan an empty container's card at the line and RefillFlow sends one refill request to stores, prints the ticket there and tracks the pick and delivery. Approved plain English rules set the stores queue, priority and escalation.

Free tier

SmartFACT Data

If your team needs a maintained reference table with checked changes and saved versions, explore ConfigSheets. It prepares reviewed files for LabelRules and KitProof. It does not refresh FindBench automatically; FindBench reads only the CSV you load.

BEFORE YOU START

Common questions.

What format does the file need?

UTF-8 CSV with one header row and comma, semicolon or tab separators, up to 5 MiB, 10,000 rows and 40 columns. Headers must be unique and not blank, and every row needs a code. Locations can be up to 120 characters, and descriptions and notes up to 500.

Does FindBench change or keep my file?

No. The file is read in the browser and is never changed or uploaded. A saved project or backup keeps only the columns you mapped and each row's original row number. To update the reference, export a fresh CSV and load it: it replaces the old reference and clears the previous lookup.

Can it read Excel files or a live sheet?

No. Save the sheet as CSV first. FindBench does not connect to Google Sheets, your ERP or any web address, and it never refreshes a file. ConfigSheets is a separate option for maintained reference tables and agreed label or kit file workflows, not a live connection to FindBench.

Does Excel support a barcode scanner?

Yes. Most USB and Bluetooth barcode scanners type into Excel like a keyboard: the code goes into the selected cell, followed by Enter or Tab if the scanner sends one. Format the column as text first so that leading zeroes survive.

Is there a free barcode scanner app that works with Excel?

FindBench is free and works with a list saved from Excel as CSV: scan with the camera of a phone or tablet, or with a keyboard scanner, and see every matching row. It runs in the browser, so there is nothing to install, and it does not write scans back into the workbook.

Does Excel have a barcode function?

Excel has no built-in function that draws barcodes; they are usually made with a barcode font or an add-in. To make bin and rack labels with a Code 128 or QR barcode from a list, use CardBench, the free SmartFACT bin card maker.

What are the current limits?

FindBench shows what your file lists. It is not a stock system: there are no quantities, availability, reservations, movements or put-away, and a listed location is not proof that a part is there. Matching is exact text, so 000017 and 17 are different codes, and there is no partial, wildcard or case-insensitive search. One reference is open at a time, and FindBench never refreshes it or connects to your ERP, a spreadsheet service or a web address. Imports are UTF-8 CSV with one header row, up to 5 MiB, 10,000 rows and 40 columns, with locations up to 120 characters and descriptions and notes up to 500. XLSX files are not read, so save the sheet as CSV first.

What happens to my data?

Your reference stays in this browser. Work is temporary by default, and Save on this device keeps it between visits. The CSV, your scans and your downloads are never uploaded, and camera images are decoded on the device. No account or contact details are needed. Google Analytics is optional and loads only after you accept; it never receives codes, locations, descriptions or file contents. Use Analytics settings on these pages or in the tool to change your choice; see /privacy/.

FREE TO USE

Put FindBench to work.

Open the free tool and start with one known example.

Start a free lookup →

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

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

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 ↗
Free tier

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 ↗
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

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.

You are here
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.

Check a file free ↗
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 ↗