How do I bulk import data from Excel into InDesign?

Today's tutorials are especially practical, what if you want to bulk export the contact data in Excel in a hundreds of-person enterprise? Today Liu Yuanhai share a very convenient way to collect >>>

Liu Yuanhai: Here's a chestnut: I'm now a new clerk at the Navy headquarters, and I want to make a bunch of warrants.

Yes, that's it.

First we need to make sure that there is something on hand, a table of several people's heads and related data.

In the table above the head of the column, note that you want to add a @ in front of the title, this is the meaning of the path. The following content is the head of the corresponding location path.

(Age what ghost? Roar, do not care about this detail, the hermit has its own magical uses)

OK, save this form a TXT document (note that you want to select the Unicode encoding format because InDesign can't read the other)

(Note: CSV format can also, just want to note that the encoding if the Unicode format, the effect of the same, not much to say.) )

All right. Begin.

1. Create a new document in InDesign, size depends on the size of your own poster. On the homepage we link in the background.

Yes, slightly optimized a little bit better than the original, hehe

2. Let's start with the window--utility--Data merge, bring up the data merge panel.

I use the CC version, the other version of the translation may be a little different, to find their own bai.

3. Menu Here Select, select the data source, load the TXT document just

Loaded into the time is like this, pay attention to see, Avatar there is a picture, the other is the text

(In this step of the wrong students, please turn upside down to see if you are in the Unicode encoding format!)! Unicode encoding Format!! Unicode encoding format!!!)

4. OK, we draw the corresponding position in the picture text box, image frame, the corresponding content dragged in just fine.

Here's the name of the bounty and other text can be directly changed format, adjusted to the font and format you need.

OK, change the next step, we suggest that the text will not be adjusted, you can type, adjust the font after the replacement inserted in the data that.

This is basically finished.