How to use DATA MERGE in InDesign CC 2019

[@pavelalexandru1744]

Bro, you saved 10 hours of my time every 2 months BIG BIG LIKE!

[@franktielemans6624]

Data merge saved me lots of time when I had to create 219 cards for boardgame It was a kind of trivial pursuit-like game with multiple choice questions... The way I did it was: I created 2 answer fields (correct & wrong) exactly on top of eachother for each answer. The excel file had 8 columns: question, answer1_correct, answer1_wrong, answer2_correct, answer2_wrong, answer3_correct, answer3_wrong, explaination. When the first answer was correct, the good answer went in the answer1_correct column, answer1_wrong column stayed empty, the answer2_correct also stayed empty, answer2_wrong had the second (wrong) answer, and so on... I created an excel file with some examples and I explained how it worked and when I received the excel file, it was like magic. 219 cards generated in 1 click.

[@ajcoopa]

Excellent tutorial. Very clear and easy to follow, and professionally presented. Going to save me a LOT of time.

[@ecmjr]

Thanks for the video! You just saved me hours of cutting and pasting. 44 business cards with 6 lines of data each in 15 mins instead of hours! Worthy of a click on the subscribe button!!

[@Hubwood]

Can't believe nobody mentioned the Names you used yet. Brilliant ;)

[@twinibini5727]

Just wanted to let you know your video was so helpful. My and my boss tried to figure out what’s wrong with importing excel sheet file to indesign program to make name tags and your step by step tutorial was SO HELPFUL thank you so much!!!

[@Manny_Morales]

Love the RDR references lol, excellent tut my friend, BIG LIFESAVER.

[@johnnyrivex]

First thing I noticed :D

[@isobelakrill2039]

Loving the Red dead 2 references :)

[@itsvisualtruth6864]

You sir have earned a sub, saved me so many hours filling in over 2000 nametags for my client

[@dragon1719]

Martin is an excellent teacher... sharing info & enhancing our knowledge... So why the hell would some people give a thumbs down???

[@MrPeterbuma]

Question, would you be able to custom the export of the merge to individual PDFs with a unique naming convention using text from your source file?

[@eugenioolazabal1867]

Excellent tutorial. I did it and it seems easy to follow along

[@LatfyLatif]

Very clear instructions! Thank you for sharing!

[@jackmakhubo5389]

Thank you very much for the tutorial, it was clear and easy to follow. I have subscribed and awaiting more cool stuff.

[@goldenvox]

Martin, I love your videos! I have signed up for 3 of your courses online - all of them are extremely worthwhile. You are a wonderful teacher. And I love your designs, too!!!

[@robertbiedermanndesign]

Good video. Thank you!

[@ebicheesex6707]

hey, thank you for teaching this. i usually have a hard time learning, but your way really helped me. appreciate the help and the work you do

[@helenerouze6791]

Thank you so much, I think I'll have to do this tomorrow at the office, so I could impress my colleague and say : yea of course I can do this ! Haha 😄

[@maxjewel22]

Fabulous tutorial. Thank you. One question, I have some addresses that have an address 2 (or even an address 3 line) and others to not. How do you make those extra lines not show for those who don't have them?

[@JustJ0YouKnow]

Thanks for making this super helpful and easy to follow tutorial. Saved me soooo much time creating attendee badges for an event. :)

[@KatayoonAhmadi]

Fabulous tutorial as always! Love your 'to the point' style! Thank you!

[@YesImaDesigner]

Thank you very much

[@tomramzul]

Thank you, you save my life. I need to design a ticket with unique serial number and password. your video help! thank you so much. I pray for your health and well being and may you be granted with billions of dollar

[@YesImaDesigner]

Tom Ramzul glad this video was useful for you and thanks for the good wishes! I'm content with good health but I also don't mind the billions of dollars 😉🙌

[@nithin84]

Hi, I'm Nithin from India, Your tutorial is really excellent and useful, A big thanks for your effort and the video.

[@aaronservaege3858]

very nice and clear video loved it

[@Reizeroworldnoyume]

Red dead Redemption 2's characters' name is a nice detail

[@sinhala-lama-geetha]

Thank you for great video. I have a question: could I merge a set of hyperlinks specifically over a set of image icons with InDesign. I need to merge every unique hyperlink (page of specified garment) with its respective "buy online" icon (buy online) at every page of my garments catalog? expect a reply from you ASAP. Thank you.

[@mographics727]

Woow this is awesome. i love your work and teachings

[@preetinarsing4572]

Thank you. This video was very useful!

[@FilmFactry]

