I have an InDesign template that I currently copy and paste text from Excel into manually. I want to import the Excel into InDesign to help speed up this process, however when I import the data my InDesign formatted changes. How do I import Excel text into my InDesign doc without changing the formatting?
You can import an Excel sheet into InDesign with File > Place. Ensure you have Show Import Options ticked when the file browser loads, then select Formatted Table in the options. That will often do a good job of importing the font, font size, column width etc from Excel.
I copy the cells to Word and import the Word document. Specially with date import I get a mess if I import the Excel file directly.