Place an Excel File?

If you have an Excel spreadsheet and you want to turn it into a table in InDesign without having to copy and paste all the data, you can place the Excel file like you would an image. Just go to File > Place and locate your file, make sure you have Show Import Options checked, and click OK. This gives you the Microsoft Excel Import Options dialog, where you can select which sheet to import (if your spreadsheet has multiple sheets) and even which cells to import. If you have made any specific formatting adjustments, such as alignments or colored cells, then make sure you select Formatted Table from the Table pop-up menu; otherwise, leave this set to the default Unformatted Table option to import only the data. Once you’ve made your selections, click OK. After the table has been placed, you may need to manually adjust some columns to make the data fit, and you can apply any formatting you require.