Print labels from a CSV file

Print labels from a CSV file. Upload the file, map columns to text or barcodes, and print one label per row on a thermal roll or a sheet. The file stays in this browser. Check the longest row before the whole job. No signup. A header row with column names makes the fields easy to place.

Sizes

CSV onto 5160

2.63 x 1 in. A shop export of customers. Keep the header. Quoted commas inside a street field are fine. A broken quote is not.

Shopify-style product CSV

3 x 2 in. Title, variant, and barcode columns. You do not need the other forty columns Shopify includes. Delete them.

Order CSV to 4x6

4 x 6 in. Name and address columns from an order export. One order, one row, one parcel label.

SKU CSV to 2x1

2 x 1 in. The barcode column only, plus a short title if you want it. UTF-8, not an old ANSI export, if names have accents.

Guest CSV to badges

3.5 x 2.25 in. first_name and company. Rename the headers in the file if they are cryptic. Mapping is easier when you can read them.

Address CSV to DYMO

1.125 x 3.5 in. The same address file, different die. Switch the card. Do not change the CSV.

Print labels from a CSV file

CSV is the export almost every shop, spreadsheet, and list can make. Row one is the header. Every following row is a label. Save as UTF-8. If you open the CSV in Excel just to look, and Excel rewrites ZIP codes, save a fresh CSV from the original source instead of saving Excel's version.

Fields that contain commas must be quoted. A street of "123 Main, Apt 4" is one field only when the quotes are intact. If the preview shows the apartment number in the city slot, the quote broke. Fix the file. Do not "map around" a broken row, because the next row is shifted too.

Export CSV with a header row.
Open the card for the printer you loaded.
Import the file. Check the encoding if accented names look like question marks.
Map headers. Preview row 1 and the last row.
Print one label, then the file.

If you still have the xlsx, use print labels from Excel and skip the export. Shop order files are also covered on Shopify, Etsy and eBay shipping labels. A Google Sheet download is the same idea on Google Sheets labels.

Questions

How do I print labels from CSV?

A header row, one record per line, import, map, proof, print. UTF-8 keeps names intact.

What if a column slides into the next field?

A comma inside a value was not quoted. Fix that row in the file and import again.