How to Export a Word Mail Merge Recipient List to Excel
Question details
The user wants to move a Word mail merge recipient list into an Excel spreadsheet.

- 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.
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.
Copy a Word recipient table into Excel
Use this method when the recipient list is available as a table in a Word document.
In Word, open the document containing the recipient table and check that its first row identifies fields such as name and address.
Select the recipient table, including its header row, and press Ctrl+C or choose Copy.
In a blank Excel worksheet, select cell A1 and press Ctrl+V or choose Paste. Check that each field appears in its own column.
Choose File > Save As and save the worksheet as an Excel workbook.

Import an Access recipient database into Excel
Use this method when the mail merge recipient list is stored in an MDB file.
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. Open the document: Open WPS Writer and choose Open to select the Word document containing the recipient table.
- 2. Copy the recipient table: Select the table and its header row, then choose Copy or press Ctrl+C.
- 3. Paste into a spreadsheet: Create a blank file in WPS Spreadsheet, select cell A1, and choose Paste or press Ctrl+V.
- 4. Save as an Excel workbook: Check the columns, then choose File > Save As and select the XLSX format.

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.




