Exporting Table from excel sheet to indesign

[bijoyb]

I tried to import the excel sheet to InDesign but the format is not the same. Does anybody know how to fix this?

[BobLevine]

What are you trying to fix? What were your import settings when you placed the Excel file?

[bijoyb]

I want the same background from the excel sheet copied to InDesign.

[vinny38 · Accepted solution]

When it comes to tables, a good practice is always to style up the table in Indesign, using cell and table styles.

See here: Table and cell styles in InDesign  

I highly recommend using a table style, especially if you intend to make changes in your Excel file and have your data updated without loosing formatting.

Now, I understand that you want to retrieve the alternate grey fills.

They can be formatted in the Table options or - even better - in the Table style options:

Add table strokes and fills in InDesign