Reply To: Data Merge issue

When you say the column letter designations are not consecutive, do you mean the letters that Excel provides along the top edge? If those are not consecutive, then there’s a chance that some are hidden. You may have to right-click on the boundary and choose “Unhide” from the context menu.

Another option is to export as CSV and then open that CSV in Excel… that way, there should be no formatting at all.

Here are a couple other articles to look through:

Troubleshooting Data Merge Errors

Zap Gremlins in Problem Data Merge Files