Skip to main content

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

Lesson 68 from: Adobe InDesign Fundamentals

Daniel Walter Scott

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

Lesson 68 from: Adobe InDesign Fundamentals

Daniel Walter Scott

buy this class

$00

$00
Sale Ends Soon!

starting under

$13/month*

Unlock this classplus 2000+ more >

Lesson Info

68. How do I convert tables from Microsoft Word or Microsoft Excel into Adobe 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 convert tables from Microsoft Word or Microsoft Excel into Adobe InDesign

Okay. So that we don't mess up our lovely long document. We're going to do this exercise in a new document. Just a blank one. Okay, just keep it separate because we're gonna do lots of versions of it and we've got a real space to do it in the other document. So what we need to do is show you the different ways that you can bring in tables into word lots of the time they'll come through and just be fine. Okay? So if I go to file and I go to place, okay? And I find our we're gonna use table example, word one. Okay, so make sure you were gonna get them from word first, click open and click and drag it out and the table was perfect inward. So it's come through. Perfect. And in designs and no real drummers there where the drummers do happen if I go to file place now and I bring in the example of word two and I dragged this out. This can happen and it still looks fine, but it's not a table. It's been done with tabs. Okay? So there's no actual tables to put the lines. So it's actually just pe...

ople have gone through, gone to hear his tab to separate them out and that's fine. But formatting becomes a little bit hard because it's not a table, it's easy to adjust to a table select all the bits you want to be on the table. Okay. So I've just highlighted them all. Go to table, Go convert text to table by default. It's using the column separator is the tab, you might have commerce or something else. I'm going to click OK. And Hey, presto, it's a table, I might have to do some adjustments just to kind of tidy that in and that needs to be a little bit smaller maybe, and that needs to be a bit bigger and so you can mess around with it like we did in the previous example, so I'm gonna put them over here. Another example that might come through from word is either the table is not set up right in word and it comes through a bit weird or you copy and paste it. So I'm going to open up that example. Okay, so this is my table example word to I'm just going to copy it and paste it in and this happens. Okay, So the tabs there, but in design hasn't converted them nicely. Okay, so it works just the same as the last example. Select everything that you want to be part of this. Table. Go to table, convert text to table is the same. The tabs separating them and it comes back to looking good. Again, we can go through and play with the lines between them and the style formatting like we did in the previous exercise, The last one will do is I'm just gonna move him off to the side is getting it from Excel. Same processes word. Okay, fireplace. And there's one in here called table example XL1. Ok. And then click and drag it out and it comes through the same kind of problem. This is our Excel file. If you need a course on Excel. I've got one. I've also got one onward as well. If you want to go check that out. But anyway, I'm going to select all of these. So that's what happens when you place from excel. It does this kind of weird tabbed thing as well but I can fix it just like I did with word. Okay, convert text to table and we're away. Again. The nice thing about Excel though is let's say it's a monthly thing. Okay. It's revenue reports or sales reports or something. So you go through a new format it and you spend ages making it look nice. We'll do a little bit of formatting or do alternating fills. Okay. Every other Rose get the first row even. Okay, so we've got this and we've done some formatting to it. Terrible formatting. I know, but let's say we want to update it now instead of importing it and then like saving table styles and all sorts of advanced stuff, you can just jump to excel and let's say this is the data for another month or it's just been adjusted or changed. I'm not sure why we're changing the height of all these. But let's say it was like a financial data and changing every month instead of having to go and re import it and style. It Just select all the bits you want to change. Hit copy. Okay so edit copy and exhale, then jump into in design and what you're gonna do is select the whole table. Okay? We'll select everything you've copied. If you're only going to select the whole table and paste and you'll notice that it goes from height and it just adjusts but it also retains all the style that we've done. Okay so any changes that get made, you can go and adjust now this is true if it's just one file so say you've got red here and I go through and it's all become red. I can select this whole columns of color all the way down, click copy. Get in design, click in this there's a little error at the top here to get that whole column and paste. As long as these match up. Okay we're copying and pasting. It will update and retain the end. Design styles. Super awesome. Alright so that is a few different ways to work with tables when coming from different Microsoft platforms. Let's move on to the next video

Class Materials

Bonus Materials with Purchase

Completed Files
Exercise Files