Barcode question answer

How do I generate barcodes from Excel and export images?

For teams that need to turn order IDs, asset IDs, bin locations or internal product codes into printable barcode images.

Direct answer

Put one code per row in Excel, import or paste the column into a batch barcode generator, choose Code 128 for most internal IDs, verify the preview and export PNG, SVG or a ZIP package.

Open batch Code 128 generatorBatch generatorSave a label template

Check these items before importing Excel

Item
Recommended setup
Why it matters
Code column
One code per row in a dedicated column
Prevents names, notes or prices from becoming barcode content
Format
Use Code 128 for order, asset and location IDs
It handles mixed letters and digits reliably
Blank or duplicate rows
Remove blanks and confirm duplicates
Avoids invalid labels and operational confusion
Export type
Use PNG/ZIP for printing, SVG for design tools
Each format fits a different downstream workflow

Recommended workflow

1

Prepare the Excel column

Keep one barcode value per row and avoid mixing descriptions or notes into the barcode column.

2

Import or paste the data

Paste a small column directly or import Excel/CSV when the list is longer.

3

Choose the barcode format

Use Code 128 when unsure. Switch only for specific standards such as EAN-13, ISBN or ITF-14.

4

Check preview and size

Scan a few sample labels before printing the whole batch.

5

Export images

Export PNG or SVG files, or download a ZIP package when sharing a full batch.

Common mistakes

Importing the whole sheet instead of the code column.
Leaving hidden spaces or line breaks in barcode values.
Making the barcode too narrow for the printer resolution.
Using Code 128 for regulated retail product barcodes that require GS1-compliant numbers.

FAQ

Which format should I use for Excel barcode generation?

Use Code 128 for most internal IDs such as orders, assets and warehouse locations. Use EAN-13, UPC or ISBN only when the code follows those standards.

Can I generate barcodes from Chinese text?

For one-dimensional barcodes, Chinese text is usually not recommended. Use QR Code for Chinese text, URLs or long descriptions.

Should I export PNG, SVG or ZIP?

PNG is convenient for printing, SVG is best for design tools and ZIP is useful when downloading many barcode images at once.