Data source files overview

A data source file provides the variable information that InDesign uses during a data merge. It usually comes from a spreadsheet or database, but you can also create one using InDesign or a text editor. Each row represents a complete record, and each column represents a specific field, such as a company name or address. InDesign reads this structure to populate your document with different information for each version.

Structure and format requirements

Save data source files as comma-delimited (CSV), tab-delimited (TXT), or semicolon-delimited text files. In these files, paragraph breaks separate records, and commas, tabs, or semicolons separate fields. You can also include text or file paths that point to images on disk.

Fields and records

Each row represents a complete record, and each field is separated by a delimiter. To include a comma or quotation mark inside a field, enclose the text in quotation marks. You cannot insert a line break within a field. If the content spans multiple lines, create separate fields such as <<Address1>> and <<Address2>>.

Blank lines during merge

Select Remove Blank Lines For Empty Fields (Window > Utilities > Data Merge > Content Placement Options) when merging to prevent empty lines. A line is removed only if it's completely empty, even if a space prevents it from being deleted.

Text data considerations

If you want to include a comma or quotation mark in a comma-delimited file, enclose the text within quotation marks, such as “Brady, Hunt, and Baxter, Inc.”. If you don't include the quotation marks, each name is treated as a separate field.