Make barcodes from a spreadsheet
The codes are already in a column. Point at it and get the labels.
Stock lists live in spreadsheets, which is why the usual request is not for a barcode but for four hundred of them, one per row, with the item name underneath. Export the sheet as CSV, import it here, choose which column holds the code and which holds the caption, and every row becomes a label. Nothing is retyped and nothing is uploaded.
How to make barcodes from a spreadsheet
- 1
Export the sheet as CSV
In Excel or Sheets, save a copy as CSV. Only the columns you point at are used.
- 2
Import and pick the columns
Choose the column holding the code, and optionally a second column for the caption printed under the bars.
- 3
Generate everything at once
Pick the barcode type and sheet, then download one PDF with every label on it, or a zip of individual images.
Why a list beats one at a time
Generating barcodes one page load at a time is fine for a sample and hopeless for an inventory. A CSV import turns the whole job into one step, with every bad value reported before anything is printed.
Onto label sheets
Once the codes are in, pick an Avery sheet and the whole list is laid out ready to print.
Frequently asked questions
What if some rows are wrong?+
Every bad row is listed with its line number and the reason, and left out. You can fix the sheet and import again, rather than discovering the problem at the printer.
Are Excel files supported directly?+
Export as CSV first. It is one menu item, and it avoids the surprises that come with reading a workbook that has formulas, merged cells and three sheets in it.
What about leading zeros?+
Spreadsheets like to eat them. Format the column as text before exporting, or check the imported values in the preview here before you print.
Does my stock list leave my computer?+
No. The CSV is read in your browser and never uploaded, which matters when the file is your entire product catalogue.