EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 280+ Courses All in One Bundle
  • Login
Home Design Design Tutorials Design Basic Tutorial InDesign data merge
Secondary Sidebar
Design Basic Tutorial
  • Basics and Advanced
    • Pro Tools Version
    • What is Autodesk BIM?
    • Animation Character
    • Autodesk Pixlr
    • Sketch plugins
    • Graphic designer requirements
    • Online Gaming Platforms
    • InDesign eyedropper tool
    • InDesign rounded corners
    • InDesign align
    • InDesign resize image
    • InDesign scripts
    • InDesign export to word
    • InDesign newsletter templates
    • InDesign Magazine
    • InDesign Missing Fonts
    • InDesign line spacing
    • InDesign Fonts
    • InDesign Preview Shortcut
    • InDesign Extension
    • InDesign columns
    • InDesign overset text
    • InDesign data merge
    • InDesign grid template
    • InDesign layers
    • InDesign reset preferences
    • InDesign master pages
    • InDesign layout
    • InDesign portfolio template
    • InDesign invoice template
    • InDesign word count
    • InDesign underline
    • InDesign superscript
    • InDesign presentation templates
    • InDesign drop cap
    • InDesign how to add page numbers
    • InDesign resume template
    • InDesign import pdf
    • InDesign table of contents
    • InDesign change page size
    • InDesign book templates
    • InDesign link text boxes
    • InDesign vertical text
    • InDesign Bullet Points
    • InDesign center text vertically
    • InDesign newspaper template
    • InDesign shortcuts
    • InDesign gap tool
    • InDesign paragraph styles
    • InDesign Grid
    • InDesign margins
    • InDesign highlight text
    • InDesign Wrap Text
    • ZBrush ZRemesher
    • Animation Software
    • Principles of Animation
    • 3d Animation Software
    • 3D Modeling Software
    • 3D Software Design
    • 2D Animation Software
    • 10 Quick Tips For Adobe InDesign Users
    • ADOBE FLASH CS6
    • Affinity Photo Brushes
    • Adobe Lightroom For Free
    • Lightroom Background Color
    • Lightroom?Shortcuts
    • Lightroom XMP
    • Lightroom editing
    • Masking Layers in Adobe After Effects
    • Adobe Premiere Pro Plugins
    • Adobe Speedgrade
    • Install Adobe Creative Cloud
    • Install Adobe Premiere Pro
    • What is Adobe Creative Cloud
    • What is Adobe Illustrator
    • Adobe InDesign Templates
    • What is Adobe InDesign
    • Adobe Indesign Uses
    • InDesign Background Color
    • What is Adobe Lightroom
    • What is Adobe Muse
    • What is Adobe Prelude
    • What is Adobe Premiere Pro
    • Careers in 3D
    • Careers in 3D Modeling
    • Careers in 3D Printing
    • Best Editing Software
    • Video Editing Application
    • Video Editing Tools
    • Career In Designing
    • Careers in Game Development
    • 3D Printing Models
    • Adobe Editing Softwares
    • Types of Adobe
    • Types of Illustration
    • What is Graphic Design
    • Best Graphic Design Software
    • Best Photo Editors
    • Game Testing Interview Questions
    • VFX Softwares
    • Unity Scripting
    • Unity Principle of Design
    • Unity JSON
    • Unity webGL
    • Unity 2D
    • Unity 3D Games
    • VFX Companies
    • How To Use Indesign
    • New Features InDesign CS6
    • What is Houdini?
    • Advantages of 3D Printing
    • What is Autodesk
    • Autodesk Character Generator
    • Autodesk Vault
    • Autodesk Viewer
    • Autodesk Navisworks
    • Autodesk Desktop Connector
    • Designers and Architects
    • 2D and 3D Shapes
    • Keyboard Shortcuts for Premiere Pro
    • Unreal Engine Tutorial
    • Best Audio Editors
    • Digital Image Processing
    • What is Motion Graphics
    • What is Digital Design
    • Design Pattern Interview Questions
    • Graphic Design Interview Questions
    • UX designer Interview Questions
    • Is Unreal Engine Free
    • What Is Design Pattern
    • What is VFX
    • What is Audacity
    • What is Unreal Engine
    • What is CATIA
    • What is Blueprint
    • Sony Vegas Pro for Free
    • 3D Graphics Software
    • Best Online Photo Editor
    • Photo Editing App
    • Vector Graphics Editor
    • ArchiCAD
    • ArchiCAD Shortcuts
    • Audacity Keyboard Shortcut
    • Davinci Resolve Shortcuts
    • What is pixel art?
    • Picmonkey Alternatives
    • Adobe Flash Player Alternative
    • Pro tools shortcuts
    • Pro Tools Plugins
    • Architectural Design Software
    • Architectural Design Principles
    • Architecture Design Types
    • Architectural design tools
    • Application of Digital Image Processing
    • Digital Image Processing Fundamentals
    • OpenGL Versions
    • Revit Keyboard Shortcuts
    • Revit plugins
    • Indesign version
    • What is DirectX?
    • DirectX Versions
    • Cinema 4D Plugins
    • Cinema 4d shortcuts
    • Godot Engine
    • Godot tilemap
    • Krita Animation
    • Krita Software
    • Krita Shortcuts
    • Krita eraser
    • Krita brushes
    • Krita Pixel Art
    • Krita Plugins
    • Skencil
    • Fusion 360 Keyboard Shortcuts
    • Anim8or
    • Affinity photo plugins
    • What is Affinity Photo?
    • FL Studio Plugins
    • Vectorworks
    • Architectural Design Elements
  • Inkscape
    • What is Inkscape?
    • Inkscape layers
    • Inkscape Crop
    • Inkscape text
    • Inkscape G-code
    • Inkscape mirror
    • Inkscape rounded rectangle
    • Inkscape EPS
    • Inkscape image to vector
    • Inkscape unlock
    • Inkscape Curved Text
    • Inkscape laser cutting
    • Inkscape background color
    • Inkscape arrow
    • Inkscape vector
    • Inkscape animation
    • Inkscape 3D
    • Inkscape SVG
    • Inkscape Dark Theme
    • Inkscape trace bitmap
    • Inkscape gradient
    • Inkscape Greek Letters
    • Inkscape shadow
    • Inkscape snap to grid
    • Inkscape Fonts
    • Inkscape extensions
    • Inkscape PNG to SVG
    • Inkscape Art
    • Inkscape transparent background
    • Inkscape Alternatives
    • Inkscape Remove Background
    • Inkscape text to path
    • Inkscape logo
  • Figma
    • Figma Libraries
    • Figma fonts
    • Figma Plugins
    • Figma grid
    • Figma Alternatives
  • SketchUp
    • SketchUp Keyboard Shortcuts
    • SketchUp geolocation
    • SketchUp animation
    • SketchUp Change Dimensions
    • SketchUp Import
    • SketchUp 2D
    • SketchUp rendering
    • Sketch software
    • Figma Shortcuts
    • SketchUp Layers
    • SketchUp landscape design
    • SketchUp group
    • SketchUp intersect faces
    • SketchUp Rotate
    • SketchUp Architecture
    • SketchUp 3D Models
    • SketchUp Vray
    • SketchUp Units
    • SketchUp garden design
    • SketchUp Layout
    • SketchUp Mirror
    • SketchUp Extensions
    • SketchUp Unhide
    • SketchUp kitchen
    • SketchUp background
    • SketchUp library
    • SketchUp dynamic components
    • SketchUp CutList
    • SketchUp Array
    • SketchUp Woodworking
    • SketchUp resize component
    • SketchUp Ungroup
    • SketchUp Deck Design
  • GIMP
    • What is GIMP
    • GIMP Versions
    • GIMP brushes
    • GIMP line tool
    • GIMP blend tool
    • GIMP clone tool
    • GIMP magic wand tool
    • GIMP 3D Text
    • GIMP healing tool
    • GIMP Layers
    • GIMP Fonts
    • GIMP Toolbox
    • Blur Effect in GIMP
    • GIMP Change Background Color
    • GIMP Floating Selection
    • GIMP?batch processing
    • GIMP Crop
    • GIMP Filters
    • GIMP GMIC
    • GIMP?opacity
    • Animation in GIMP
    • GIMP import image
    • GIMP replace color
    • GIMP text outline
    • GIMP video editing
    • GIMP Alternatives
    • GIMP vector graphics
    • GIMP text shadow
    • GIMP resize image
    • GIMP pixel art
    • GIMP invert colors
    • GIMP GIF
    • GIMP move selection
    • GIMP normal map
    • GIMP remove background
    • GIMP rotate
    • GIMP grid
    • GIMP text effects
    • GIMP erase to transparent
    • GIMP resize layer
    • GIMP Patterns
    • GIMP extensions
    • GIMP blur background

