Skip to main content
Share Your Experience: Take the 2024 Developer Survey
4 votes

How to make 150+ certificates, each with a different name

Use InDesign for this. Link the PSD in InDesign as a background image, and overlay the names from a CSV list, which should be typed in the format below. Then use Data Merge to set up importing the ...
Lucian's user avatar
  • 29.3k
4 votes

Faster merge software than Indesign Data merge

You can operate on the PDF file, there are software that can merge pages in a PDF. This is fast as its basically just a append operation to the PDF file. (you can do this with a text editor if you ...
joojaa's user avatar
  • 58k
4 votes
Accepted

Indesign data merge not working with special characters

Found the solution here. The trick was changing the encoding on the .csv to UTF-16
iicaptain's user avatar
  • 163
3 votes

InDesign combines all csv separated columns as one field in data merge

Your problem is that Excel uses semi-colon separators when InDesign looks for comas. Prefer tabbed text format on export and everything will be fine ;)
Loic's user avatar
  • 701
3 votes

Indesign Catalog with data merge

This is quite technical and not possible using the built-in Data Merge logic. By default, Data Merge will only work with a specific number of table rows, and does not create 'as many table rows as ...
Lucian's user avatar
  • 29.3k
3 votes
Accepted

When printing layout page it does not show the actual cards

You need to use the Create Merged Document feature for the actual data to be pulled from the CSV into the Data Merge fields and baked into a new file, which can then be: distributed in a grid as ...
Lucian's user avatar
  • 29.3k
2 votes
Accepted

How do you save each file created by Indesign Data Merge

There's scripts and plugins you can get to do this within InDesign but it doesn't do it (to my knowledge) natively. I don't bother with scripts or plugins and instead will just open the PDF in Adobe ...
Ryan's user avatar
  • 23.1k
2 votes
Accepted

Why does Indesign combine my csv columns into a single entry, when data merging?

CSV is comma-separated values. On some windows machines (when win is not English) the comma is changed with semi-colon. And in the result csv files are exported with ";" in place of ",". You can ...
SZCZERZO KŁY's user avatar
2 votes

Why does Indesign combine my csv columns into a single entry, when data merging?

No it's because InDesign looks for commas as a separator while Excel will use a semi-colon. Prefer Tabbed Text as export format. InDesign will like this better ;)
Loic's user avatar
  • 701
2 votes

Faster merge software than Indesign Data merge

InDesign indeed is not performing enough with such huge documents. Once that said, you can think of a script that will generate documents one record at a time. But given the extensive amount of ...
Loic's user avatar
  • 701
2 votes

Conditional text in InDesign data merge

The easiest solution is to create another column in your CSV/Excel to include the word "and" if the Spouse field has data. In your Excel file: Row | Column A | Column B | Column C 1 | FirstName | ...
dpruth's user avatar
  • 121
2 votes

Conditional text in InDesign data merge

You would just use conditional text. Choose Window > Type & Tables > Conditional Text to display the Conditional Text panel. Then choose New Condition from the Conditional Text panel menu, and ...
Stegathesaurus's user avatar
2 votes

Data Merge fouling up Single Quotes

Your text file is probably non UTF-8 encoded. Re-save your source file in UTF-8 and it should be fine.
Loic's user avatar
  • 701
2 votes

Indesign - How to create a conditional space between fields in a data merge

Alternatively, you can use a GREP style to make this "conditional space" visible or not. Please note this workaround would work assuming your paragraph starts with "Title" or "Name", otherwise we ...
Vinny's user avatar
  • 4,593
2 votes
Accepted

Batch Saving Data Sets - Illustrator Error on Data Set Change

The complete code is: #target illustrator function test () { var doc = app.activeDocument; function cycleUpdateAllDatasets (doc) { for (var i = 0; i < doc.dataSets.length; i++) { var ...
Silly-V's user avatar
  • 1,906
2 votes
Accepted

InDesign / Delete entire line if field is empty

