InDesign Data Merge

Question

Hello!I am attempting to do a simple 2 column data merge for a list of employers and table numbers at a career fair. I recieved the xlsx document which I have turned into a csv and a tabbed txt. Neither option worked. When I select the source I choose the Import options (no combination changes the result here either) and it shows the file in the links but in the Data Merge panel there are no fields to use and it acts like I have not selected a source. Any help would be greatly appreciated!

Migintosh · Answer

I'd first try to see if InDesign will do a data merge at all, and if it does, then there's something about the data file that's problematic. You can make a simple text file like this:

a<tab>b<tab>c
1<tab>2<tab>3
4<tab>5<tab>6
7<tab>8<tab>9

…(use an actual tab instead of my placeholer, btw). Your data fields should be a b and c, and the data will be 1 2 and 3 for the first record, 4 5 and 6 for the second, and so on.

If that works, try converting your tabbed text file to plain text and see if that works. It should, but post back if it doesn't. If it does work, let's look at the xlsx file.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded