How to Generate Barcodes From Excel or CSV

Protect identifiers from spreadsheet conversion

Leading zeroes are data in identifiers, even though they are insignificant in arithmetic. Excel can also display long values in scientific notation or replace digits beyond its numeric precision. Import identifier columns as Text and inspect the saved CSV directly.

A custom cell display format is not enough if the stored value already lost digits. The exported text must contain the exact value the barcode should encode.

sku,barcode_value
Widget blue,00018427
Widget green,00018428

Choose the format for the receiving system

Code 128 supports a broad character set and is a practical default for internal asset, inventory, and location identifiers. Code 39 is less dense and has a more limited character set; use it when a legacy scanner or specification requires it.

EAN-13, EAN-8, UPC-A, and ITF-14 represent structured retail or logistics identifiers. This site validates length and check digit, but it does not issue company prefixes or GTINs.

Preserve clear space and physical dimensions

Barcode quiet zones are unobstructed light areas at the sides of a linear symbol. Their required dimensions vary by symbology and application; do not assume one universal millimetre value.

GS1 directs users to its symbol specification tables for allowed sizes in a given application. For regulated retail or logistics use, validate the finished symbol against the applicable GS1 specification rather than relying only on an on-screen preview.

Test the batch as a production artifact

Generate a small batch containing the shortest, longest, and most unusual identifiers. Print at Actual size, then scan first, middle, and last labels with the real scanner. Check the decoded value against the source CSV, not just the human-readable text.