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.
Just keep it separate because we can do lots of versions of
it and we've got no real space to do it in the other document.
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.
I go to "File" and I go to "Place" and I find out,
we're going to use Table Example Word One.
So make sure you bring it in from Word first.
Click "Open" and we click and drag it out and the table was perfect in Word,
so it's come through perfect in InDesign and no real dramas there.
Where the dramas do happen if I go to File Place
now and I bring in the Example of Word Two,
and I drag this out, this can happen.
It still looks fine, but it's not a table.
It's been damn with tabs,
so there's no actual tables for the lines or it's actually just people have gone through,
gone to hear, hit "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 in the table.
I've just highlighted them all.
Go to "Table", go "Convert Text To Table".
By default, it's using the column separator as the Tab.
You might have commas or something else.
I'm going to click "Okay" and hey presto, it's a table.
I might have to do some adjustments just to kind of tidy that in.
That needs to be a little bit smaller maybe,
and that needs to be a bit bigger.
You can mess around with it like we did in the previous example.
I'm going to put them over him.
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.
I'm going to open up that example.
This is my table example Word two.
I'm just going to copy it and paste it in, and this happens.
So the tab's there but InDesign hasn't converted them nicely.
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. It's the same.
The tab's 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 we'll do is I'm just going to move him off to the side,
is getting it from Excel.
Same process as Word.
File Place and there's one in here called Table Example Excel One.
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 on Word as well if you want to go check that out.
But anyway, I'm going to select all of these.
So this 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.
Convert text to table and we're on our way again.
The nice thing about Excel though is let's say it's a monthly thing,
its revenue reports or sales reports or something.
So you go through and you format it and you spend ages making it look nice.
We'll do a little bit of formatting.
We'll do Alternating Fills.
Every Other Row, skip the first row even.
We've got this, having done some formatting to it.
Terrible formatting, I know,
but let's say I 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.
Let's say this is the data for another month or it's just being 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 we're 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".
So Edit, Copy in Excel,
and then jump into InDesign.
What you're going to do is select the whole table.
Well, select everything you've copied.
If you're only going to select the whole table and hit "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.
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 column to color all the way down click "Copy", go into InDesign.
Click in this, there's a little arrow at the top here to get that whole column.
Hit "Paste". As long as these match up.
We're you're copying and pasting,
it will update and retain the InDesign styles.
Super awesome. All right.
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.