Convert Word Mailing Labels into Separate Excel Columns on Mac
Question details
Transfer approximately 200 Word mailing labels into separate Excel columns for names, street addresses, states, and ZIP codes.

- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- Mac
- Scenario
- The user has a Word document containing mailing labels and wants a spreadsheet with one address per row.
- Observed behavior
- The desired spreadsheet has separate fields for each part of a mailing address.
Open the Word document and check whether each label follows the same line order and whether any addresses have extra lines. Decide whether you also need a separate City column, and set the ZIP code column to Text in Excel to preserve leading zeros.
Use a Word macro to convert labels into a data source
Use this approach for a large, consistently formatted set of labels when you are comfortable running a macro in Word.
A label-to-mail-merge data-source macro can turn label content into records, reducing manual work. The result may still need cleanup if labels have different numbers of address lines.
Search for Graham Mayor's "Convert Labels to a Mail Merge Data Source" guide and review its macro and instructions for the label document.
In Word, open the label document and follow the guide to add and run the macro. Check that your version of Word for Mac supports the required macro steps before proceeding.
Open the data source produced by the macro in Excel, or copy its table into a blank Excel workbook.
In Excel, arrange the fields under Name, Street Address, City, State, and ZIP Code as needed. Format the ZIP Code column as Text and check entries with extra address lines.

Export the labels as text and organize them in Excel
Use a plain-text export if you cannot run a macro and are prepared to rearrange the address lines manually.
Organize Word Mailing Labels in WPS Spreadsheets
Open the label document in WPS Writer and transfer its address information into a structured WPS Spreadsheets workbook. You can arrange the fields manually and save the result as an Excel file.
- 1. Open the labels: In WPS Writer, choose File > Open and select the Word document containing the mailing labels.
- 2. Prepare a spreadsheet: In WPS Spreadsheets, create a blank workbook and enter headers for Name, Street Address, City, State, and ZIP Code. Format the ZIP Code column as Text.
- 3. Transfer the addresses: Copy label text from WPS Writer and paste it into the spreadsheet. Move the address parts into the appropriate columns, keeping one label per row.
- 4. Review and save: Check the rows for extra address lines and leading zeros in ZIP codes, then choose File > Save As and select Excel Workbook (.xlsx).

Frequently Asked Questions
Will saving the Word labels as text automatically create Excel columns?
No. A text export preserves the text but may not identify label boundaries or address fields. After importing it into Excel, arrange the lines into one row per address and use Data > Text to Columns where the data has consistent delimiters.
How can I keep leading zeros in ZIP codes?
Before entering or importing ZIP codes, select the destination column in Excel and format it as Text. Check the imported values afterward; if a leading zero was already removed, restore it from the original label.
What if some labels include an apartment or suite line?
Add an Address Line 2 column in Excel, or combine the extra line with the street address. Review those records after using a macro or importing text because their fields may shift.
Can I use the converted spreadsheet for a future mail merge?
Yes. Keep one contact per row and give each column a clear header, such as Name, Street Address, City, State, and ZIP Code. Save the workbook, then select it as the recipient list in your mail-merge application.




