You are currently offline, waiting for your internet to reconnect

Attaching a large comma-separated variable file as a mail merge data source is very slow

Support for Office 2003 has ended

Microsoft ended support for Office 2003 on April 8, 2014. This change has affected your software updates and security options. Learn what this means for you and how to stay protected.

This article was previously published under Q286901
This article has been archived. It is offered "as is" and will no longer be updated.
When you use a comma-separated variable (CSV) file as the data source for a mail merge in Microsoft Word, you find that an inordinate amount of time is required for Word to attach and process the data.
To work around this behavior, import the CSV data file into a Microsoft Excel worksheet, and then use the worksheet file as the data source for your mail merge. To do this, follow these steps:
  1. Start Excel. On the File menu, click Open.
  2. In the Files of type list, select Text Files (*.prn; *.txt; *.csv).
  3. Browse to select the CSV file that contains the mail merge data, and then click Open.
  4. On the File menu, click Save As.
  5. In the Save As dialog box, change the Files of type box to Microsoft Excel Workbook (*.xls), and then click Save.
  6. Exit Excel.
You can now use the Excel workbook instead of the text file as the data source for the mail merge. If you have a large data source file, the extra time taken to convert it to an Excel worksheet is more than compensated by the time saved in attaching the data file in the Word mail merge.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
WD2002 WD2003

Article ID: 286901 - Last Review: 01/11/2015 04:00:49 - Revision: 2.2

Microsoft Office Word 2003, Microsoft Word 2002 Standard Edition

  • kbnosurvey kbarchive kbbug kbmerge kbnofix KB286901