Skip to main content
Inspiring
September 12, 2023
Answered

Data Merge not bringing in data from all the fields consistently

  • September 12, 2023
  • 1 reply
  • 405 views

Hi! I created a template for a Data Merge in Indesign, and am using an Excel .csv file for data source (including image paths). Everything seems to be going swimmingly, BUT THEN... I see that some fields aren't being brought in on just a few of the entries. So I have it set up for name, title, company, and email address, but on some of them the title is missing or the email is missing, even though those entries DO have titles or emails in the correct fields. Data merge is also creating 2 completely empty instances on the second-to-last page, then the last entry shows up all by its lonesome on the last page. Any ideas what might be going on? Thanks.

This topic has been closed for replies.
Correct answer Peter Spier

Check for carriage returns in your data...

1 reply

Peter Spier
Community Expert
Peter SpierCommunity ExpertCorrect answer
Community Expert
September 12, 2023

Check for carriage returns in your data...

Inspiring
September 12, 2023

That did it, thanks!

Peter Spier
Community Expert
Community Expert
September 12, 2023

When I need multiple paragraphs in a field I use a character or combination of characters that otherwise won't appear in the document in place of the break, then use Find/Change after the merge to find them and replace with the required break.