Data Import & Export

Convert a Word Mail Merge MDB Address List to CSV

Natalie TaylorNatalie Taylor Nov 22, 2026 868 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Open the MDB file

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.

2
Import the address data

Follow the import prompts and accept the settings. If a Navigator or table-selection window appears, select the address table and choose Load.

3
Save the worksheet as CSV

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.

4
Check the exported file

Open the CSV in the destination application and verify that the columns and special characters appear correctly.

Database import availability: Excel may require a compatible Access database driver to read MDB files. The available import commands also depend on the Excel version and platform.
Free Microsoft Office alternative

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.

Open and edit CSV address lists after conversionCompatible with Microsoft Excel XLSX and Word DOCX formatsUse a familiar spreadsheet interface to review rows and columnsMove between common Office formats with a lightweight office suite
microsoft office alternative - wps office

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.