Include the $ symbol in Excel or whatever program you use Make sure "Remove blank lines for empty fields" is selected in the DM options Create two paragraph styles for "amount" and "date". Set them as ...
Vinny's user avatar
  • 4,593
2 votes

Inserting Dates Using Paragraph Style

I don't think that you can do it they way you are attempting. you can however do a data merge with the correct spreadsheet. I do a lot of calendars and I set this up a few years ago. I can set you ...
Alith7's user avatar
  • 1,630
2 votes
Accepted

InDesign: Create a flipbook-style effect with a custom image on each page using parent pages?

You could script this, but for just a single go, I think it would be easier to do this semi-manually, roughly as described in Scott’s comment to the question. Since you say you already have all the ...
Janus Bahs Jacquet's user avatar
1 vote

Merging layers with various blend modes

Try doing the same at 100% zoom. Then you should see what you expect. The dissolve blend mode can be a little tricky. It is not anti-aliased when you zoom out. When you merge the layers the actual ...
Wolff's user avatar
  • 21k
1 vote
Accepted

Indesign Data Merge. Manipulate single Target File From Master Document without creating Individual .indd.

AFAIK The only way to perform this automatically is to create a new column for this specific case, and apply a different paragraph style to this data field. Not sure it's less time consuming than ...
Vinny's user avatar
  • 4,593
1 vote

How do I format a URL image link in my tab-delimited data file to data merge with InDesign templates?

One of these tools is MyDataMerge- easy data merging and it can pull images from Web URLs automatically. Its a paid but rather cheap solution with hell a lot of features. If you are regular data merge ...
Pat_Morita's user avatar
1 vote

data merge not generating multiple records. Repeats one throughout

Not specific enough i guess. Data Merge can be a little tricky and the slightest thing can make it go wrong. Look for any tabs, blank lines or hidden characters in your CSV. Most likely a data source ...
Lucian's user avatar
  • 29.3k
1 vote

Variables and Data Sets in Adobe Illustrator

If you are looking to do multiple business cards you are actually better off using InDesign's data merge. I would only recommend using Illustrator's variables if you need to make variable graphs. ...
Kasandra Murray's user avatar
1 vote

InDesign: images using Data Merge

InDesign often struggles with pathes in CSV. For Mac we work with MyDataMerge (https://mydatamerge.com) which is a drag and drop interface for Indesigns data merge. But if you want to do it manually ...
Pat_Morita's user avatar
1 vote
Accepted

How to set the background color by data source?

I read this article as of late which deals with this subject. https://indesignsecrets.com/applying-any-cmyk-color-during-a-data-merge.php Some quotes from the article: What’s required for this ...
Silly-V's user avatar
  • 1,906
1 vote

Create multiple playing card designs with variable text data

InDesign uses the Data Merge feature to pull text from XLS/CSV files and overlay this on top of an existing master artwork. So you have a 1-page InDesign file which is the actual card background ...
Lucian's user avatar
  • 29.3k
1 vote

how to populate only complete data with easy catalog

You have many options. The one that suits you depends on your layout expectations. Using Conditional Processing in text : @@if {checkLength} = ‘‘@@A@@else@@B@@endif@@ Would require a custom field (...
Loic's user avatar
  • 701
1 vote

Mapping Excel data with id’s into InDesign

I don't know if that will suit you but If you want to keep track of data in order to easily updates changes in the layout, I would recommend looking at a plugin like EasyCatalog. It can load Excel ...
Loic's user avatar
  • 701
1 vote
Accepted

How to auto delete a space left after a data merge in InDesign?

Are you sure those spaces exist in your CSV file? They shouldn't. Did you not manually added the spaces between the fields? Like this: (dots represent spaces) <<Firstname>>.<<...
Vinny's user avatar
  • 4,593
1 vote
Accepted

Datamerge - Excel to Indesign

This is very typical. Indesign expects your CSV fields to be comma separated. BUT... depending on your regional settings, Excel might export CSV with a semicolon as separator. Errr... we are not (...
Vinny's user avatar
  • 4,593

Only top scored, non community-wiki answers of a minimum length are eligible