Add check-digit-correct barcode data to a spreadsheet — USPS IMb and IMpb, GS1 SSCC-18 and GS1-128, or your own template — ready for ImposeIQ VDP or a barcode font.
The Barcode Data Generator reads a spreadsheet, works out the barcode value for every row — check digits and all — and writes it back as new columns. The barcode itself is drawn later, by ImposeIQ VDP or by a barcode font; this tool makes sure the data is right first.
Everything is worked out on your computer — nothing is uploaded.
Open spreadsheet… or drop an Excel (.xlsx, .xls) or .csv file on the window, and pick the sheet. Two samples are there to try every standard: a postal mailing list (names, addresses, ZIP and ZIP+4) for IMb and IMpb, and a warehouse manifest (GTINs, lots, expiry dates and pallets) for GS1-128, SSCC-18 and templates.
| Standard | What it makes |
|---|---|
| USPS IMb | The 31-digit numeric Intelligent Mail barcode |
| USPS IMb FADT | The same, as the 65 letters an IMb barcode font needs |
| USPS IMpb | 22-digit Intelligent Mail package barcode, Mod 10 |
| GS1 SSCC-18 | Pallet and shipping container code |
| GS1-128 | Application Identifiers taken from your columns |
| Custom template | Code 128, Code 39, QR Code or Data Matrix from a pattern |
Most values can come from a fixed value, a column, a sequence (with a starting number), random digits, or none where the field is optional.
In FADT each letter is one bar — Full, Ascender, Descender, Tracker. Print that column with a USPS IMb font, or use the numeric value with the VDP barcode tool.
Add the Application Identifiers in barcode order, each from a column, a fixed value or a sequence: SSCC (00), GTIN (01), contained GTIN (02), batch/lot (10), production, packaging, best-before and expiry dates (11, 13, 15, 17), serial number (21), counts (30, 37), internal codes (90–92), customer PO (400), GLNs (410, 414), ship-to postal code (420) and net weights (3100, 3102, 3202).
GTINs, SSCCs and GLNs get their check digit added when one digit short, and checked when complete. Dates accept 2027-03-31, 3/31/2027 or YYMMDD. The spreadsheet value is either bracketed — (01)00614141000012(17)270331… — or the element string with GS (ASCII 29) separators.
Choose the symbology and type a template: {Column Name} puts in a cell, {SEQ} or {SEQ:6} a running number (zero padded), and {ROW} the row number. Click a column name to insert it. Set where the sequence starts, upper-case the result, or append a Mod 10 check digit to all-digit values.
BARCODE_VALUE unless you change it._HRI, the text printed under the barcode._ERROR with the reason when a row fails.Values are written as text cells, so leading zeros survive Excel. Output columns already in the sheet are replaced, not duplicated. Export CSV or Export Excel (.xlsx) saves the result.
The table shows every row with its barcode value and an OK or Error status, with counts of valid rows and rows with errors at the top. Tick Show only rows with errors to work through the problems, and page through 25 to 250 rows at a time.
Click a row to inspect it: the barcode drawn, its human-readable text, the value with a Copy button, and a breakdown of every part — with the check digit worked out step by step. A row with an error shows why; correct the cell in the spreadsheet or change the parameter. It is exported with an empty barcode, and the message in the _ERROR column if you turned that on.