First off, I want to tell you this isn’t the sexiest tutorial you’ll ever watch, but it can be a giant time saver and really make you look like you know your stuff. So, stick with me, because this is pretty handy to know: list format data merge in InDesign (sorry if that was a little eek-worthy to read, but you were warned 😉 ) To accompany our save the date postcard from last week, this week we’ll create a wedding seating chart to go with the big day. Traditionally, data merge is used to automate large amounts of data into multiple pages, but it’s different here: we’re placing lists of data onto one page, so there are a couple small tweaks that need to be made. I promise this is super simple and you’ll be glad to have this in your designer arsenal when you see what it can do.

Pin it for later!

create a wedding seating chart using data merge in indesign

Create a Wedding Seating Chart using Data Merge in InDesign

Mentioned in this video:

If you haven’t picked up your free watercolor florals mini kit yet, you can grab it by clicking the graphic below (If you’re an Every-Tuesday subscriber, pick it up in the resource library)


watercolor florals mini kit

tuesday tips

Here’s the written outline of the tutorial, in case you need to reference it in the future:

  1. Create your design in Illustrator or Photoshop. In Illustrator, save it as a jpg by going file > export > export as. Choose jpg as your format and check the box for ‘use artboards’. Select a quality of 10 and input a resolution of 300 if you plan to print it.
  2. Create a new document in InDesign the same size as your layout in Illustrator or Photoshop. File > place in the jpg you just created. Create text boxes for your different data areas and apply the attributes you’d like to your text (color, alignment, font, etc).
  3. In Excel, format your data so that each list of data appears within the same cell. Separate list elements by using a symbol that doesn’t appear in any of your names. Do not put any spaces around the symbol. Save your excel document as a csv file.
  4. In InDesign, open your data merge panel (window > utilities > data merge). Select new data source and choose the csv file you saved. Select each text box and apply the cell’s title to each location. Hit the preview checkbox to see how your data will appear. When you’re happy, hit the create merged document icon located within the data merge panel.
  5. Once your document has been merged, go to edit > find/change. In the panel that shows up, in the ‘find what’ field, type the symbol you used to separate your names in excel (I used ‘#’). In the ‘change to’ field, toggle down the @ symbol and choose ‘End of Paragraph’. Hit ‘Change All’ and then hit ‘done’.
  6. Check over your work and preview if you’d like. Save your wedding seating chart file, print and done!

Download your free watercolor florals mini-kit!

Bonus!

Where should we send your watercolor florals kit?

confetti
confetti

Receive special offers on courses + products, a new design file every month plus instant access to the Resource Library!

Tuesday Tribe Gift bag

Pick up over 50 design + lettering files as our gift to you when you join the Tuesday Tribe for free!

error

Congrats!

Please check your email to confirm.


Freebie: Procreate

Freebie: Procreate

Freebie: Procreate

Freebie: Procreate
Written by
Every Tuesday's content creator and founder. I help creatives build and improve their digital skills to open new opportunities.
Latest comment
  • Teela,

    Once again, you have saved the day!

    Thanks so much. This is perfect. So much easier than what I was doing.

    I really appreciate it!

LEAVE A COMMENT

GDPR Agreement
Save my name, email, and website in this browser for the next time I comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

GDPR Icon

Your Privacy Matters

We use cookies to customize and create content that’s most important to you. We’ll never share the info we collect.

View Privacy Policy