1 Reply Latest reply on Aug 3, 2016 9:48 AM by SJRiegel

    Can you import Excel/CSV columns into multiple InDesign table rows?

    Snowbound Cam

      I have an MS Excel spreadsheet with 250 rows, each row containing 4 columns of data (typical Excel columns A, B C and D).

       

      I need to import this into an InDesign table that will look like this:

      Screen Shot 2016-08-03 at 11.56.41 AM.png

      So basically columns A, B and C end up all in one row, but column D ends up in a row below A, B and C, and column D spans across the full width of columns A,B, and C.

       

      Is there a way to do this without having to do it manually?

        • 1. Re: Can you import Excel/CSV columns into multiple InDesign table rows?
          SJRiegel Adobe Community Professional & MVP

          There is an InDesign Plug in you can buy called DataLinker (from teacup software) that will do this quite nicely, and will keep all the Data in one table.

           

          If you want to use InDesign's native abilities, You could set up a data merge with a 2 row table in a text box set to fit the table exactly, and set your merge with 0 space between the records. The result would look like a single table, but would in fact be all separate tables in separate text boxes.

          Screenshot 2016-08-03 12.40.58.pngScreenshot 2016-08-03 12.41.38.pngScreenshot 2016-08-03 12.46.21.png