4 essential ways from Excel to InDesign
The pagination of Excel data into InDesign is one of the most requested types of workflow.
There are four widely adopted approaches to link Excel with InDesign.
Save Excel as .txt/.csv
Single product style
flat catalog; certificates
Place Command Options
The Place Command is a method of importing data from Excel to an InDesign document. It can be used with Excel and InDesign tables to paginate documents such as simple price lists and business cards.
However, in our opinion Place Command Options are best used in the population and updating of product sheet tables. Yes, population AND update, since one of the features that this method offers is the creation and maintenance of the links between spreadsheet files and the InDesign document.
The Place command has a relatively limited feature set. This restricts its application to projects with only the most simple requirements. Pagination combines the Place command’s ease of a use with a much broader range of possibilities. Plan your project and make use of the latest technologies by reading our up-to-date guide (May 2015): Database Publishing and Variable Data Printing: A Better Approach.
InDesign’s Data Merge tool is a standard method for paginating spreadsheets into business card batches, yearbooks, certificates, price lists and product sheets.
One of Data Merge’s main weaknesses is the need to prepare spreadsheets to InDesign’s exact import specifications. Only .csv and .txt files can be imported, and the conversion process can be daunting, complex and prone to errors.
At Pagination we offer solutions that eliminate the need for conversion and significantly extend the Data Merge tool’s overall feature set. Plan your project and make use of the latest technologies by reading our up-to-date guide (May 2015): Database Publishing and Variable Data Printing: A Better Approach.
Learn how to create a simple car catalog with Data Merge.
XML requires a steep learning curve, and a dedicated team can be required to establish, maintain and troubleshoot the logic behind even relatively simple operations. This high barrier to entry and long-term resource commitment should be considered before using XML on any challenging database publishing or variable data printing project.
Pagination offers the same high customization levels as XML but with far greater ease of use. Our streamlined solutions save time, improve accuracy and simplify even the most complex publishing projects. Plan your project and make use of the latest technologies by reading our up-to-date guide (May 2015): Database Publishing and Variable Data Printing: A Better Approach.
How to make a Catalog with XML Import