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