Skip to main content
Y
youngmin Jung
Participant
January 1, 2020
Answered

How many columns and rows of CSV file can be imported in InDesign via Data Merge?

  • January 1, 2020
  • 3 replies
  • 1733 views

Hello, I wonder How many columns can indesign handle when doing data merge

 

i have an excel file which has 560 rows and 62 columns,

 

I want to use it with data merge function for repeated document...

 

anybody knows? please, help me~

 

{Renamed by MOD}

This topic has been closed for replies.
Correct answer youngmin Jung

I found the reason. Column name having special characters doesn't be allowed in data merging..

for example column name having (-)  or (/) caused problem.  

 

after replacing those characters to (_) underbar... it was successful.   

 

 

thank you  😄

3 replies

Colin Flashman
Community Expert
Colin FlashmanCommunity Expert
Community Expert
January 2, 2020

This amount of data should be fine.

 

Just be aware that the more data you put in a file, the larger it is going to be and more unwieldy it will become.

If the answer wasn't in my post, perhaps it might be on my blog at colecandoo!
Srishti Bali
Srishti Bali
Legend
January 2, 2020

Hi YoungMin,

 

Thanks for reaching out. There is no limit specified to import data in InDesign, however, it may take more time to import such huge data or if the file size is more than 1GB.

 

 

Regards,

Srishti

Y
youngmin JungAuthorCorrect answer
Participant
January 13, 2020

I found the reason. Column name having special characters doesn't be allowed in data merging..

for example column name having (-)  or (/) caused problem.  

 

after replacing those characters to (_) underbar... it was successful.   

 

 

thank you  😄

    Mario Fritsche
    Mario Fritsche
    Legend
    January 1, 2020

    Einfach ausprobieren...

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