Document Editing Problems

How to Fix Word Mail Merge Not Importing Multiple Comma-Separated Numbers

Huma Ashraf ChHuma Ashraf Ch Nov 4, 2026 871 views

Question details

Users encounter an issue during mail merge where columns containing multiple comma-separated numbers are not imported correctly into the document.

How to Fix Word Mail Merge Not Importing Multiple Comma-Separated Numbers
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.
Before you start

Ensure your Excel data source spreadsheet is saved and fully closed before making connection changes in your word processor to prevent file locking issues.

Solution 1Recommended

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.

1
Open the data source

Launch Excel and open the spreadsheet containing the data you want to merge.

2
Insert a new row

Right-click the row number immediately below your header row and select 'Insert' to create a blank row.

3
Add a dummy text value

In the problematic column, type a dummy entry that includes text and a comma (for example, 'Dummy, 12').

4
Save and re-link

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.

Why this workaround is effective: Because the first data cell encountered contains letters, the engine immediately categorizes the column as 'Text', ensuring all subsequent comma-separated numbers are preserved exactly as typed.
Seamless Document Merging

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. 1. Open Mail Merge: Launch WPS Writer, navigate to the 'References' tab on the top ribbon, and click on 'Mail Merge'.
  2. 2. Connect Data Source: Click 'Open Data Source', locate your WPS Spreadsheet or Excel file, and select the specific sheet containing your records.
  3. 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.
Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) file formats.Intuitive Mail Merge wizard to easily handle complex data imports and formatting.Free, lightweight, and user-friendly alternative for all your document editing needs.
microsoft office alternative - wps office

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.