BatchLabel Bench
← Barcode generator

Barcode CSV Template

Start with a small CSV that contains the barcode value, the label name and the number of copies.

Template columns

code,label,quantity
"00125","Small bin, white",2
"PL-025","Returns shelf",1
"PL-036","Assembly tray",3

Export from a spreadsheet

Save a copy of the relevant sheet as UTF-8 CSV. If a label contains a comma, put double quotation marks around the whole field. Double any literal quotation marks inside a quoted field. The generator also accepts UTF-8 tab-separated files.

For a plain text list, choose One code per line under Input format before pasting or opening a TXT file. Each line becomes one label, and punctuation such as commas or semicolons stays in the code. For files with separate columns, choose CSV / TSV. Opening a CSV or TSV file switches to that mode automatically.

Keep leading zeros in barcodes

For a new spreadsheet, set the code column to Text before entering or pasting values. Treat the barcode as an identifier, even when it contains only digits. A display format can make a number look padded in the spreadsheet without reliably protecting the underlying value.

To reopen an existing CSV in a version of Excel with Power Query, start from Data, choose From Text/CSV, then Transform Data. Select the code column and set its data type to Text before loading the sheet. If the import already inferred a numeric type, change the type at that step while the original text is still available. Microsoft's guide to keeping leading zeros shows the workflow.

Open the exported CSV in a plain-text editor and find one known code, such as 00125. If the file contains 125 or scientific notation, restore the exact code from your original list, set the column to text, and export again. Then generate a small batch and compare the value below the bars to the same line of the CSV.

Test the file

Start with two or three rows. Generate the preview and compare the visible codes against your source. If the tool rejects a row, open the CSV in a text editor and inspect the row number shown in the results.

Ready to print? Follow the sheet alignment guide before using label stock.