How to use DATA MERGE in InDesign CC 2019

Рет қаралды 216,881

Күн бұрын

Data Merge is a brilliant time-saver feature in InDesign that allows you to automate and batch create variations on a layout. In this video, you will learn how to quickly generate multiple business cards with the names and details of each of the employees of a company using a text file and an Illustrator artwork.
LEARN FROM US:
Build Rock Solid Foundations with our New 12 Weeks long Graphic Design Starter Bootcamp:
yesimadesigner.com/courses/st...
BECOME OUR MEMBER:
/ @yesimadesigner
Check Out My workstations:
1. Desks - cutt.ly/MGtk3J
2. Chiro ergonomic chair - cutt.ly/zGtldM
3. iMac Pro - cutt.ly/ZGtlPw
4. MacBook Pro - cutt.ly/kGtzuf
5. Wacom Intuos Pro pen tablet - cutt.ly/jGtznu
6. The new iPad Pro - cutt.ly/CGtzC5
7. Apple Pencil - cutt.ly/xGtxxl
8. iPad Stand - cutt.ly/GGtx2W
9. Wacom Cintiq pen display - cutt.ly/eGtcko
----------------------------------------------------
Use the Contents below to jump to a specific feature quickly:
CONTENTS:
0:00 Intro
2:05 Placing artwork to InDesign
2:40 Data Merge in InDesign
3:13 Create a Text file
4:29 Data Merge panel
6:12 Preview your data
6:50 Amend your design
8:46 Create the PDF
10:16 The best thing about Data Merge
BUSINESS CARD DESIGN with ILLUSTRATOR:
• How to Design BUSINESS...
----------------------------------------------------
LEARN FROM US:
Build Rock Solid Foundations with our New 12 Weeks long Graphic Design Starter Bootcamp:
yesimadesigner.com/courses/st...
NEWSLETTER:
yesimadesigner.com/creative-r...
READ OUR BLOG
yesimadesigner.com/blog/?utm_...
FOLLOW US
/ yes_im_a_designer
PODCAST
yesimadesigner.com/podcast/?u...
Apple - podcasts.apple.com/gb/podcast...
Spotify - open.spotify.com/show/2vdeYhJ...
BECOME OUR MEMBER:
/ @yesimadesigner
SmartMockups (Affiliate link):
a.paddle.com/v2/click/19214/4...
ADOBE CREATIVE CLOUD
If you don’t have an InDesign-, or a Creative Cloud subscription yet, you can subscribe to it here:
clk.tradedoubler.com/click?p(...
(*We are partners to Adobe. If you purchase through this link you also support our channel.)

Пікірлер: 154

@pavelalexandru1744 4 жыл бұрын

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

@goldenvox 3 жыл бұрын

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!!!

@franktielemans6624 4 жыл бұрын

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 3 жыл бұрын

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

@isobelakrill2039 2 жыл бұрын

Loving the Red dead 2 references :)

@ValdairLeonardo 5 жыл бұрын

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

@ecmjr 2 жыл бұрын

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!!

@darcybaker2829 4 жыл бұрын

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

@ebicheesex6707 2 жыл бұрын

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

@KarenZachary 4 жыл бұрын

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

@mjsanderson1982 2 жыл бұрын

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

@bartalisgabi8436 5 жыл бұрын

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

@twinibini5727 2 жыл бұрын

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!!!

@TheNancyFancyyy 4 жыл бұрын

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

@KatayoonAhmadi 5 жыл бұрын

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

@YesImaDesigner 5 жыл бұрын

Thank you very much

@helenerouze6791 2 жыл бұрын

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 😄

@itsvisualtruth6864 2 жыл бұрын

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

@stormthor4991 Жыл бұрын

Micah Bell as HR is a genius idea lol

@GFHO 3 жыл бұрын

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!!

@PetraWM1974 4 жыл бұрын

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

@designlowrider 3 жыл бұрын

What a great tutorial. Thanks for making this!

@rubymendezzz 4 жыл бұрын

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

@JustJ0YouKnow 11 ай бұрын

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

@jackmakhubo5389 2 жыл бұрын

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

@rczuczor 3 жыл бұрын

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

@LatfyLatif Жыл бұрын

Very clear instructions! Thank you for sharing!

@annasiko3508 3 жыл бұрын

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

@dragon1719 3 жыл бұрын

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

@preetinarsing4572 2 жыл бұрын

Thank you. This video was very useful!

@Manny_Morales 4 жыл бұрын

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

@johnnyrivex7509 3 жыл бұрын

First thing I noticed :D

@gavinbevan365 3 жыл бұрын

Fantastic tutorial - thanks!

@kellismith7126 5 жыл бұрын

Thank you... very helpful!!

@eugenioolazabal1867 6 ай бұрын

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

@JaylinHorta-sg7ox Жыл бұрын

Thanks! It saves me a lot of time.

@youtubecanal 3 жыл бұрын

Great tip! Thank you so very much!

