Serial numbers with Scanlist
This page opens in New row each scan mode with a Condition column suggested and Excel (XLSX) as the first export, for recording the serial number of every unit in a batch of laptops, phones, meters or returned devices. Each scan becomes its own row, so two units of the same model still get two lines, and the serial is written to Excel as text, exactly as printed on the label.
- Name the list after the batch, for example the purchase order or the shipment, and set the list's default Condition (Pro) to New or As received.
- Tap Start scanning and read the serial number label on each unit: Code 128 and Code 39 on most labels, Data Matrix on small devices, QR on newer packaging.
- Check the row that appears. A label with several barcodes (model, serial, IMEI) adds a row for whichever code the camera read first, so cover the others with a finger or move in closer to the serial.
- Change the Condition on a unit that arrives damaged and add a note, for example Screen cracked, then carry on with the next unit.
- Export to Excel. The Code column is text, so a serial that is all digits, or that starts with zeros, opens exactly as printed and can be matched against the supplier's list.
What to know
Serial numbers are unique, so there is nothing to add up: what you want is one row per unit with the time it was recorded, which is what New row each scan gives you. A unit scanned twice by mistake shows as two rows with the same code and different times, easy to spot when the list is sorted by code. Pro can switch on a duplicate warning instead, which beeps differently and does not add the row, for batches where a repeat scan is more likely than a genuine pair.
Many serial labels follow the GS1-128 layout, a Code 128 barcode that holds the product code and the serial in one string with application identifiers in front, such as 01 for the product and 21 for the serial. The scanner keeps the whole string as read, so split it in the spreadsheet with MID or TEXTSPLIT once it is in Excel. Data Matrix codes on small electronics can be only a few millimetres wide: fill the frame, keep the phone still until the lens focuses, and use Scan from a photo for a label in a tight corner. Code 39 serials are read as the printed characters without the start and stop marks.
Excel keeps 15 significant digits, so a 15-digit IMEI typed into a number cell survives but a 16-digit serial is rounded and a serial with zeros at the start loses them; the XLSX export avoids both by writing every code as a text cell. Each row also has a Scanned at time, which Pro writes as a real date-time cell so you can filter by day. Free allows three exports a day of 25 rows each; a batch bigger than that needs Pro, which also keeps a named list per shipment.
Updated · Cosmovex
Questions
Will Excel change a serial number that is all digits?
Not from the XLSX export: every code is a text cell, so zeros at the start stay and long serials are not rounded. If you export a CSV instead, open it in Excel with Data > From Text/CSV and set the Code column to Text, because double-clicking a CSV converts long numbers.
The label has three barcodes. How do I scan only the serial?
The camera reads the first code it can decode, so cover the model and IMEI codes with a finger or bring the phone close enough that only the serial barcode is in the frame. If a wrong code gets in, delete its row and scan again.
Can it read the small Data Matrix on devices?
Yes. Data Matrix, QR, Code 128, Code 39, ITF, EAN, UPC and PDF417 are all read. For very small codes fill the frame, wait for focus, and avoid glare on glossy labels; Scan from a photo also works when the camera will not settle.
What happens if I scan the same unit twice?
In New row each scan mode it is added again with its own time, so you can see it when the list is sorted by code. Pro can warn when a code is already in the list and not add it.
Does it look up the model or product name?
No. There is no product database behind it. The row holds the code, its type, the time and your note, plus the Condition column; add the model in the note or join the export to your own product sheet.
Are the serial numbers sent anywhere?
No. They stay on the device until you export the file. Only an export count with a random browser ID is sent, to apply the free limit.
The free plan covers everything on this page. Scanlist Pro ($5/mo, billed monthly) is described on the Scanlist page.
More ways to use Scanlist
- Scanlist, no preset
- Scan to Excel
- Excel on iPhone
- Scan to Google Sheets
- Retail stocktake
- Inventory count
- ISBN batch
- Goods-in receiving
- QR codes to CSV
- Asset audit
- Equipment sign-out
- Event check-in
- Pharmacy stock count
- Parcel dispatch log
- Returns receiving log
- Spare parts bin count
- Lab sample tube log
- Bar stocktake
- Badge attendance
- Order packing check
- Pallet label scanner
- USB scanner to CSV