Related Courses

Maya Course

Photoshop course

After Effects Course

InDesign data merge

InDesign data merge

Introduction to InDesign data merge

InDesign Data Merge is a very good feature of this software which helps us to create multiple variations of our text data that have unique data set for each entry. You can understand it as mail merge of Microsoft word because it performs the same type of work for our creative Layout. With the Data Merge feature, we can easily create a number of copies of a design layout with each different entry. Here in this software, we have a whole panel of Data Merge with several parameters, which we will manipulate according to our requirements. There are few more things about which you have to know for working with Data Merge. So let us get started.

How to work with Data Merge in InDesign?

For start our learning, i will create a new document page by clicking on Create New button of this welcome screen of InDesign.

InDesign data merge output 1

I will create multiply copies of the Business card using the Data Merge feature of this software, so i will take a Business card template and click on the create button.

Start Your Free Design Course

3D animation, modelling, simulation, game development & others

InDesign data merge output 2

Now i will place an illustrator file here, which i have designed for Business Card. So for that, i will go to the File menu and click on the Place option, or press the Ctrl + D button on the keyboard.

InDesign data merge output 3

I choose my desired file from here. You can place any of the file formats of this list in InDesign.

All in One Design Bundle(280+ Courses, 100+ projects)
AutoCADHoudiniAdobe Premiere ProPhotoshop
SolidworksVFX Visual EffectsCorelDrawUnreal Engine
Price
View Courses
280+ Online Courses | 100+ projects | 2000+ Hours | Verifiable Certificates | Lifetime Access
4.6 (64,914 ratings)

