Skip to main content

How do I combine Microsoft Excel spreadsheet in InDesign?

Lesson 75 from: Adobe InDesign Fundamentals

Daniel Walter Scott

How do I combine Microsoft Excel spreadsheet in InDesign?

Lesson 75 from: Adobe InDesign Fundamentals

Daniel Walter Scott

buy this class

$00

$00
Sale Ends Soon!

starting under

$13/month*

Unlock this classplus 2200+ more >

Lesson Info

75. How do I combine Microsoft Excel spreadsheet in InDesign?

Lessons

Class Trailer

Overview

1

InDesign Tutorial Basics Class Introduction

01:50
2

Exercise files & Projects

02:39
3

What Does Adobe InDesign do?

01:34
4

What are the differences between InDesign and PageMaker, Illustrator, Photoshop, Quark?

05:10

PROJECT 1: One page flyer

5

How to change MM to Inches & changing UK to US dictionary in InDesign?

01:39
6

New document in InDesign - what is bleed & slug?

08:08
7

How to create your own RGB & CMYK colors in Adobe InDesign

08:39
8

How do I steal colors from a logo using InDesign?

03:14
9

How to color the background of a page in InDesign?

03:33
10

Importing resizing rotating & flipping images & Logos inside InDesign

07:53
11

How to Import text from Microsoft Word into Adobe InDesign

05:46
12

How to group, ungroup & rotate images in Adobe InDesign

05:12
13

How to make a dotted line, dashed line & borders in InDesign

05:20
14

How best to preview your work in Adobe InDesign

05:16
15

How to make a simple PDF from InDesign

06:43
16

How to save your InDesign file as a JPEG

02:27
17

Why should I use CC Libraries in InDesign?

05:08
18

How to share your InDesign files with others by using package document

04:26
19

Class Exercise 1

03:24
20

Quiz - One Page Flyer

PROJECT 2: Other people's files

21

Ideas, Inspiration & starter templates

04:59
22

Working with other people's InDesign documents, missing images

03:12
23

How to find missing fonts in InDesign?

04:27
24

How to replace images in InDesign?

01:30
25

Opacity, transparency and see through ness in Adobe InDesign

02:29
26

Why is InDesign adding [Converted] and making me 'save as'

01:06
27

What if I can’t find the InDesign file - can I open the PDF?

02:37
28

Quiz - Other people's files

PROJECT 3: Company Newsletter/Brochure

29

Creating a new company newsletter or brochure, what are spreads in InDesign

06:58
30

How to use a Master Page in Adobe InDesign

05:33
31

How do to add automatic page numbering to a InDesign file

04:11
32

Removing a master page & deleting parts off the master page in InDesign

02:30
33

Production Video 1

02:53
34

What is Effective PPI & Image resolution in the InDesign links panel

06:52
35

How to add drop shadows to an image or logo in InDesign

04:20
36

What is TypeKit used for in Adobe InDesign?

08:37
37

How to add the Copyright, Registered & Trademark symbols in InDesign

05:08
38

Where can I find the different versions of letters in InDesign - Ligatures.

03:35
39

How to add placeholder text & lorem ipsum & get a word count in InDesign

03:04
40

Importing Text from Microsoft Word & keeping or removing the formatting

02:58
41

Creating Columns in a text box using Adobe InDesign

01:46
42

How do I justify text & turn off hyphenation in InDesign?

03:59
43

What is the space after & leading in Adobe InDesign?

05:22
44

How to underline text with a full width line in Adobe InDesign?

01:53
45

How do I make a paragraph style in Adobe InDesign?

06:06
46

How do I update a Paragraph Style in Adobe InDesign?

04:28
47

How to use Find & Change to remove double spaces after a period or full stop.

02:37
48

Stealing colours from images, is there a format painter in Adobe InDesign?

03:09
49

InDesign Class Exercise 2 - Magazine Spread

04:22
50

Quiz - Company Newsletter/Brochure

PROJECT 4: Long Business Document

51

How to bring in lots of text into InDesign at once

08:11
52

How do I import paragraph styles from another document

12:45
53

How do I insert completely blank pages in Adobe InDesign

02:03
54

How do I create a gradient in Adobe InDesign

07:20
55

Do I need to use layers in Adobe InDesign

05:27
56

Opacity advanced, mater marks and Transparency Effects in Adobe InDesign

04:24
57

How do I add rounded corners to an image or box in Adobe InDesign?

02:52
58

How to add a large first letter to my text aka Drop Cap

02:16
59

How do I increase the space between letters in Adobe InDesign aka Tracking or Kerning

02:32
60

How do I get text to move around an image or shape using text wrap

03:57
61

Why can’t I put text over anything that has text wrap applied?

03:25
62

How to draw an arrow or triangle or star in Adobe InDesign

