How to Fix Word Mail Merge Not Importing Multiple Comma-Separated Numbers
Question details
Users encounter an issue during mail merge where columns containing multiple comma-separated numbers are not imported correctly into the document.

- Product
- Microsoft Word / WPS Writer
- Device & OS
- not provided
- Scenario
- Importing data from an Excel spreadsheet into a Word document using the Mail Merge feature.
- Observed behavior
- The mail merge engine interprets the source column as numeric. When it reads multiple numbers separated by a comma (e.g., '27, 38'), it fails to parse them as a single number and returns a zero or a blank value instead of the actual text.
Ensure your Excel data source spreadsheet is saved and fully closed before making connection changes in your word processor to prevent file locking issues.
Insert a Dummy Text Record to Force Text Formatting
By placing an obvious text string in the very first row of your data source, you force the mail merge engine to treat the entire column as text instead of numbers.
When importing data, the OLE DB connection checks the first few rows of a column to determine its data type. If it sees numbers, it assumes the whole column is numeric, causing fields with commas to break. Adding a temporary text value bypasses this behavior.
Launch Excel and open the spreadsheet containing the data you want to merge.
Right-click the row number immediately below your header row and select 'Insert' to create a blank row.
In the problematic column, type a dummy entry that includes text and a comma (for example, 'Dummy, 12').
Save and close the Excel file. Open your Word document, reconnect to the data source, and complete the merge. You can manually delete the document containing the dummy record later.
Change Excel Column Format to Text
Pre-formatting the entire column as text in Excel can sometimes prevent the mail merge engine from making incorrect data type assumptions.
Perform Flawless Mail Merges with WPS Office
Avoid frustrating formatting interpretation errors by using WPS Office. WPS Writer seamlessly integrates with WPS Spreadsheet, ensuring your text, numbers, and custom formatting are imported precisely as they appear in your data source.
- 1. Open Mail Merge: Launch WPS Writer, navigate to the 'References' tab on the top ribbon, and click on 'Mail Merge'.
- 2. Connect Data Source: Click 'Open Data Source', locate your WPS Spreadsheet or Excel file, and select the specific sheet containing your records.
- 3. Insert Fields and Merge: Use the 'Insert Merge Field' button to place your data into the document, then click 'Merge to New Document' to generate your final files.

Frequently Asked Questions
Why does my Mail Merge turn numbers into zeros or blanks?
The connection method (usually OLE DB) scans the first 8 rows of your spreadsheet to guess the column's data type. If it detects mostly numbers, it sets the type to numeric. Any cell containing text or multiple numbers separated by commas fails the numeric conversion and is returned as a zero or blank.
Can I use a DDE connection to fix this mail merge formatting issue?
Yes. You can bypass OLE DB limitations by enabling 'Confirm file format conversion on open' in Word Options. When attaching your data source, choose 'MS Excel Worksheets via DDE'. This older method imports data exactly as it looks on your screen, preserving the comma-separated numbers.
Why didn't formatting my Excel column as text work?
Sometimes the OLE DB provider ignores cell formatting if the actual content still looks like numbers in the first few rows. This is why inserting a dummy record with letters into the very first row is the most reliable way to force the system to read the column as text.




