Trouble with large Datamerge document

[Kallie28459238bt3b]

Hello,

I am attempting to create SDS sheets using InDesign 2024, but I'm having issues with InDesign's Datamerge. My process is: enter the data into google sheets (Column A is the header names, B will be the product information for the SDS sheet.... transcribed into columns... and then downloaded as a CSV), and then import into InDesign using DataMerge. 

This is the first time I'm using a larger data set (300 rows of text, transcribed into columns). At around the 84th row/column, InDesign does not import that data into the datamerge. I am not getting any errors. I had no problems placing the headers, and everything imports properly until around row 84. The file is only 13 KB, so I'm surprised that I'm having issues. 

Any advice/tips? 

Pictures attached of the google sheet, and InDesign doc where the data fails to import (before and after preview is enabled).

[Robert at ID-Tasker · Accepted solution]

Can you post a screenshot of the whole row(s) that doesn't import? 

Or better yet - this part of the CSV file. 

Do you have there manual line breaks? 

[Kallie28459238bt3b]

Hey Rober! WOW- thanks for the help! Great thinking on the manual line breaks- that appears to be the issue! I removed the line breaks and now the data seems to import properly. Is there an alternative way to achieve the same effect as a manual line break that you know of? Thank you so much! I've been pulling my hair out over this one!

[Robert at ID-Tasker]

You're welcome. 

You need to use something unique instead - #$# - or something - then, after importing - use F&C to replace with soft or hard returns.