06:40
63

How do I put an image inside other shapes like a circle - cropping

02:47
64

What is Adobe Stock

04:17
65

Where can I find free images & icons that I can use for my business

04:23
66

How do I add bullets and numbered lists in Adobe InDesign?

00:51
67

How can I create a table inside Adobe InDesign?

07:10
68

How do I convert tables from Microsoft Word or Microsoft Excel into Adobe InDesign

04:26
69

How do I get images to move with the text in Adobe InDesign using anchored objects?

03:22
70

How do I create a Line Break, Column Breaks & Page Breaks in Adobe InDesign?

04:16
71

How do I make an automatic table of contents in Adobe InDesign?

04:46
72

How do you change the tabs in Adobe InDesign?

04:30
73

Can I change the numbering of my pages so 1 starts later in the InDesign file?

03:26
74

Quiz - Long Business Document

PROJECT 5: Conference Name Badge

75

How do I combine Microsoft Excel spreadsheet in InDesign?

09:04
76

CLASS EXERCISE: Create your own business card

01:16
77

Quiz - Conference Name Badge

What next

78

How to create a mockup for your portfolio using InDesign

04:07
79

InDesign cheat sheet & shortcuts

12:45
80

BONUS: Software Updates

40:41
81

What to do after this InDesign tutorial class?

01:07
82

Quiz - What Next

Final Quiz

83

Final Quiz

Lesson Info

How do I combine Microsoft Excel spreadsheet in InDesign?

alright in this video we're going to take this boring old Excel file with all this data in it and then make it work in in design by creating these placeholders. Okay, First name, last name company. And then generating a file that has loads of people's names in it, you can see here I met 100. Cool. So let's go and do that now in in design. Okay. So the first thing we need to do is we're going to create a little swing tags. So we're going to go to file new document. Now, the best thing to do for sizes to go down to your local stationary supply store and just figure out what the plastic little sleeve that they go into, the size it takes. Okay. I'm pretty sure they all use inches even if you're not in America Okay, four inches by three inches. But go and check just to make sure sometimes the business card size is just to take business cards. Okay. But we're going to use the 4" by 3". And in terms of this one we're gonna set the margins to zero just because I just don't need them for this c...

