Convert Mailing Labels PDF to Excel on Mac: Rebuild the List

To convert a PDF of mailing labels back into Excel on a Mac, use a tool that reads every label as one record and returns one row per address, with the name, company, street, second address line, city, state and ZIP code in their own columns. Tell it the sheet layout (an Avery 5160 sheet is 30 labels in three columns of ten), then check the row count against the number of labels and repair any ZIP code that lost its leading zero. The result is a mailing list you can sort, clean and merge onto labels again.

The Mac app for that is ignitai. It reads each page with Apple’s on-device text recognition, and an AI builds the table your plain-English instruction describes, so one instruction handles three-line labels, five-line labels and the odd “Attn: Accounts Payable” line in between. The page images stay on your Mac; only the recognized text goes to ignitai’s servers, where the spreadsheet is built.

The situation is always some version of this: the only copy of the list is the labels. A volunteer printed the holiday mailing from a spreadsheet nobody kept, a membership system offers a “labels” report but no export, or a partner sent a PDF of labels instead of the list behind them. The addresses are all there, 30 to a page, and none of them is in a cell.

In this guide11 sections

Why label sheets don’t convert cleanly

1. The records sit in a grid, not in rows. A label sheet prints three labels side by side. A grid-based PDF-to-Excel converter reads across the page, so the first lines of three different labels land in one row: “Robert Chen · Ana Ruiz · Okafor Family”.
2. Labels have different line counts. One label is name, street, city line. The next adds a company. The next puts “Apt 4B” on a line of its own. Any approach that maps line two to “street” goes wrong on the first label with a company line.
3. City, state and ZIP share one line. “Springfield, IL 62704-1234” is three fields for a mail merge, an import or a sort by state, and one string on the label.
4. Names come in mixed forms. “Mr. and Mrs. Robert Chen”, “The Okafor Family”, “Dr. Ana Ruiz”, “Current Resident”. An address book wants a first and last name; a label wants the line exactly as printed.
5. Leading zeros vanish. ZIP codes in New England, New Jersey and Puerto Rico start with 0 (02139, 07030, 00901). Spreadsheets read them as numbers and drop the zero, and an envelope addressed to 2139 is a problem.

Convert a mailing labels PDF to Excel on Mac with ignitai

1. Find the label file. A PDF made by a mail merge, a report saved as PDF, or scanned sheets of printed labels all work, and born-digital and scanned PDFs can go in the same batch. Photos of label sheets run as a batch of their own, because on Mac a drop that mixes PDFs and image files imports only the PDFs.

2. Drag the PDF onto the ignitai window, open it with ⌘O, or right-click it in Finder and choose Open With. If all you have is printed sheets, File ▸ Import from iPhone or iPad scans them with your iPhone’s camera.

3. Describe the sheet and the rows. A prompt is required, so the Convert button stays disabled until you type one:

   “Each page is a sheet of address labels printed in 3 columns and 10 rows. Read each label as one record. One row per label. Columns: full_name (the name line exactly as printed), first_name, last_name, company, address_1, address_2 (apartment, suite, unit, PO box or attention line when it is on a line of its own), city, state (two-letter code), zip (exactly as printed, keeping leading zeros and the ZIP+4 hyphen), country (only if printed). Fill first_name and last_name only when the label names one person. Leave a cell empty when the label doesn’t print that field. Skip blank labels.”

   Change “3 columns and 10 rows” to match your sheet; the table below lists the common layouts. Save the instruction, and next year’s labels are one click away.

4. Check the page count, then Convert. Before the run starts, ignitai shows how many pages it will use and how many you have left. Each file shows its status as it runs, and a notification arrives when the spreadsheet is ready.

5. Check the table in ignitai. Every row is numbered, so the last row number is your label count; compare it with the labels per sheet times the number of full sheets, plus the labels on the last one. Original Pages keeps the label sheets a click away for spot checks. If a column came back empty, ignitai says so: an empty company column may be right, an empty zip column never is.