InDesign data merge output 4

This is a design with the EDUCBA logo at the center which i will use as a business card design.

InDesign data merge output 5

Now i will take the Type tool from the tool panel and draw a text box.

InDesign data merge output 6

Now we will open the Data Merge panel and for that, go to the Window menu of the menu bar, go to the Utilities option of the drop-down list, and then choose the Data Merge option.

InDesign data merge output 7

Before start using this panel, i will show you the Data which i will use here as the entry of the business card. I have my data in Notepad. You can use Excel sheets, Google Sheet, Text editor data also as per your choice.

One thing you should keep in mind is that each data which you want to enter separately on the business card should be written with a comma, and first-line should be the title of entry that is in Business card there will be Name of Employee then its Designation then the Phone number and so on. So i have these things in my first line.

InDesign data merge output 8

Then enter the details of employees with commas according to the title, and i have four entries here.

InDesign data merge output 9

Now come to InDesign and click on the top right tab of the Data Merge panel, then click on the Select Data Source option of scroll down list.

InDesign data merge output 10

Choose a file of your data from its saved location in the opened dialog box. You can choose .txt or .csv file format for this purpose. I have a .txt data file here.

InDesign data merge output 11

Now Data Merge will automatically understand the first line of a data text file as main entries and show it in its panel like this. These Entries will be source entries, or you can say them as Master Entries.

InDesign data merge output 12

Now come to the text box which we have drawn before and make click on here, then do to Data Merge panel and click on Name layer so that it will enter in the text box as source text of entries.

InDesign data merge output 13

I will press enter button and then click on the Designation layer because i want this in the next line.

InDesign data merge output 14

I will do the same for the remaining entries.

InDesign data merge output 15

You can see the Preview by click on the check box of the Preview button of the Data Merge panel. Here at the right edge of the text box, you can see a red plus sign that means our text does not perfectly fit in this text box.

InDesign data merge output 16

So we can change the size of the text box for fitting it properly; it will not affect the entries.

InDesign data merge output 17

You can see the next entry by clicking on the next button of the Data Merge panel.

InDesign data merge output 18

Now i will change the font style and color of this Name entry.

output 19.1

output 19.2

And in the Paragraph Style painting in other text entries also.

output 20

Now you can again see the preview. What if you have made any mistake in data like the spelling of John is wrong here. So you need not to go through all steps again.

output 21

Just make corrections in your data sheet and save the change.

output 22

And gain click on the top right button of the Data Merge panel then click on Update Data Source.

output 23

And your made correction will update here automatically. In the same way, you can increase the number of entries. Just add other employee data and update it from the Data Merge panel.

output 24

Now disable preview mode and click on Create Merge Document button of the Data Merge panel.

output 25

And a dialog box for this option will be open. Here in this box, you can choose how many entries of data you want to create. So, for example, you can create a merge document only for a single entry from this option.

output 26

Or decide a range of them from the Range option.

output 27

I will go with all and click on the Ok button of this dialog box, and when i will click on the Ok button, if there is no Overset text, then it will show a message for this that means i can create a merged document without any issue. If you want to know about an overset text, you can go with my ‘Overset text’ article of InDesign.

output 28

Once i will click on the Ok button, then it will create all entries business cards on each separate page. So now we can save it as .pdf and directly take it for printing.

output 29

Conclusion

I hope you find Data Merge as a very good and effective feature of this software, and it saves your lots of time during making these types of a number of entries for different layout design. You can use .psd file design also in InDesign, and Data Merge features will also work with .psd designs.

Recommended Articles

This is a guide to InDesign data merge. Here we discuss How to work with Data Merge in InDesign step by step in detail. You may also have a look at the following articles to learn more –

  1. Alternative to Indesign
  2. What is Adobe InDesign
  3. InDesign CS6
  4. InDesign Document Setup
Popular Course in this category
Maya Training (10 Courses, 7+ Projects)
  10 Online Courses |  7 Hands-on Projects |  100+ Hours |  Verifiable Certificate of Completion
4.7
Price

View Course

Related Courses

Photoshop Training (10 Courses, 12+ Projects)4.9
After Effects Training (3 Courses, 3+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Photoshop Tutorial
  • 3ds Max Tutorial
  • All Tutorials
Certification Courses
  • All Courses
  • Design Course - All in One Bundle
  • Photoshop Course
  • Maya Course
  • Unreal Engine Course
  • Unity Course
  • DaVinci Resolve Course
  • Pro Tools Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Design Course

Banner Creation, Object Selection, Sky Replacement, Advance Filters & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Design Course

3D animation, modelling, simulation, game development & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more