indesign data merge multiple records single page

For CSV and TSV files, the first line (row) of your data source is used as fields in Publisher the row must contain explicit names to be fields.You can add (or alter) data records to the external data source at any time (even after merging) but don't worry if some records don't contain data as these will be treated as blank fields once merged. Of course, it needs to be populated with data records. The source needs to be available in advance of data merging and have a consistent logical structure that is finalised. Contact lists can be exported from, and other services.

The data source exists outside of Affinity Publisher, typically exported from another app or website. Design to a single spread or grid layout.The key steps for successful data merging are: Your data records could also include image links (resource path names) which can be be associated with a picture frame in Publisher-on merging, the referenced images (e.g., profile or product photos) merge into picture frames sequentially. The text files could be an exported address book or contact lists. Microsoft Excel, Apple Numbers, LibreOffice). Data source typesĭata sources include text (plain/CSV/TSV), JSON and XLSX spreadsheet files (e.g. For example, you can publish ID passes that are personalised with passholder's names and that person's profile picture.Ī Data Merge Manager is used to add the external data source, manage this resource and generate the merged document. About data mergeĭata merge means injecting data from a data source into documents such as personalised certificates, letters, envelopes, greeting cards, as well as mailing labels, badges, passes to more complex multi-page business cards, catalogues, photo albums or any deliverable where personalisation is needed. Data merge inserts text and image links from other programs into your publication pages.Īwards and Business cards (N-up grid layout) merged from an external data source.

Indesign data merge multiple records single page