Convert a Word Mail Merge MDB Address List to CSV
Question details
Convert a Word mail merge Office Address List stored in an MDB file to CSV for use in other applications.
- Product
- Microsoft Word and Microsoft Excel
- Device & OS
- not provided
- Scenario
- An address list created for a Word mail merge needs to be used in an application that accepts CSV files.
- Observed behavior
- The address list is saved as an MDB database, and the desired result is a CSV file containing its fields and records.
Locate the MDB address list and check that you have access to Excel. If Excel cannot open the database, check whether your Excel installation supports importing Access databases and has the required database driver.
Import the MDB address list into Excel and save it as CSV
Use Excel to import the address list directly, then export the worksheet as a CSV file.
Import options vary by Excel version. A typical Word Office Address List contains one table; if Excel offers multiple tables, select the one containing the addresses.
In Excel, select File > Open > Browse, change the file type filter to All Files, and select the MDB address list. If it does not open this way, try Data > Get Data > From Database > From Microsoft Access Database, if available.
Follow the import prompts and accept the settings. If a Navigator or table-selection window appears, select the address table and choose Load.
Check that the field names and address records appear in the worksheet. Select File > Save As, choose CSV UTF-8 (Comma delimited) or another CSV format, and save the file.
Open the CSV in the destination application and verify that the columns and special characters appear correctly.
Create a Word directory merge and export the resulting table
Use a directory merge to place address records in a Word table when direct MDB import into Excel is unavailable.
Work with exported address lists in WPS Spreadsheets
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing exported address lists. It supports common Microsoft Office formats for an easier transition, although it does not replace the MDB import process described above.

Frequently Asked Questions
Can I convert the MDB file by changing its extension to CSV?
No. MDB is a database format, while CSV is a text format. Import the address table into Excel and use File > Save As to create a CSV file.
What if Excel asks me to choose a table?
Select the table containing the address fields and records in the import or Navigator window, then choose Load. A typical Word Office Address List contains one table.
Why can't Excel open my MDB address list?
MDB import support depends on your Excel version, platform, and available Access database driver. Try Data > Get Data > From Database > From Microsoft Access Database if the command is available, or use the Word directory merge method.
Which CSV format should I choose for special characters?
In Excel, select File > Save As and choose CSV UTF-8 (Comma delimited) if it is available. Then open the file in the destination application to check that the characters display correctly.