ase. And in terms of the bleed k we'll use our eighth of an inch. So point 125. Okay. Or three millimeters all round. Great. And I'm gonna grab my rectangle tool. I'm gonna draw a rectangle that kind of covers this bottom bit. That's where the company name is going to go and I'm going to fill it with our red. Okay, It's not part of that because it's a new document. So I'm going to click it over here. Okay. And I'm gonna make it a little bit smaller. Cool. And the next thing I want to do actually is bringing my logo file place in your 05 dot emerge. There is one called green logo. Bring him in and get them about their w Yeah, it's going to be okay. Maybe a little bit over. Cool. So now we need to connect the Excel file. The trouble is Excel won't actually connect directly. So weirdly you have to open up your Excel file in Excel. Okay. Which is not weird. I guess that's the wrong file. It's open them up. It is. We're going to start with this one here. The garden awards attendees. Okay. And that's what this file looks like. You can see there's lots and lots of data in this one, but the XLs or the sls won't work. You just need to open up an Excel or google docs, whatever you can to open it up and go to file and just do a save as. So instead of our X L S X, we're going to drop that down and go to this one that says CSP that's the one that in design can accept. Don't need to change anything else had saved already done it for us and our examples. So if I connect it now it's going to connect to the C. S. V. But not the Excel file. So let's open up our data merge panel. Let's go to window. Let's go down to utilities. Let's go to data merge and it kind of tells you what to do here. But the first one is the knave sandwich here. Okay. And we're going to click on select data source, remember you can see these ones that are great out. It won't work for these. I'm in oh five data merge and we're going to work with the garden awards attendees. Okay. And you'll see that if I jump back into excel, you can see it's brought through the the hitting names or the column names. If you don't have these go into your file and just add them to it, it's going to make life easier if you're working in design. Okay. You might have inserted row and just type them in. Cool. So you don't have to use all of these. I want first name, last name. I don't want the entry fee. I don't want their email address or entry date. I want the company name. Cool. So you can decide on what you want to have. I'm gonna move that off to the side. I'm gonna grab my type tool. Okay. And I'm going to draw a nice big type box. Okay. And there it is there. And all I need to do is my cursor flashing, I'm going to click the word first name. Put a return in on the keyboard and put in the last name. Cool, so I'm going to style these now to look like it did in the early part of this video. Okay, I'm going to move them so they're kind of centered. I'm going to highlight these guys and make them centered This one. They're both gonna be roboto. So let's go roboto and roboto. Roboto one is going to be bold. It's bold there is there? Okay, I'm gonna increase this one here. I'm going to max out the size. How big Okay, you have to look at your names list and see how many characters that person has. Okay, if you've got somebody with a really big foreign name, you might have to have a slightly smaller font. We can test, it's easy enough. Okay, select it all. I'm going to make it that green color. This guy here is going to be the light version. Now I'm just messing around designing. Okay, now it's hard to work with this first name, last name. So what we can do is see it says preview in the corner. It will pull through only the first entry from your database list. Okay, so Robin Ward not very long so it's going to fit just fine. So I'm gonna select it all and just make it a bit bigger. Here we go and hope you can cycle through them. So this arrow. Okay, I'm going to go through Robin Ward. Mark Rose, little sergio. Okay, so we've got lots of names and none of them are very long. So this is gonna work out just fine. Cool, Now this is not actually done. This is just preview it, you can turn it on and off. Okay, But it's not meant to be the finished one. We've got to kind of the last part to this to export it. This is just kind of previewing it through. So there's one more thing I need to do is my company name. So I've got nothing selected, grab my type tool, drag out a box and I'm going to click in company. Okay, I'm going to do the same thing. I'm going to center it, grab it. Some of the company names get quite long, so I'm going to have it so it's all the way across. Not that far across. Okay, I'm gonna use my eyedropper tool like we did earlier. I'm gonna grab all of this. Okay, grab my eyedropper tool steel, that one. Okay, just so I've got the Roboto thin, make it a bit smaller, maybe make the font paper hit preview. You can see some of these business names are a lot longer so I'm probably going to have to go smaller on the font slept all this. You bit smaller role fits in. Yeah, we might have to do a print as well because this is printing at 13 points. It's not gonna be tiny, but it might be maybe a little too thin to read so I'm going to go up to regular. All right. So let's have a look through a few of these. They look like they're all going to fit. Cool. So that is how you kind of connected to up. Okay. The next thing I want to do is I want to export this thing so I can um yeah, first of all gonna save it. Let's save it. And let's call this one on my desktop and my in design class files. This one is going to be called my Green at Heart Awards night Awards night Um, Tags. Okay, I'll call this one V 1. Great. So this here. Okay, is to save it. I need to turn this off. Okay, save it. Cool. So um this here is like the template. It's not gonna be you're gonna end up with two files. You got this one plus the one you generate with all the names in it and you can click this little icon here. Okay, create merged document, click on this and there's a few different options. Okay, We're just going to leave it all as standard because that's probably what you're going to need to do. Okay, let's click create. And what happens is we've got, I've got two files open at the moment. Okay, but it's generated a third. Okay. A nice little thing that appears here. No over set. Text was generated over set text is that little red cross in the corner that says the text couldn't fit. That's gonna be good. So you're doing business cards and it's for like I've done jobs for 10,000 people, had a big electrical company and You hit that button and you don't want to have to go and double check 2000 names or 10, names to see if any of the names are too long and won't fit. This is just telling you. Don't worry. All is cool. All right. The difference between this one which is my template. Okay. Which has got first name, last name like placeholders and the second one is the naming. Can you see here? Okay. It's called the one that's got a hyphen one. It's not a super like clear. But if I save this one now instead of high from one, I might give it a better name. I might call this one. I can't think of a better name. Don't call it final. Okay, remember that'll kill this job. Okay. We need to call it calling it output because I can't think of a better name at the moment, maybe it's easy just call the first one template and then the next one not template. Okay. So it's saved and what we can do is look at the pages panel which mine has disappeared. Window. Let's go to pages. Okay. And I drag it back in here. I know I dragged that out I was using it for a different project while I was making these tutorials. Okay as you can see I have a page one, page two, page three and you'll see you see all these names here. It's made a document with all of these so I'm printing in the office. I can have print obviously imprint what is it, 100 different names or I can send this to the printer now to get printed and hopefully get trimmed up and then sent back to me so I can put them into their little clear name sleeves at the welcome desk. When people arrive I got my heart set on this gala night. They'll even though I've totally just made this thing up. But anyway I'm sure it'll be the great night that my friends is that emerge

Class Materials

Bonus Materials with Purchase

Completed Files
Exercise Files

Ratings and Reviews

Jerome Clark
 

I think Dan is very good at explaining and breaking down complex content. I like the way there are lots of small sessions which is good for keeping focus. I would advise anyone who does this course and is taking notes to label which session the notes are referring to as I have struggled to find a few looking back and this helped me. It really made me realise how much I didn't know and had been fudging. Thank you Dan I will be taking plenty more of your courses in the coming months it's been a great help.

Giuseppe Lipari
 

Excellent course, instructor is great well spoken, clear and a great teacher. I highly recommend this class for beginners and those who learned indesign on their own.

Kelli Drum
 

Student Work

RELATED ARTICLES

RELATED ARTICLES