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

buy this class

$00

Buy Class

Sale Ends Soon!

starting under

$13/month*

Unlock this classplus 2000+ more >

79.7K Students

99% Recommend this Class

00 Student Work

0 Video lessons in HD
00h 00m of class content
Exclusive bonus content
Lifetime access, anywhere, anytime
Streaming access on desktop and mobile browsers
Download and offline access with class purchase
Offline sync with our iPhone & iPad apps
100% satisfaction guarantee

Daniel Walter Scott

Multi-award winning, influential media designer & Adobe Certified Instructor with 15+ yrs of experience.

SEE INSTRUCTOR'S CLASSES

topics covered in this class

Branding Graphic Design Adobe InDesign Design Projects

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.

2,000+ classes ranging from fundamentals to advanced techniques.

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

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

Lesson Info

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

Lessons

InDesign Tutorial Basics Class Introduction

Exercise files & Projects

What Does Adobe InDesign do?

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

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

New document in InDesign - what is bleed & slug?

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

How do I steal colors from a logo using InDesign?

How to color the background of a page in InDesign?

Importing resizing rotating & flipping images & Logos inside InDesign

How to Import text from Microsoft Word into Adobe InDesign

How to group, ungroup & rotate images in Adobe InDesign

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

How best to preview your work in Adobe InDesign

How to make a simple PDF from InDesign

How to save your InDesign file as a JPEG

Why should I use CC Libraries in InDesign?

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

Class Exercise 1

Quiz - One Page Flyer

Ideas, Inspiration & starter templates

Working with other people's InDesign documents, missing images

How to find missing fonts in InDesign?

How to replace images in InDesign?

Opacity, transparency and see through ness in Adobe InDesign

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

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

Quiz - Other people's files

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

How to use a Master Page in Adobe InDesign

How do to add automatic page numbering to a InDesign file

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

Production Video 1

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

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

What is TypeKit used for in Adobe InDesign?

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

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

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

Importing Text from Microsoft Word & keeping or removing the formatting

Creating Columns in a text box using Adobe InDesign

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

What is the space after & leading in Adobe InDesign?

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

How do I make a paragraph style in Adobe InDesign?

How do I update a Paragraph Style in Adobe InDesign?

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

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

InDesign Class Exercise 2 - Magazine Spread

Quiz - Company Newsletter/Brochure

How to bring in lots of text into InDesign at once

How do I import paragraph styles from another document

How do I insert completely blank pages in Adobe InDesign

How do I create a gradient in Adobe InDesign

Do I need to use layers in Adobe InDesign

Opacity advanced, mater marks and Transparency Effects in Adobe InDesign

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

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

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

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

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

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

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

What is Adobe Stock

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

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

How can I create a table inside Adobe InDesign?

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

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

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

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

How do you change the tabs in Adobe InDesign?

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

Quiz - Long Business Document