Can you follow up on inserting JPGs? I have a project to print 150 School ID cards. Essentially what you show here but, I would also Like the Photos to Data Merge. Imaging the time savings. Doing 150 imports. Thanks Great series!

[@denhamk]

I’m glad I watched till the end because I learned about “update” data source! Wow. Wish I had known about that two days ago! 😭😭

[@thughes44]

Brilliant video tutorial. It saved my sanity.

[@stormthor4991]

Micah Bell as HR is a genius idea lol

[@TheNancyFancyyy]

Thank you thank you!! This video was a life saver! I didn't know about the data merge feature. Appreciate it!

[@H3ctorV3ctor]

Wish there was a 10X like button for this useful video.

[@Oussama-yb9ck]

thank you very much !!! how do i also add images i tried the @ symbol but it didn't word

[@annasiko3508]

Thank you so much, that is a professional video with very useful informations! Exactly what I was looking for!

[@JaylinHorta-sg7ox]

Thanks! It saves me a lot of time.

[@purnomoarlan2459]

why my csv data can spread like this tutorial in 4:53 ? my data merge show like this

[@rczuczor]

You are a life saver!!! Thank you so much for posting this tutorial!

[@Kolberto1]

Thank you very much Martin. Is there any file type which support Hungarian special letters? I'm in trubble with "á í ű ő ü ö ú ó é" letters. I have used CSV UTF-8

[@GFHO]

Thanks for the great tutorial! I just used it to create and print my Christmas Card Envelopes!, 120 beautifully done and ready for next year too! AWESOME!!

[@TheSec09]

Great video! Happy that you are a Red Dead |Redemption II fan.

[@irenerequena55]

Hi! Lovely video, you literally saved my live and time! I just wanted to ask if there is any to way to export all the pages as Indesign Files but also packaged? Like you do in Photoshop automations. Thanks!!!

[@zohirulislam6956]

Wow i think this will very helpful for every designer.

[@gavinbevan365]

Fantastic tutorial - thanks!

[@RobertShane]

Can I use data merge to change the width of a rectangle or the fill color of an object?

[@mjsanderson1982]

Fantastic walkthrough. You've saved me a ton of time. Thanks!

[@GreensTrails]

Great tutorial, thank you :)

[@almavida9366]

Is this available in older versions of Adobe Indesign?

[@RunaVanbeeck-s7c]

super helpfull, thanks!

[@KarenZachary]

This is AMAZING. Had no idea this feature existed. Thank you!

[@designlowrider]

What a great tutorial. Thanks for making this!

[@Tone-Oz]

Very well explained. Thank you. (EDIT) I should mention, you have just saved my ass. Thanks, pal. All the best to you. Subscribed.

[@YesImaDesigner]

Glad I could help 🙌

[@ShoreLarkByTheSea]

is there any way to step and repeat easily so that numbered form can be cut and stacked? For example, 10,000 letter-sized forms, numbered from 000001 to10000. I would want to generate a 17x11 file so that the forms can be printed 2 up on a sheet, then cut and stacked. You have a great playlist of videos, btw, so I just subbed to your channel.

[@DaveShrein]

Thank you, great explanation! Is it possible to do things with bulleted lists using data merge? Where some entries will have 3 bullets and others will have 4 or 5? Thanks!

[@helenerouze6791]

I would like to know this too. I think it's possible by adding entries and commas? And the bullet in the paragraph style Have to try.

[@sagrenreddy]

Magic! Thank you.

[@darcybaker2829]

LOVE this! Thank you for kindly sharing your knowledge!!!

[@nikhileshutpat423]

Namaste. This was really helpful. Have One Question, with the help of mail merge can I automate flyer too?

[@ValdairLeonardo]

This is so great! And a huge time saver. Thank you so much!

[@deafreitas8663]

I need to make a catalogue with multiple itens at the same page, do you have any tutorials about that?

[@mohammadarafa9478]

you saved my life bro

[@Andrgaev]

Awesome. Thanks. You just save my time

[@turjoturjo7422]

excellent tutorial! can you plz tell me how to data-merge with both sides of a page? how to print on both pages. like I want to print on an A4 page, multiple cards in same pages, and also i want to print the back part of the cards in the back part of page accordingly. so after cutting, I want to get cards that have things printed on both sides of the paper

[@Hands-onNow]

With InDesign can you generate utility bills? The data will be in a .txt file. Can InDesign create a bar graph which shows usage based off the data in the .txt file?

[@ekalavyastudio3706]

Love you Brother, Its very helpful

[@youtubecanal]

Great tip! Thank you so very much!

[@ellizjum]

Every 1,5 years I have to use data merge and every time I stumble on this tutorial couse I can't remember how to do it. Thank you!

