This tutorial will show you how to use InDesign’s Place command to make product sheets that retain formatting from an Excel spreadsheet.
- You can download the free project template from the button above.
The ability to copy Excel formatting to an InDesign document can be convenient in many instances, although some control is lost as part of the process. The other Place command tutorial offers a greater level of control by applying formatting within InDesign.
Pagination overcomes conversion issues and accurately converts even the most complex spreadsheets. It can also combine multiple data sources, e.g., product information from Excel files and pricing information from your ERP export.
Table of Contents
- Preparing the Excel file
- Selecting a cell range
- Starting our InDesign document
- Linking InDesign and Excel
- Deploying the Place Command