Copy/paste excel table into InDesign

[steffenm32535037]

Hi all,

I often have to make tables in InDesign, which I copy/paste from the excel file in which the calculations are made. Until recently (I guess after the latest update of InDesign) this worked very well, but now when I copy a table from excel, it pastes all data in the same column. I added two screenshots to make it more clear. The only way around now is copy/paste column per column, which is an absolute waste of time. Anybody who knows how I can solve this problem? Many thanks in advance!

[Laubender]

Hi @Jeppe27002532ayuh ,

just a guess: perhaps every other row in the Excel table is a hidden row?

( And Word consolidates the table? )

Currently I have no Excel at hand to test this…

Regards,
Uwe Laubender
( Adobe Community Expert )

[Jeppe27002532ayuh]

Hi @Laubender 

No hidden rows. It's just a simple Excel sheet.
But - I just did a test, and have discovered the problem now. If I copy from an Excel sheet that is opened in Sharepoint in the browser, then the additional empty rows are added. If I open the same document in the desktop app, then I can copy and paste just fine. So the clipboard input from Excel in the browser probably contain some additional hidden data, that InDesign then create rows for. That just a guess on my part.

[RvdT]

I would like to add that: if you want to keep excel formatting, the best way, imo, is to place the excel.

Turn on: Show import options

and place as a Formatted Table.

[Monserrat31138699dlcr]

I opened the excel in Google Sheets, then I can select and paste directly in Indesign, i hope it can work in your case.