[@YesImaDesigner]

Even I have to watch my tutorials from time to time when I forgot how to do something I haven't used for a long time 😆

[@bartalisgabi8436]

Indeed a brilliant feature in InDesign.... Thank you, Martin.... as usual, v. good tutorial

[@jpjain4517]

wow really good stuff video

[@rajbharadia3643]

EXCELLENT TUTORIAL! I have a question... I have a data file with 3000 records, will I end up with a 3000 page Indesign document or is there any other way around it? Please help! Thanks in advance! Love your tutorial and patient voice.

[@mistergrr]

Thank you!! I was trying to do this in Illustrator, but there you have to set actions and export each into its own PDF. This wasn't going to work for my 200 copy batch D: You've saved me hours of time and headaches!

[@jennykim8471]

This is awesome! Can you also do a data merge in Avery label template?

[@rubymendezzz]

You saved my life!!! Thank you. 🙏🏻

[@PetraWM1974]

Thank you so much for your clear explanation! This Data Merge really helps me a lot.

[@luisavalencia3186]

2023 and it's still brilliant!

[@honhon924]

is it possible to use Chinese for the data merge? or a blend of English and Chinese?

[@mehmedtan404]

Is it possible to merge data directly from columns and rows in excel?

[@copy76vooraluwprint-endruk37]

Thank you Martin i liked the tutorial

[@kendradingley1229]

SUPER HELPFUL OMG

[@lkazanov]

What about populating an Avery Template using InDesign? 5371 has 10 slots

[@mrinmix_online]

Sir you are great 😊

[@Djibdjibdjib]

❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️❤️ i know this is saving me tomorrow. Much love. I’m subscribing too.

[@minhthu-et8cs]

Thanks for sharing

[@saaj_uk]

Brother excellent video invoicing has never been easier i can literally transfer 100s of customer records on to a premade invoice template and not even have to do much

[@jaidefinishon]

well, but is possible in InDesign activated "dinamic visibility" with objects than i show on and show off in differents works? illustrator make it possible but i dont find this option in indesign :(

[@Yaroons]

Great tutorial. Thanks!

[@SunnySunny-tw7nq]

Hey Martin as always another great tutorial, Kind Request for your next video tutorial Plz explain InDesign's FIND AND CHANGE Panel in Detail there are options TEXT, GLYPH,GREP,OBJECT Do explain all especially GREP One And all about GREP CODES or other resource's where will get to know how to use it exactly. Thanks..

[@ShoreLarkByTheSea]

2:02 The bane of every Prepress Operator is designers who use Illustrator as a page layout programme. It isn't. Do your vector artwork in Illustrator. Get rid of unused colours in your colour palette. Unless your job is being printed with spot colours, convert all your colours to CMYK. Do your bitmapped graphics in Photoshop, then convert them to CMYK and save them as .tiff or .psd files. NOW assemble your artwork in InDesign and do all your typesetting in InDesign...NOT illustrator. Save it as a press-ready PDF and don't forget cropmarks and .125" of bleed. Better yet, ask your printshop for their colour settings and import them via Bridge into all your Creative Cloud apps.

[@gusstheodoridis4646]

That will save a lot of work for sure! But im interesting in case of that there are some hyperlinks or files (such as icons) need to load instead of simple text. Thank you!

[@umarhussain9334]

does this work with brochures? and the rest?

[@daybydesignplanners9277]

I’ve been on the fence about moving to InDesign. Still not sure.... can you use this feature if your document needs to pull in from 2 data sources? (Page 1-4 from one source, page 5&6 from another with totally different fields, then back to the first?)

[@arafatwasi]

I went with the artboard workflow in the previous video but whenever I am placing (Ctrl + D) the created designs in InDesign the template getting pixelated for some reason. What am I doing wrong?

[@missiondisrupt1333]

Let's say we did a catalog with multiple products (let's say 6), Would we use "Merge multiple records" if we wanted to have all 6 product spots to be different?

[@AKDesignerVlog]

This tutorial is very usefull Thank you so much!

[@shnam928]

Hey Martin, thanks for the good tutorials. Do you have any coupons for your Udemy courses? I need Indesign & Illustrator. Thx.

[@liziehomeremedies]

Love your presentation, easy to follow. will like to see how you can serialize receipts(Numbers) with database clients

[@JordanDias]

Incredible tutorial, wish you could explain till generating pdf.

[@DanielNevesBL]

Can I use a file as one of the data?

[@okami6749]

As always your tutorials are coming in clutch -- saving my ass hours worth of work

[@muhdyuzir6542]

found the part 2. Thank you !