Skip to main content
Jennifer, marketeer
Participant
Jul 31, 2024 9:55 AM UTC
Answered

Excel into indesign

Hey guys, i need to make a productcatalog for my work. We have millions of products listed in an excel sheet. It looks like this:

 

Now i am designing the book and need to import the sheet into my indesign file. However, even after placing/importing it in millions of ways this is the way it imports into indesign (empty): 

 

 

What am i doing wrong? 

This topic is closed to new replies. Start a new post to keep the conversation going.
Jennifer, marketeer
Jennifer, marketeerCorrect answer
Participant
Jul 31, 2024 1:19 PM UTC

Hi @Laubender, it is bigger than this, but also devided in multiple different excel folders so that cannot be the issue. I resolved it, it was a simple thing actually... the font was too big so it did not show up. I have had many issues with excel and indesign in the past but this feels like a dumb rookie mistake haha. Thankyou for the help both of you. 

3 replies

Mike Witherell
Community Expert
Community Expert
Jul 31, 2024 12:26 PM UTC

What do you discover when you change the view into Story Editor mode?

Translate
Mike Witherell
Community Expert
Jul 31, 2024 10:26 AM UTC

Hi @Jennifer, marketeer ,

how many populated rows of data has your Excel sheet exactly?

How many columns?

InDesign's tables have some restrictions on the number of columns and rows.

Out of my memory: there is a maximum of 200 columns and 20,000 rows for a single InDesign table.

 

Regards,
Uwe Laubender
( Adobe Community Expert )

Translate
Jennifer, marketeer
Jennifer, marketeerAuthorCorrect answer
Participant
Jul 31, 2024 1:19 PM UTC

Hi @Laubender, it is bigger than this, but also devided in multiple different excel folders so that cannot be the issue. I resolved it, it was a simple thing actually... the font was too big so it did not show up. I have had many issues with excel and indesign in the past but this feels like a dumb rookie mistake haha. Thankyou for the help both of you. 

Translate