Data Import & Export

How to Export a Word Mail Merge Recipient List to Excel

Maira MehtabMaira Mehtab Nov 22, 2026 868 views

Question details

The user wants to move a Word mail merge recipient list into an Excel spreadsheet.

How to Export a Word Mail Merge Recipient List to Excel
Product
Microsoft Word and Microsoft Excel
Device & OS
not provided
Scenario
A mail merge recipient list is stored in a Word document or an Access MDB database and needs to be available in Excel.
Observed behavior
The recipient records should appear in an Excel worksheet with their fields in separate columns.
Before you start

Locate the recipient list and check whether it is stored as a table in a Word document or in an Access database file such as MDB. Open Excel and create a blank workbook for the imported records.

Solution 1Recommended

Copy a Word recipient table into Excel

Use this method when the recipient list is available as a table in a Word document.

1
Open the recipient list

In Word, open the document containing the recipient table and check that its first row identifies fields such as name and address.

2
Copy the table

Select the recipient table, including its header row, and press Ctrl+C or choose Copy.

3
Paste into Excel

In a blank Excel worksheet, select cell A1 and press Ctrl+V or choose Paste. Check that each field appears in its own column.

4
Save the workbook

Choose File > Save As and save the worksheet as an Excel workbook.

Copy a Word recipient table into Excel
If the data lands in one column: Select the pasted column and use Data > Text to Columns to separate fields when the text has a consistent delimiter, such as a comma or tab.
Work with recipient lists in WPS Office

Copy a Word recipient table into WPS Spreadsheet

If your recipient list is in a Word table, open it in WPS Writer and copy the records into WPS Spreadsheet, then save them as an Excel workbook. For an MDB source, use a compatible database import tool first.

  1. 1. Open the document: Open WPS Writer and choose Open to select the Word document containing the recipient table.
  2. 2. Copy the recipient table: Select the table and its header row, then choose Copy or press Ctrl+C.
  3. 3. Paste into a spreadsheet: Create a blank file in WPS Spreadsheet, select cell A1, and choose Paste or press Ctrl+V.
  4. 4. Save as an Excel workbook: Check the columns, then choose File > Save As and select the XLSX format.
Move recipient names and addresses from a document table into a spreadsheet.Open Word DOCX documents and save spreadsheets in Excel XLSX format.Use familiar copy-and-paste controls in a lightweight office suite.Work with a free Office alternative.
QA img-9

Frequently Asked Questions

How do I export a recipient list stored in a Word table?

Select and copy the table in Word, then paste it into cell A1 of a blank Excel worksheet. Use File > Save As to save the workbook.

Can Excel open a mail merge list stored in an MDB file?

Yes, where the Access import option and a compatible driver are available. In Excel, choose Data > Get Data > From Database > From Microsoft Access Database, select the MDB file, and load the recipient table.

What should I do if pasted recipients appear in one Excel column?

Select the column and choose Data > Text to Columns. Select the delimiter that separates the fields, such as a tab or comma, and preview the result before finishing.

Can I copy email recipients into Excel?

Open the email, expand the message header if necessary, and copy the To or CC field. Paste it into Excel or Notepad; you may need to separate the addresses using Excel's Data > Text to Columns command.