Skip to main content
K
Kallie28459238bt3b
Participant
January 21, 2025
Answered

Trouble with large Datamerge document

  • January 21, 2025
  • 1 reply
  • 229 views

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).

 

 

 

Correct answer Robert at ID-Tasker

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? 

 

1 reply

Robert at ID-Tasker
Robert at ID-TaskerCorrect answer
Legend
January 21, 2025

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? 

 

    K
    Kallie28459238bt3bAuthor
    Participant
    January 21, 2025

    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
    Robert at ID-Tasker
    Legend
    January 21, 2025

    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. 

     

      Terms & ConditionsAccessibility statement
      Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices