Stella
Printing and labels

Print address labels from Excel on Avery 5160 sheets

48 addresses from a card list on two label sheets, in list order, every ZIP intact.

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 1 min 35 s in real time.

The short answer.

The usual route is a mail merge: in Word choose Mailings, Start Mail Merge, Labels, pick Avery US Letter 5160, use your spreadsheet as the recipient list, untick anyone you're skipping, insert an address block and finish the merge. Format the ZIP column as text first, or East Coast ZIPs lose their leading zero. Stella (stella.sh) reads the spreadsheet on your computer and writes a print-ready PDF laid out on the 5160 grid, with the zeros put back.

Stella does this on Windows, Mac and Linux.

What happened.

Two label sheets in about a minute and a half. Checked afterwards against an answer key written before the run: US Letter pages, all 48 Yes addresses each on exactly one label, every line (name, street, apartment, city, state, ZIP) inside its 5160 label, list order kept, leading zeros kept, no blank-apartment junk like “None”, nobody marked No, and the spreadsheet unchanged.

The names and addresses are made up for this run. The work is sped up 4×.

How Stella does it.

  1. Finds Holiday card list 2026.xlsx in Documents and keeps the 48 rows marked Yes, in the list's own order
  2. Leaves out the four people marked No and names them
  3. Spots New England and New Jersey ZIP codes that Excel was showing with a leading zero only through cell formatting, and prints them as five digits (2806 becomes 02806)
  4. Lays the addresses out on the 5160 grid (3 across, 10 down, 2⅝ × 1 in labels): one full sheet and 18 labels on a second
  5. Saves Holiday card labels 2026 - Avery 5160.pdf next to the spreadsheet and says to print at 100% with a plain-paper test sheet first

The prompt.

I need to print address labels for our holiday cards from the spreadsheet in my Documents, for everyone marked Yes. Make them for Avery 5160 label sheets, in the same order as the list.

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. Fix the ZIP column first

    In Excel, select the ZIP column and look at what's really in a cell: if 02806 shows in the sheet but 2806 in the formula bar, the zero is only formatting and a merge will drop it. Add a column with =TEXT(F2,"00000"), fill it down, then copy and Paste Values over the ZIPs.

  2. Start a label merge in Word

    Word on Windows or Mac: Mailings, Start Mail Merge, Labels. Under Label vendors choose Avery US Letter and pick 5160 Address Labels. Then Select Recipients, Use an Existing List, and open the spreadsheet.

  3. Pick who gets a label

    Edit Recipient List and untick the rows marked No, or use Filter on the Send card column. Keep the sort as it is if you want the labels in list order; Word fills each sheet across, then down.

  4. Insert the address and merge

    Click Address Block (or insert the Name, Street, City, State and ZIP fields yourself), then Update Labels so every label gets the same layout. Finish & Merge, Edit Individual Documents, and check that apartments and ZIPs look right.

  5. Test on plain paper

    Print the first page at 100% (no Fit to page) on plain paper, hold it against a label sheet up to a light, and only then load the labels. Printers can shift a millimetre or two.

Where it stops.

  • Stella makes the PDF. It doesn't print it unless you ask it to send the file to your printer.
  • Printers shift slightly. Print one sheet on plain paper and hold it over a label sheet before using the real labels.
  • The names and addresses go to the AI model you use in Stella while it reads the list. The PDF is written on your computer and nothing is uploaded to a label website.
  • It works from what's in the sheet: a misspelled street or a wrong ZIP is printed as typed. Stella flags blanks and duplicates but doesn't check addresses against the postal service.
  • Recorded on Linux, where Stella used Python and small spreadsheet and PDF libraries it installed. On a Mac or Windows PC it may install Python first, which wasn't recorded.

Questions.

What size is an Avery 5160 label?

2⅝ × 1 inches, 30 to a US Letter sheet in 3 columns and 10 rows, with a ½ inch top margin. Many other brands sell the same layout as “5160 compatible”.

Why did my ZIP codes lose the zero?

Excel stores 02806 as the number 2806 unless the cell is text. A custom 00000 format only hides that, so mail merges and exports print four digits. Convert the column to text first, or let Stella put the zeros back.

Can I print envelopes instead?

Yes: see print envelopes from Excel, one per household with your return address. For letters to everyone on the list, see mail merge from Excel to Word.

Can it do return address labels or other sheet sizes?

Yes: name the sheet's product number (5160, 5163, 8160 and so on) or its measurements. For product labels with barcodes, see barcode labels from Excel.

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