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 Brush

Freebie: Style Inspiration

Freebie: Lettering Guides

Freebie: Vector Laurals

Freebie: Watercolor Texture Kit

Freebie: Corner Bakery Font

Freebie: Hand Drawn Numbers

Freebie: Procreate

Freebie: Procreate Signature Brush

Freebie: Hand Drawn Dividers

Freebie: Ink Texture Pattern

Freebie: Birthday Tags

Freebie: Birthday Card

Freebie: Vector feathers

Freebie: Rustic Greeting Card Mock-up

Freebie: Procreate

Freebie: Procreate Mono Weight Brush

Freebie: Mini Grit Textures

Freebie: Todo List

Freebie: Ink Texture Kit

Freebie: Bullet Journal Kit

Freebie: Shirt Mock Up

Freebie: Watercolor Florals Kit

Freebie: Photoshop Patterns

Freebie: Procreate

Freebie: Modern Resume

Freebie: Hand Drawn Border Frames

Freebie: Hand Drawn Numbers
Written by
Every-Tuesday designer + founder. I help ambitious graphic designers and hand letterers level-up their skills and creativity.
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