anyscan.download
Free forever

Excel to Barcode Generator

Upload an XLSX workbook, choose a worksheet and map columns to generate barcodes or QR codes locally.

Batch

Paste a list or upload a spreadsheet.

Local processing

Number cells lose leading zeros: 00123456 imports as 123456. Format identifier columns as Text in the spreadsheet before importing.

TXT, CSV, TSV or XLSX · or drop one hereCSV, TXT or TSV · or drop one hereXLSX workbook · or drop one here
Generate a sequence

Add a list or spreadsheet to see a safe preview.

Processed locally. Excel workbooks and generated values stay in this browser.

Create codes from an XLSX workbook

The batch importer reads XLSX files in the browser and exposes spreadsheet headers for value, label, quantity, filename and format mapping.

Upload XLSX

Choose or drop a workbook up to 10 MB; parsing happens locally.

Use headers

Map the sheet columns that describe each code and its printable label.

Preserve identifiers

Review parsed values before export, especially identifiers whose leading zeroes matter.

Import a workbook without losing the job structure

  1. Choose an XLSX file, then select the visible worksheet that contains the source rows.
  2. Confirm whether the first row contains headers and map the identifier and optional output fields.
  3. Inspect values with leading zeroes, dates and calculated cells before generating codes.
  4. Resolve row errors, then export files and the accompanying report or continue to Labels.
Spreadsheet values that deserve review
Cell valueHow it is handledPractical check
Text identifierStored text is read as-is, including leading zeroes in the cell value.Prefer Text formatting for SKUs and long numeric IDs; numeric display formatting is not reconstructed.
NumberRead from the workbook value without converting long digits through JavaScript Number.Confirm that the workbook itself has not already rounded the identifier.
DateConverted to an ISO date-time value by the local importer.Use a separate display label if a different printed date form is required.
Blank cellImported as an empty value.A blank mapped Value field is reported as invalid rather than silently encoded.

Worked example: an identifier with leading zeroes

Product	SKU	Quantity	Format
Spare part	00018427	2	CODE128

Store the SKU cell as text before saving the XLSX, or paste this tab-separated range. Map SKU as Value and select Code 128 explicitly: Auto may interpret a numeric identifier as a retail code. The encoded identifier must remain 00018427, not 18427. Formatting a numeric cell to display extra zeroes does not change its stored value, and this importer does not reconstruct spreadsheet display formatting or recalculate formulas.

Specifications

Workbook input
XLSX is supported alongside CSV, TSV, TXT and pasted spreadsheet ranges.
Formats
QR, Code 128, Code 39, EAN-13, EAN-8, UPC-A, ITF or automatic detection.
Exports
SVG or PNG ZIPs, code sheets, reports, and a handoff to PDF or ZPL labels.

Common questions

Does the workbook leave my device?

No. Spreadsheet parsing and rendering run in the browser.

Can each row define its own barcode type?

Yes. Map a supported Format column or select one format for the whole job.

Related tools for tabular input and output. CSV to Barcode · Bulk Barcode Generator · ZPL Barcode Generator