With data merge you can easily paginate text and images in InDesign in a matter of seconds by reading an external data source file in .csv or .txt file format.
Using data merge is not hard at all, but you might need a few attempts to get it. So before jumping in and trying it out yourself, I’d suggest reading the whole tutorial and learning first about the limitations and errors that you may face later.
In this tutorial, I'll show you the basics and then I'll highlight possible issues you might encounter and their solutions, so that you can master this feature in no time.
The basic workflow is:
- Create the data source file—in the first row, name the fields (use @ in front of the field name for images).
- Save the file as .csv delimited with comma, or .txt delimited with tabulation.
- Create a prototype in an InDesign document.
- Select the data source in InDesign using the Data Merge panel.
- Add the placeholders to the prototype design in your document.
- Run a preview to make sure of the result.
- Create the merged document.
Read further in the tutorial to create documents with a structure-layout similar to these:
If you prefer a video guide, see this video by Teela Cunningham. She explains in eight minutes how to create a certificate using data merge. It's great content, explained very well, and Teela’s voice is calm and clear. However, she doesn't talk about data merge with images, so for that (and because this guide goes more in depth), I invite you to keep reading even after you've seen the video.
When should you use data merge?
Data merge is great when you have to lay out a document (or part of a document) that has a "prototype example" (repetitive layout) that needs to be repeated in a grid or one record per page with different data.
Such documents could be:
- product catalogs
- business cards
Prepare the layout of the InDesign file
We need to create a prototype, in InDesign, of the layout we want to use in the data merge process. This is mine. It has the name of the product, its picture, a short description, the price, and a barcode.
Prepare the data file for import (.csv or .txt)
The data source file should be a .csv or a .txt file. You can create it with Excel, Numbers, OpenOffice, or any similar application.
In the first row of the source file you should list all the fields you are going to use in your layout. Make their name descriptive (and understandable) because InDesign will use those name to indicate the sets of data inside its interface.
My file at the moment has
price columns. These are all textual data. To list them you just write the field name, and then fill the records with the data you want InDesign to import.
It’s OK to have empty cells in the body of the file, but make sure that each column has a description in the header row.
Most of the times, images are the single issue that makes you give up on data merge. But if done right, you can make it work and the payoff will be incredible.
Create the field in the spreadsheet
For fields that list images, you need to place an “@“ symbol in front of the field name. The field name should look like this:
@product_image to my spreadsheet.
If you are using Excel, and it prompts you with an error while writing the field name with a “@“ up front, it is because you need to set the Excel cell to text type. Write a " ' " in front of the field name (i.e., "'@field_name") and, when you exit the Excel cell, make sure that you don't see the " ' " you just typed.
Write the source path correctly
The paths of your images must follow the conventions of the operating system in which the images are stored (paths are case-sensitive).
It's OK to have data (like the image names in my spreadsheet) that you won't use in your InDesign as long as you don't leave the header cell empty. It’s also OK to have empty cells in the body of the file.
Getting the source path right
Let's use a quick trick to avoid mistakes and wasting time.
Place in InDesign one of the images you are going to link (the image should be in the folder where you will store the images for the data merge, but it’s not mandatory).
Select the image in InDesign and go to the
Right click and select
Copy Info and then
Copy Platform Style Path.
Here you have the correct source path. This technique is especially useful for images stored on a server, where it can be hard to guess the absolute path.
Save the data source file in .csv or .txt
So, your spreadsheet is now filled with all the data. You should save it in .csv separated by comma file format or .txt separated by tabulation file format.
Import the data source file
In InDesign, open the
Data Merge panel by clicking
Data Merge panel, click on the icon in the upper-right corner, and select
Select Data Source.
Option and check
Show Import Options. Select the file and click
For any error you might encounter, please read the “Errors” part below. If you don't find the error in there (or in the linked resources), please write it in the comments or send me an email—I'll try to help you figure out the issue.
Delimiter and the
Encoding used in your .csv/.txt file and click
Data Merge panel, InDesign has created all the "variables" we previously named in the header of the spreadsheet inside Excel. InDesign indicates text-based data and image-based data with different icons.
Place the placeholders
The next step is placing the placeholders into the layout-prototype we created.
Select the text/image in the InDesign layout-prototype (I select the name of the product).
Click on the placeholder (In my example, I click on
product_name). InDesign replaces the text in the prototype with
It might happen that the characters “<“ and “>” are not visible. If that happens, it's because the font doesn't contain those glyphs. Don't worry, the data merge will work anyway.
Repeat the same process for all the text placeholders (also for the images).
My file now looks like this.
Update the data source
If you forget a field or need to change some data, you can always update your data source. I have to add the barcode placeholder, so I go back to my spreadsheet and add
@barcode to it and fill the data.
Back in InDesign, you can update the data source both from the
Data Merge panel and the
- In the Data Merge panel, click on the icon in the upper-right corner, and select Update Data Source.
- In the Link panel, select the data source file and click on Update Link as if it was an image you edited in Photoshop or Illustrator.
Preview the result
To preview the result of the Data Merge, just activate
The product image is not shown as I wish. I want the content to fit the frame proportionally. If you prefer, you could change the object style (here's the Adobe user guide, just in case you need it). However, I'll let it stay that way—we'll see how to fix it later directly from the Data Merge options.
Look at the price imported from the source data file. The symbol “€” is missing. This might happen sometimes; if you face this issue, try to reimport the data source file and change the
Encoding to Unicode (The default is ASCII).
Create the merge document
Data Merge panel, click on the
Create Merge Document... icon.
You can create a “Single Record” document (left part of the image) or a “Multiple Records” document (right part of the image).
“Single Record” document
This setting is probably the right choice if you are creating certificates, envelopes, letters, etc. With this setting, InDesign will generate a document with each page containing a single record.
“Multiple Records” document
This is my choice in the example. You should use it for product catalogs, pricing lists, and more, in general, for documents that have pages that contain multiple records of a layout-prototype.
“Multiple Records” and then move to the
Multiple Record Layout tab. In this tab you can select how InDesign should arrange the records.
Spacing options are to set how much space you want between the records. I want no space, so 0 on both options is fine for me.
Let's activate the
Preview Multiple Record Layout option.
InDesign shows me a preview. It's almost like I wanted it to be, but I don't like all the white space at the bottom of the page, so I'll change the
Margins options until I get the result I want.
Data merge and images
Under the tab
Options you can give InDesign a few instructions. The most important, though, are the image settings. From
Image Placement you can choose how the image should fit the frame. I choose
Fill Frames Proportionally. I make sure to activate the
Link option, because without it InDesign would embed the images.
Launch the data merge
Now we are ready to launch the merge. Click
OK. InDesign automatically creates a document merging the data source file with the prototype-layout document.
Tables and Data Merge in InDesign
Unfortunately, with data merge you can import only textual data and link to images.
Of course, you can insert placeholders into a table and InDesign will replace them with your data.
However, for the tables you see in my document, I have to import them after the data merge. The best way to create a table in InDesign is by linking an Excel spreadsheet into InDesign. If you'd like to learn how to do that, click here to read the tutorial.
The selected data source has one or more empty field names
If you keep getting this error: "The selected data source has one or more empty field names. Please fix the file or select another file,” it’s because the file (.csv/.txt) you are importing is not clean. There might be some columns in the file that contain some text and that information was deleted manually. You can check that by simply placing the file (.csv/.txt) as a text inside InDesign, and activating "Show Hidden Characters.”
The fastest way to solve this issue is copying all the columns in a new file or using a text editor such as Sublime Text or TextWrangler and cleaning the content of the exported file.
Fields separated by semicolon “;”
If you are using Excel on Windows, this error might be happening because your Windows regional settings are set to use semi-colons instead of commas as the list separator symbol.
The easiest and quickest solution is exporting a tab-delimited (.txt) file, and using that for the data merge.
However, if you want to use a CSV file, you can change OS list separator to “;”. That way, Excel will use “;” to output your CSV file. You can do that in
Regional Settings >
Customize. Be aware that this change will affect all the applications you run on your computer.
For other errors not listed in this guide, see this great piece of an article by InDesignSecrets.
In my example, I imported several barcodes in .eps file format. To create them I used this service. I was looking for a bulk generator but the only one I liked couldn't generate the type I needed. It's great for UPC-A and EAN-13 though.
Data merge is a great feature. It can save you so much time. But sometimes it might be tricky to get it work properly.
Feel free to drop me a comment below.
If you liked the tutorial and found it useful, let others know about this great feature by sharing the article.
P.S: You should subscribe to the newsletter. Click here.