How to Generate Barcodes From Excel or CSV
Export the worksheet as CSV, keep one stable identifier per row, and choose a barcode format that matches the characters your system actually uses.
Clean the identifier column
Remove formulas that display differently from their stored values and preserve leading zeroes by formatting identifiers as text.
Export CSV
Save the relevant worksheet as UTF-8 CSV, then upload it to the bulk barcode generator.
Choose Code 128 or Code 39
Code 128 is the default for compact general identifiers. Choose Code 39 only when an existing scanner workflow requires it.
Print without stretching
Use the generated PDF at 100% scale and scan labels from several positions on the sheet.
Check these before a large batch
- Excel removing leading zeroes
- Using lowercase characters with Code 39
- Making long barcodes too narrow