Using the Data Merge panel in InDesign, you can easily create multiple variations of your document by merging a data source file (CSV or TXT file) with an InDesign document. For example, use the data merge functionality to create hundreds of variations of letters, envelopes, or mailing labels quickly and accurately. Data merge is also referred to as mail merge.
All you need for data merge is a data source file and a target document.
The merged document is the resulting InDesign document that contains the boilerplate information from the target document, repeated as many times as it takes to accommodate each record from the data source.
A. Data source file B. Target document C. Merged document
Data Merge panel is accessible from Window > Utilities. The name and type of each data field is displayed in the panel. If you have inserted the data fields in your document, the page numbers where the data field is placed is also displayed.
A. Data Merge menu B. Create Merged Document C. Page number where data field is placed D. Preview last record E. Preview next record F. Go to record G. Preview previous record H. Preview first record I. Preview records J. Data field type and name K. Data source
1. Make plans to determine which data fields you’ll be using in your source and target documents.
Determine how you want the final document to look, so that you know which fields are necessary to accomplish the merge. For example, if you are creating a postcard that is mailed to customers, you can use the following data fields:
<<Company Name>><<Address>><<City>>, <<State>><<Postal Code>>
Your spreadsheet or database could look like this:
2. Save the data source file—usually a spreadsheet or database file—as a comma-delimited (.csv) or tab-delimited (.txt) text file.
Make sure that your data source file is structured in such a way that you can include the appropriate fields in your target document. For example, the top row of a spreadsheet should contain the field names that you’ll use in the target document, such as “Company” and “Address.”
For more information, see About data source files.
3. Create a target document that includes text and other items that remain the same in each version of the target document.
For more information, see About target documents.
4. Select the data source using the Data Merge panel.
For more information, see Select a data source.
5. Insert fields from the Data Merge panel into the target document.
6. Preview the records to make sure that the target document will look the way you intend.
For more information, see Preview records in the target document.
7. Merge the target document with the data source file, or export to PDF.
For more information, see Merge records.
The data source typically originates from a spreadsheet or database application, but you can create your own data source file using InDesign or any text editor. Data source files should be saved in a comma-delimited (.csv) or tab-delimited (.txt) text format. Check your source application’s user guide for more information on exporting to these formats.
In a comma- or tab-delimited text file, records are separated by paragraph breaks; fields are separated by commas or tabs. The data source file can also include text or paths that see images on disk.
Example of comma-delimited data source file
Name,Company Name,State Bill Tucker,CoreVent Labs,Nevada Dat Nguyen,"Brady, Hunt, and Baxter, Inc",Delaware Maria Ruiz,"Brinquist Enterprises, Inc.",California
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 do not include the quotation marks, each name is treated as a separate field.
You cannot insert a line break within a field in the data source file. If it’s necessary to split a field across different lines, create two different fields, such as <<Address1>> and <<Address2>>.
You can choose Remove Blank Lines For Empty Fields when merging the document to prevent empty lines. However, if any characters, including spaces, appear on the line, the line is not deleted.
By adding image fields to the data source file, you can allow a different image to appear on each merged record. For example, when you merge documents that include information from various companies, you can include an image of each company’s logo as part of the merge.
The @ symbol is required only in the first line; subsequent lines should include the image paths. Paths, which are case-sensitive, must follow the naming conventions of the operating system in which they’re stored.
If you get an error message when you type the @ symbol at the beginning of the field, type an apostrophe (') before the @ symbol (such as '@Photos) to validate the function. Some applications, such as Microsoft Excel, reserve the @ symbol for functions.
(Windows) Example of image references in data source file
(Mac OS) Example of image references in data source file
You can use InDesign to view the path of an image on your operating system. Insert an image in an InDesign document, and then use the Links panel to view the image’s location. With the image selected, choose Copy Info > Copy Full Path from the Links panel menu. You may need to edit the path after you paste it in your data source. This technique is especially useful for images on a server.
Once your data source file is created, you need to set up the target document and insert the fields from the data source file. The target document contains data-field placeholder text and graphics, such as the design that you want to appear on every postcard. These fields become available to add after you select a data source.
When you merge data, InDesign creates a new document that replaces the fields with the data you designated in the data source file. You can place data fields on either a master page or a document page.
Before you insert fields into your target document, select a data source in the Data Merge panel. You can have only one data source file selected per target document.
Choose Window > Utilities > Data Merge.
Choose Select Data Source from the Data Merge panel menu.
To change delimited text options, select Show Import Options.
InDesign automatically detects the type of delimiter and encoding used in the data source file, so showing the import options usually isn’t necessary. However, you can specify different encoding and delimiter options if you think they haven’t been correctly identified.
Locate the data source file, and click Open.
If an alert message indicates that it cannot open the file, or if incorrect fields appear in the list box, you may need to edit the spreadsheet or database file and save it as a comma-delimited or tab-delimited file.
Once the data source is selected and fields are loaded in the Data Merge panel, any changes made to the data source are not reflected in the target document until you update the data source.
When you select the data source, a list of data field names appears in the Data Merge panel. These names are identical to the column heads from the data source file. Icons indicate whether the field is text or an image. When data fields are added to your document, they become field placeholders, such as <<Company>>. You can select and format these placeholders as you would any other text or graphic.
You can assign an image field to an existing frame to create a floating image. Or, if the insertion point is in a text frame or if text is selected when you insert an image field, a small placeholder is inserted as an inline frame. You can resize the image placeholder to determine the size of the merged images.
Once you insert a data field, InDesign remembers its data source. Any errors in the list of fields, such as typos, empty fields, and unintended field types, must be corrected in the source application and then updated using the Data Merge panel.
If you’re adding data fields to a master page, see Adding data field placeholders to master pages.
Click a field in the Data Merge panel list.
Drag a field name from the Data Merge panel list, and drop it onto the text frame to add the placeholder. If you drag a text field onto an empty frame, the empty frame becomes a text frame.
Text field placeholders appear in the target application within double angle brackets (such as <<Name>>) using the current formatting attributes (such as font and size).
You cannot create a valid field by simply typing the field name or editing an existing field. You must insert it from the Data Merge panel.
Image field placeholders appear as frames containing the field name.
You can integrate a QR code in the merged document. Following are the different types of QR code fields that can be added via a Data Merge workflow:
To generate the QR codes the data entries in the .txt or .csv files, which are used as Data Source, are in the following format:
Though the data entries can be a mix of email, sms, hyperlink, or plain text type. Enter them in the .csv and txt field in the above mentioned format with a # sign on their column name. To generate QR codes, follow these instructions:
Select Windows > Utilities > Data Merge.
From the flyout menu, select Select Data Source.
Select the data file with the QR field information. Click Open.
Select the placeholder in the document.
Click Create Merged Document icon to create a merged document.
If you insert data field placeholders on master pages, you have advantages that are not available when you insert placeholders on document pages:
The resulting merged document contains the original placeholders on its master pages and includes the merged results on document pages as overridden master page items.
The merged document maintains a connection to the data source, so if records in the data source are modified, you can update the merged document contents by choosing Update Content In Data Fields. This option is especially helpful if you change the layout in the merged document and then need to add new data from the data source.
The settings in the Create Merged Document dialog box are the same as those used in the target document, so you can quickly re-create the current document with the same appearance. You can also use these shared settings to create an identical document with a different data source, or create a new document with a slightly modified layout.
If you’re adding data fields to a master page, make sure that the text frame containing the data fields allows master item overrides. Select the text frame on the master page and choose Allow Master Item Overrides On Selection from the Pages panel menu. If this option is not selected, the data will not be merged. (See Create masters.)
You cannot place data fields on both master pages and document pages. To merge properly, you must apply a master containing data fields to the first page of the document.
If an error message indicates that InDesign cannot merge the document because no placeholders are present, you may have added the placeholders to the left master page in a one-page document. Page 1 is based on the right master page, so add the placeholders to the right master page.
The changes will be reflected in the Data Merge panel. If the changes are not reflected in the document after updating, deselect Preview to turn it off, and then select Preview again to turn it back on.
If you generate a merged document from a target document in which data fields appeared on master pages, you can update the data fields in the merged document.
Before you merge the target document and data source file, it’s a good idea to preview the records to make sure that field data will appear properly when the information is merged. When you preview records, the Data Merge panel displays actual data from the data source file instead of the field placeholders. For example, instead of seeing <<Company>>, you might see Adobe. You can use the navigation buttons on the Data Merge panel to cycle through the records.
If you find problems with any of the records, such as typographical errors or extra spaces, it is recommended that you edit the source file in its original application. (See About data source files.)
Click Preview at the bottom of the Data Merge panel, or choose Preview from the Data Merge panel menu.
To go to a specified record, click the navigation buttons at the bottom of the panel. You can also type the number of the record you want to preview in the navigation text box at the bottom of the panel, and then press Enter or Return.
Some issues may arise or correct themselves when you switch between previewing modes. Keep the following in mind:
Placeholders replace the preview content when the Preview Record option is not selected. If you delete an image as well as the frame containing the image, or delete a whole text string, when you deselect the Preview Record option, the placeholders will not appear as they have also been removed.
Changes in the Content Placement Options dialog box are not reflected until you click OK. Also, if the Preview Record option is selected, the data will not reflect the updated placement settings until you deselect and select the option again.
If you try to save the document in preview mode, you will receive a message prompting you to turn off preview mode before saving your document.
When you add a text data field to a document, the placeholder text for the field is entered using the formatting attributes (such as font and size) active at the insertion point. You can then edit the placeholder text’s attributes to control the look of the actual data.
To change placeholder attributes, select the placeholder text, and then change the formatting attributes as you would with other text.
To change a placeholder, select the placeholder or the actual data, and select a different field name in the Data Merge panel.
To delete a placeholder, select the placeholder and press Backspace or Delete.
In Story Editor view, text placeholders are displayed in the same way as hyperlinks. Some Data Merge panel options are not available in Story Editor view.
Use the Content Placement Options dialog box to specify the default settings for the current document or for all future data merge projects. You can specify how the image is placed, whether images are linked or embedded, whether blank lines are removed for empty fields, and the maximum number of records for each merged document.
To affect only the current document, open the target document.
To affect all future documents you create, close all documents.
Choose Window > Utilities > Data Merge.
Choose Content Placement Options from the Data Merge panel menu.
After you format the target document and insert fields from the data source file, you’re ready to officially merge the information from the data source with the target document. You can merge the records to another InDesign document or directly to PDF. When you merge, InDesign creates a new document or PDF based on the target document, and replaces the fields in the target document with the appropriate information from the data source file.
When you merge a document that includes data field placeholders on master pages, those master page items will be copied into the master pages in the newly generated document.
Choose Create Merged Document from the Data Merge panel menu, or click the Create Merged Document button .
Choose Export To PDF from the Data Merge panel menu.
On the Records tab, for Records To Merge, select All Records to merge all the records in the data source file, select Single Record to merge a specific record, or specify a Range of records to merge.
For Records Per Document Page, do one of the following:
Choose Single Record so that each record starts at the top of the next page.
Choose Multiple Records to create more than one record per page. (For example, to print mailing labels.)
You cannot merge multiple records if the data fields appear on a document page in a document with multiple pages, or if data fields appear on multiple master pages.
Select Generate Overset Text Report With Document Creation to automatically open a report that tracks overset conditions created during the merge of the data into the InDesign document. (See Overset text reports.)
Select Alert When Images Are Missing to display a missing link alert when one or more images are not available.
If you selected Multiple Records on the Records tab, click the Multiple Record Layout tab, and specify the following:
For Margins, type values to specify the distance between margin guides and each edge of the page.
For Layout Of Records, select either Rows First or Columns First, and then specify the spacing between the columns and rows.
If you selected Multiple Records, select Preview Multiple Record Layout to review changes made in the Create Merge Records dialog box. You can click the Page buttons to navigate the records.
When you’re finished, click OK.
If the data source file points to any unsupported file formats or images that are not available, you may need to correct the data source file to point to a supported file, correct the path to any missing file, or simply move the file to the correct folder so that InDesign can find it and place it.
You can choose Multiple Records to create more than one record per page. For example, if you are printing mailing labels, you want to print more than one label per page. The way records appear in the merged publication depends mainly on the layout options. Here is a list of limitations you might encounter when using the Multiple Records option:
You cannot merge multiple records if the data fields appear on a document page in a document with multiple pages, or if data fields appear on multiple master pages.
The Data Merge allows for only one size of place holder.
Deleting a record in the merged publication will not reflow the remaining records into the empty placeholder.
When you merge to a PDF file, all the options are the same as when you create a merged InDesign document. The resulting PDF takes advantage of PDF XObjects for the static parts of the page, resulting in a reduced-size, efficient PDF.
After merging a document with data placeholders on master pages, you can change the layout of the merged document and still update the values of data fields in the data source. Use the Update Data Fields to update the data fields while maintaining the layout of the document. This option is available only in a merged document in which data placeholders appear on master pages.
The changes that have been made by updating the data fields appear in a log file.
This option works best when you simply edit or add records in the data source file. If you add placeholder fields, add new fields to the data source, or change the settings in the Create Merged Document dialog box, use the Create Merged Document option to generate a new merged document.
The Overset Text Report appears if the Generate Overset Text Report option is selected in the Create Merged Document dialog box, and if one or more fields include overset text after the data is merged.
The report displays each overset instance in a numbered list showing the page number the text appears on, overset character/word count and a snippet of the overset text.
If the report appears when you create a merged document, use the report to fix the overset condition. For example, you may want to increase the text frame size, decrease the font size, or edit the text.
The following options appear in the Content Placement Options dialog box:
Fit Images Proportionally
Maintains the image’s aspect ratio but scales the image to fit within the frame (default).
Fit Images To Frames
Scales the image so that its aspect ratio is identical to the frame’s aspect ratio.
Fit Frames To Images
Preserves the image size but adjusts the frame size to match it.
Preserve Frame And Image Sizes
Places the image at its intrinsic size into the frame, aligned to the upper-left corner of the frame. The image is cropped if too large for the frame.
Fill Frames Proportionally
Places the image so that its height or width fills the frame, leaving the rest of the image cropped.
Automatically fits an image inside the frame based on the image content and frame size.
Center In Frame
Aligns the center of the image to the center of the frame. This option is disabled if you have selected Content-Aware Fit as the fitting option.
Creates a link, or file path, to the original image file. If this option is not selected, all image data is embedded in the InDesign document.
Remove Blank Lines For Empty Fields
Remove paragraph returns inserted for empty fields. This is especially useful for mailings in which you have an optional address field. This option ignores soft returns. If any characters, including spaces, appear on the line, the line is not deleted.
Record Limit Per Document
Specifies the maximum number of records for each merged document. When this threshold is reached, a new document is created. This document has the number of pages necessary to hold the remaining records being merged (up to the per-record limit). This option is available only when Single Record is selected.
Page Limit Per Document
Specifies the maximum number of pages for each document. When the threshold is reached, a new document is created with the number of pages necessary to hold the remaining records being merged (up to the per-page limit). This option is available only when Multiple Records are selected from the Records Per Document Page menu when merging.