6. Export to Excel. The header is bold and the columns fit their content. Corrections happen in Excel or Numbers.

Several lists, one batch. Filenames never leave your Mac, so batch output has no column saying which file a row came from. To keep the board list and the donor list apart, convert them as separate runs, or add a list column after export and fill it down.

Long lists and the page allowance. Your first document converts free, up to 4 pages, which on 5160 sheets is up to 120 labels; prove the instruction on that before the full run. The plan includes 80 pages a week, up to 320 a month, and unused weekly pages don’t carry over. A 2,000-name list on 5160 sheets is 67 pages and fits one week. A 4,000-name list is 134 pages: ignitai shows that count before converting, so split the PDF across two weeks or buy extra pages for the rest.

Get ignitai on the App Store — free download; your first document (up to 4 pages) converts free with Sign in with Apple, and one subscription covers iPhone, iPad, Mac, and Vision Pro.

Common label layouts

The layout tells the instruction how to read the page, and labels per sheet is the number your row count should reach.

Many other brands print the Avery number on the box as “compatible with 5160”, which means the same grid. If you don’t know the product, count one full page.

Check the list before you mail

• Count. The last row number in ignitai, or =COUNTA(E:E)-1 (the address_1 column) in Excel, against labels per sheet × pages. A shortfall of exactly three usually means one row of labels was missed; Original Pages shows which.
• ZIP codes. Sort the zip column. A four-digit value is a ZIP that lost its leading zero. Rebuild the column as text with =TEXT(I2,"00000") (for five-digit ZIPs) and paste it back as values, so a mail merge prints the zero too. A number format alone changes what you see, not what every merge reads. ZIP+4 codes written with a hyphen are already text.
• States. =LEN(H2)<>2 on the state column flags anything that isn’t a two-letter code: a misread, or an address outside the US that needs a country.
• Split fields. Filter city and zip for blanks; a label that didn’t split, often one with a PO box and a street, is quicker to fix by hand from Original Pages.
• Duplicates. In Excel, =COUNTIFS(E:E,E2,I:I,I2)>1 (street and ZIP) flags addresses that appear twice. Data ▸ Remove Duplicates removes them, but decide first whether two people at one address should get one envelope or two.
• Spot checks. Pick ten rows at random and compare each with its label in Original Pages, including the apartment numbers.

The PDF reproduces what was printed, including addresses that have gone stale. A large mailing at commercial postage rates must meet USPS move-update rules, which a mail house handles with CASS and NCOA processing.

Back onto labels: mail merge on a Mac

• Word for Mac. Save and close the workbook in Excel first. In Word, choose Mailings ▸ Start Mail Merge ▸ Labels and pick the product (Avery US Letter 5160, for example). Then Select Recipients ▸ Use an Existing List, choose the workbook, insert the merge fields into the first label and use Finish & Merge. Print one sheet on plain paper and hold it against a label sheet before you use the real labels.
• Avery Design & Print Online. Avery’s free web tool imports .xls, .xlsx and .csv files; each column becomes a merge field and each row a label. If the first row is a header, untick it at the Confirm List step so it doesn’t print on a label. Avery’s help pages list limits on rows and file size, so split a very long list into several projects.
• Contacts on Mac. For a list you also want in your address book, export a CSV from ignitai, choose File ▸ Import in Contacts, and set any column you don’t need to “Do not import”. Contacts collects the new cards in a Last Import list. Select them, choose File ▸ Print, set Style to Mailing Labels (click Show Details if it’s hidden), and pick Avery Standard and the product number under Layout. Every name lands in your iCloud contacts, so skip this route for a 3,000-member roll.
• Pages. Pages 12.1 and later merge from Contacts or a Numbers spreadsheet: save the Excel file in Numbers, then choose Document ▸ Mail Merge ▸ Add Merge Field ▸ Add from Spreadsheet. It suits letters and envelopes better than label sheets.