@user-ql8zk8ow8p Жыл бұрын

super helpfull, thanks!

@Yaroons 4 жыл бұрын

Great tutorial. Thanks!

@sagrenreddy 2 жыл бұрын

Magic! Thank you.

@mographics727 2 жыл бұрын

Woow this is awesome. i love your work and teachings

@aaronservaege3858 Жыл бұрын

very nice and clear video loved it

@GreensTrails Жыл бұрын

Great tutorial, thank you :)

@Djibdjibdjib 3 жыл бұрын

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

@moroco.design 5 жыл бұрын

Awesome!! Thanks!

@AKDesignerVlog 4 жыл бұрын

This tutorial is very usefull Thank you so much!

@muhdyuzir6542 5 жыл бұрын

found the part 2. Thank you !

@copy76vooraluwprint-endruk37 4 жыл бұрын

Thank you Martin i liked the tutorial

@robertbiedermanndesign 3 жыл бұрын

Good video. Thank you!

@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! 😭😭

@lauramendoza5938 3 жыл бұрын

super helpful thanks

@Hubwood Жыл бұрын

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

@kendradingley1229 2 жыл бұрын

SUPER HELPFUL OMG

@ekalavyastudio3706 3 жыл бұрын

Love you Brother, Its very helpful

@givvaz 4 жыл бұрын

Awesome. Thanks. You just save my time

@thughes44 11 ай бұрын

Brilliant video tutorial. It saved my sanity.

@Reizeroworldnoyume 2 жыл бұрын

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

@Mona1930 5 жыл бұрын

very helpful!

@minhthu-et8cs 3 жыл бұрын

Thanks for sharing

@jempossible5879 4 жыл бұрын

Thanks alot!! x

@0oopssorry 4 жыл бұрын

This tutorial is simply amazing. Thank you so much! Good luck!

@zohirulislam6956 3 жыл бұрын

Wow i think this will very helpful for every designer.

@mrinmix_online 2 жыл бұрын

Sir you are great 😊

@Nivenization 4 жыл бұрын

Thank you.

@jpjain4517 2 жыл бұрын

wow really good stuff video

@liziehomeremedies 2 жыл бұрын

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

@rajilaldr 4 жыл бұрын

great thank you😘😘😘😘

@mohammadarafa9478 3 жыл бұрын

you saved my life bro

@tomramzul 3 жыл бұрын

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 3 жыл бұрын

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 😉🙌

@TheSec09 Жыл бұрын

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

@fahmiafrizal7395 5 жыл бұрын

thank you :)

@nithin84 Жыл бұрын

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

@gusstheodoridis4646 4 жыл бұрын

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!

@luisavalencia3186 Жыл бұрын

2023 and it's still brilliant!

@irenerequena55 3 жыл бұрын

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!!!

@okami6749 2 жыл бұрын

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

@MrPeterbuma 3 жыл бұрын

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?

@SunnySunny-tw7nq 5 жыл бұрын

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..

@Herohector 3 жыл бұрын

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

@benjaminpastrana9662 4 жыл бұрын

Great💪🏼

@FilmFactry 5 жыл бұрын

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!

@SigKappel 4 жыл бұрын

Your Awesome Thanks Martin

@YesImaDesigner 4 жыл бұрын

You are very welcome Sig!

@mistergrr 4 жыл бұрын

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!

@Tone-Oz 2 жыл бұрын

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

@YesImaDesigner 2 жыл бұрын

Glad I could help 🙌

@sheikhmuhammadadnan3 5 жыл бұрын

very nice dear

@nikhileshutpat423 4 жыл бұрын

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

@byr98457yv47yoqo38iv 4 жыл бұрын

Michah Bell the HR guy. OMG LOLOLOLOLOLOLOLOL

@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?

@junaidsiddiqui5864 5 жыл бұрын

I have the excel file which inclued images too, do i merg them directly by this feature

@jennykim8471 3 жыл бұрын

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

@johnnyrivex7509 3 жыл бұрын

got a like in the first 15 seconds as you used RDR2 references as sample names

@Cipkrea 5 жыл бұрын

can you cover some of the other menus in the utilities? a lot of other people cover the more "fun" parts of indesign but i still feel like i dont know what a lot of menus are because theyre so utilitarian

@rajbharadia3643 3 жыл бұрын

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.

@boeyudhistira75 2 жыл бұрын

Excellent! listen, I have a plan

@JacobZiggy 2 жыл бұрын

legend

@PostyshevsBureau 4 жыл бұрын

Спасибо! Даже без знания английского языка всё понятно.

@saaj_uk 3 жыл бұрын

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

@javadahmadi 3 жыл бұрын

Excellent video. How do you link 10-15 Excel/CSV files with different layouts (columns and rows) inside InDesign? It is a product price list, which gets updated frequently. Thanking you in advance.

@missiondisrupt1333 4 жыл бұрын

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?

@ShoreLarkByTheSea 3 жыл бұрын

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.