Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
There any number of reasons you may need to update the information in an InDesign table. If the original table source was an Excel or Word table document, you can link to those documents and update them via the Links panel which we discussed in the previous video. But sometimes the information you need to update isn't in an Excel file or a Word table document, maybe it came as an e-mail attachment or from a website, or maybe you don't really need to update an entire table, you just need to change a few rows or columns. Fortunately there's a pretty good alternative to linking files, turns out, InDesign is pretty smart about letting you cut and paste to tab delimited text into a table, and actually in some ways it's easier than updating a linked file, in fact, if your table is not that large, and if your workflow is such that you can do it, I think this method is a bit better.
Here we have a table that needs to be updated and the updates are in a tab delimited file. The first step is we are going to a place that file on the pasteboard, so I'm going to zoom out and switch from Preview to Normal mode, so that we can see the pasteboard. Using the File Place command I will select the file and I'm going to just click and drag and position it over on the pasteboard. Let's zoom in and take a look at this. Couple of things you need to keep in mind is first the information in your text file needs to be Tab Delimited, Comma Delimited text won't work, but that's not such a big deal.
If the information that you need to use to update your table is comma delimited, just place it on the pasteboard and then use Find Change to find comma and change to a tab character. But it's got to be tab delimited. And also you need to select the same number of data fields that is the text in between each tab character the number of bits of information or the number of tabs has to match the number of cells that you're pasting into, or at least, if you're trying to for example, replace an entire row, things have to match up, if there is a field missing it's going to miss a line in your table.
So I am just going to replace all the text in this table with the text from this file and I'll have my blinking cursor in the text so I will select all with Command+A or Ctrl+A and we will copy this into the clipboard. I'm going to move over to the table and by the way this table is formatted with paragraph styles but it uses only local formatting for the tables there are no table or cell styles applied to it. Now I'm going to click in the first cell and select the text and then I'm going to paste, I am going to use the keyboard shortcut, Command+V or Ctrl+V not good the dreaded overset symbol, but that's okay, this is not the correct way to paste information into a table.
I am going to undo that, Command+Z or Ctrl+Z. The way to paste text into a table is to select an entire cell, you can actually just select the first cell in the range of the text that you want to replace, as I've been here by pressing the Escape key. Now we will paste this text into the table, Command+V or Ctrl+V and the text comes in, the table formatting is there, but all of my text formatting is lost. Well, I could reapply paragraph styles and what have you, but that's a lot of work.
There's actually a better way to do this. I am going to undo this, Command+Z or Ctrl+Z.And instead of using the paste command, I'm going to use the wonderful, Paste Without Formatting command, this is a command you should really be aware of when you're copying and pasting text into your InDesign file whether it's in tables are not. If I use this command, all of the text is replaced, we've gone from European countries to Asian countries, and because I pasted the text without taking any formatting from the text that I am pasting into this table, all the formatting is there and guess what, I am done, pretty nice huh? And I didn't even have to apply any Table or cell styles.
Now I can use Table or cell styles. In fact, we are going to look at a few more examples of how to cut and paste text with a table that is styled. I am going to turn to the next page using Shift and Page Down, and this table is just like the other one, but it's been styled with a table style. I'll select the text and let's open our Table Styles panel and it's a standard table style. If we take a look at it, it has table level formatting, but it also has some cell styles designated here.
And if we look at the cell styles, they have that very important attribute of assigning a paragraph style to the table. But as I say in this case we don't really gain an advantage with our formatting by applying a Style. However, it's still a good practice, because we can always use the style if the need to apply it to a table with different information in this document, right? Now I already have the text over here on the pasteboard. It's the same text that we used before. I will get this panel out of the way and one thing that's really great about copying or cutting and pasting text into the table is you don't have to replace the entire table, like you do when you update a linked Excel file.
I am going to select just these last two rows here and copy the text into the clipboard, Command+C or Ctrl+C, and I'll select just this first cell. I know that this is the last two rows of the table and instead of pasting. I am going to Paste Without Formatting the keyboard shortcut is Shift+Command+V or Shift+Ctrl+V, so it just adds the Shift key to the paste command you're accustomed to, and there we go, those two rows are updated and we are done. How about that? That didn't hurt at all.
It turns out using just good old cut and paste can really take a lot of the sting out of updating table data. And at the same time, it maintains all the text and the table formatting. I like that.
Get unlimited access to all courses for just $25/month.Become a member
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.