4 Replies Latest reply on Jul 2, 2014 6:45 AM by gigiad

    Most efficient way to import data from Excel to InDesign?

    lucywight

      Hi all,

       

      I'm designing a college prospectus which includes 400+ course listings. At the moment, these listings exist as a vast Excel sheet with fields like course type, course code, description etc.

       

      I'm familiar with importing Excel data into InDesign and formatting tables/creating table styles and such, but the problem I'm having is that the data is in multiple columns per course in the Excel sheet, but will be arranged in one column per course with multiple rows in the InDesign document. I can't seem to find a way to easily convert these columns into rows.

       

      Can anyone help me with an efficient way to get the data into the layout without laborious copying and pasting or formatting?

       

      Many thanks in advance!