Data Import & Export

Convert Word Mailing Labels into Separate Excel Columns on Mac

Emma BrownEmma Brown Nov 14, 2026 868 views

Question details

Transfer approximately 200 Word mailing labels into separate Excel columns for names, street addresses, states, and ZIP codes.

Convert Word Mailing Labels into Separate Excel Columns on Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Find the conversion instructions

Search for Graham Mayor's "Convert Labels to a Mail Merge Data Source" guide and review its macro and instructions for the label document.

2
Run the macro in Word

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.

3
Open the resulting data source

Open the data source produced by the macro in Excel, or copy its table into a blank Excel workbook.

4
Check the address fields

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.

Use a Word macro to convert labels into a data source
Review macro security: Only run macros from sources you trust. Word's macro availability and security settings can vary by version.
Work with labels in WPS Office

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. 1. Open the labels: In WPS Writer, choose File > Open and select the Word document containing the mailing labels.
  2. 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. 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. 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).
Organize mailing labels into separate address columnsOpen Word DOCX files and save spreadsheets in Excel XLSX formatUse familiar document and spreadsheet interfacesWork with a free, lightweight office suite
microsoft office alternative - wps office

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.