The same list can feed a CRM or Google Contacts, both of which import a CSV; the business-card guide covers matching columns to their fields.

Other ways to get labels into Excel

• Ask for the source. Whoever produced the labels printed them from a list. A membership system, a CRM, a school information system or the person who ran the merge can almost always export CSV, and an export beats any conversion. Ask first.
• Copy and paste from Preview. In a born-digital label PDF, Preview can select the text, but a copied page comes out as lines, often interleaved across the three columns. Fine for one short sheet.
• Acrobat’s Export PDF to Excel. It keeps the page geometry: three labels across become three columns of stacked lines, and reshaping that is a formula exercise per sheet. Excel for Mac’s Get Data has no From PDF connector at all; that one is Windows only.

When the names and addresses come from sign-up sheets or registration forms rather than labels, the PDF-form guide covers one row per form, and a typed directory or roster with a real table is closer to the scanned-PDF workflow.

On iPhone and iPad

• iPhone. A binder of printed label sheets or a directory someone printed years ago: scan the pages with the camera in ignitai, tap the saved instruction, and follow progress on the Lock Screen and in the Dynamic Island.
• iPad. Label PDFs that arrive by email can be multi-selected in the Files picker or sent from Mail through the share sheet (there’s no external drag-and-drop into the app on iPad). Sort the finished table by state or ZIP, then select rows and copy them before you export.

One subscription covers iPhone, iPad, Mac and Vision Pro, and finished files open on your other devices after Sign in with Apple. If the list is headed into Numbers, the PDF-to-Numbers guide covers opening the export and saving it as a .numbers file.

Names and addresses are personal data

In this workflow the page images stay on your Mac. The recognized text of every page goes to ignitai’s servers, where the AI builds the sheet, and that includes every name and address on the labels. The finished file is stored in your ignitai account until you delete it, and any file, or the whole account, can be deleted from inside the app. If the list belongs to an organization, such as a member roll, a donor list or a parent directory, check its rules on who may handle it before you convert.

When not to use this

• The source list exists. Export it and skip the conversion.
• A dozen labels. They’re quicker to type.
• Handwritten addresses. Envelopes addressed by hand are outside what this guide covers; it’s for printed and typed labels.
• Shipping labels. For 4×6 carrier labels, the carrier account can usually export the shipments as a file. Use that first.

Bottom line

To convert a mailing labels PDF to Excel on a Mac, drag the label sheets into ignitai, describe the grid (three columns of ten for an Avery 5160), and ask for one row per label with the name, company, address lines, city, state and ZIP code in their own columns. Check the row count against labels per sheet, rebuild ZIP codes that lost a leading zero as text, flag duplicates, and spot-check ten rows against the original pages. Then merge the list back onto labels with Word, Avery’s Design & Print Online or Contacts. If anyone still has the list the labels came from, ask for that first.

FAQ

How do I convert mailing labels from a PDF to Excel?

On a Mac, drag the label PDF into ignitai, describe the sheet layout (for example, three columns of ten labels) and ask for one row per label with the name, company, address lines, city, state and ZIP code in separate columns. Convert to Excel, then check that the row count matches the number of labels and that ZIP codes kept their leading zeros.

Why do ZIP codes lose their leading zero in Excel?

Excel treats 02139 as the number 2139 and drops the zero, most often when a CSV file is opened directly. Rebuild the column as text with =TEXT(A2,"00000") and paste it back as values, so a mail merge prints the zero too. ZIP+4 codes written with a hyphen are already text.

How do I print labels from an Excel list on a Mac?

In Word for Mac, choose Mailings ▸ Start Mail Merge ▸ Labels, pick the label product, then Select Recipients ▸ Use an Existing List and choose the workbook. Avery’s free Design & Print Online imports .xlsx and .csv files too, and Contacts on Mac prints mailing labels from cards imported from a CSV.