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!

[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.