Stella
Printing and labels

Print barcode labels from Excel with name and price

36 products as shelf labels with name, price and a barcode that scans, zeros kept.

Download StellaFree with the plan you already have.

A real run on 14 November 2026, on a Linux computer, using Claude Code with Opus, on a Claude plan. The waiting is sped up; it took 2 min 05 s in real time.

The short answer.

Word for Windows can draw barcodes in a label mail merge with its MERGEBARCODE field; Word for Mac can't, so Mac users need a barcode font or a label program. Either way, set the UPC column to text first: Excel drops the leading zero, and a barcode of the shorter number scans as a different product. Stella (stella.sh) reads the stock sheet on your computer, restores the zeros, and writes a label PDF with each barcode test-scanned.

Stella does this on Windows, Mac and Linux.

What happened.

36 labels on two sheets in about two minutes. Checked afterwards against an answer key written before the run: US Letter pages, every product's barcode scanning as its 12-digit UPC with the leading zero inside its 5160 label, name and price on the same label, one label per product, nothing outside the labels, and the spreadsheet unchanged.

The shop and products are made up for this run, with valid UPC check digits. The barcodes were scanned from the PDF by software, not with a handheld scanner. The work is sped up 6×.

How Stella does it.

  1. Finds Pantry & Larder stock list.xlsx in Documents: 36 products with SKU, name, UPC and price
  2. Notices 22 UPCs that had lost their leading zero because Excel stored them as numbers, and puts the zeros back before making barcodes
  3. Lays out one label per product on Avery 5160 sheets: product name, price, and a UPC barcode
  4. Scans every barcode in the finished file to confirm it reads as the right code
  5. Saves Pantry & Larder shelf labels (Avery 5160).pdf next to the stock list: one full sheet of 30 and six labels on a second

The prompt.

Make shelf labels for every product in my stock spreadsheet in Documents, with the product name, the price and a barcode that scans, laid out for Avery 5160 label sheets.

Paste it into Stella and press Enter.

This is the exact prompt from the recording. If your files are somewhere else, say where.

Do it yourself.

  1. Turn the UPCs into text

    In Excel, add a column with =TEXT(C2,"000000000000") (twelve zeros for UPC-A), fill it down, then copy and Paste Values over the UPC column. A UPC like 003292694568 must stay twelve digits.

  2. Windows: merge with a barcode field

    In Word: Mailings, Start Mail Merge, Labels, Avery US Letter 5160. Open the stock sheet as recipients. In the first label insert the product name and price fields, then Ctrl+F9 and type MERGEBARCODE UPC UPCA inside the braces. Update Labels and Finish & Merge.

  3. Mac: use a barcode font or label program

    Word for Mac has no barcode field. Install a UPC barcode font and format the merged UPC field with it (most UPC fonts need the digits encoded first), or use the label maker's own online designer, which reads a spreadsheet.

  4. Scan one before printing all

    Print a test sheet at 100% on plain paper and scan a few labels with your actual scanner or point-of-sale app. Small barcodes from inkjet printers sometimes need to be printed larger.

Where it stops.

  • Stella makes barcodes from the codes you already have. It doesn't assign new UPCs; those come from GS1 if you sell through retailers.
  • The barcodes were checked by scanning the PDF with software. Scan a printed label with your own scanner before printing them all.
  • Product names, prices and codes go to the AI model you use in Stella. The labels are made on your computer.
  • It makes the PDF; it doesn't print it unless you ask. Print at Actual size, not Fit to page, or the labels won't line up.
  • Recorded on Linux, where Stella installed small Python libraries for the PDF and barcodes. On a Mac or Windows PC it may install Python first, which wasn't recorded.

Questions.

Why won't my barcode scan as the right product?

Usually a lost leading zero: 003292694568 stored as 3292694568 makes a different, shorter code. The other common cause is a barcode printed too small or squashed.

Can it use Code 128 or my own SKUs instead of UPCs?

Yes. Say which column and which barcode type; Code 128 suits internal SKUs with letters in them.

Can I use other label sizes?

Yes: name the sheet (5160, 5163, 5167) or give the measurements. For address labels from a list, see address labels from Excel.

What about QR codes for product pages?

See make QR codes in bulk, one image per link.

Is Stella free for this?

Yes. Free with the ChatGPT or Claude plan you already have. Sign in with your ChatGPT plan, or use your Claude plan through Claude Code, and this task costs nothing extra. New accounts also get a small free trial of Stella’s own models.

Can I control what Stella changes on my computer?

Yes. Stella works on Windows, Mac and Linux with your own files and shows each step in the chat, so you can watch it and stop it at any point. Tell it what it may not do, as the prompts on these pages do (“don't delete anything without asking”). In the Downloads recording it deleted nothing until it was told to go ahead. It also refuses commands that would wipe a whole disk, your home folder or system folders.

Checked against these sources on 14 November 2026.

Stella