Batch printing from spreadsheets
Design one label with placeholders, import your data, and export every row as print-ready output — free and unlimited.
1. Design with placeholders
Section titled “1. Design with placeholders”Put {{Column Name}} anywhere text or a barcode value goes — the Field
tool in the toolbar lists your imported columns so you don’t have to type
them. A barcode whose value is {{SKU}} renders a different, validated code
for every row.
2. Import your data
Section titled “2. Import your data”Import data in the top bar accepts four sources:
- File upload —
.xlsx,.xls,.ods,.csv,.tsv. Numbers stay digit-exact (no1.23E+11UPC corruption) and dates keep their format. - Google Sheets — share the sheet as Anyone with the link, paste the
URL. A
#gid=in the URL targets a specific tab. - Paste — straight from Excel or any table.
- Manual grid — type rows in place.
Columns auto-match your placeholders; warnings flag anything unmatched or empty. Blank cells collapse — no gap lines from a missing address line 2.
3. Sequences, repeats, ranges
Section titled “3. Sequences, repeats, ranges”{{#}}inserts a sequential number with a start value, zero padding, and prefix —INV-0001,INV-0002, …- Print each ×N prints multiples per row (two per cable end, three per moving box).
- Row ranges like
1-50, 60reprint parts of a run without regenerating everything.
Imports hold up to 5,000 rows.
4. Preview and export
Section titled “4. Preview and export”Preview renders real labels from your first rows — check a barcode scans before committing. Generate produces one PDF with a label per row (or imposed N-up on Avery sheets, with a start-position offset for partially used sheets).
Invalid rows — say, a bad EAN check digit — are flagged and their barcode is left off the label rather than printing stale data.