Adobe Acrobat and InDesign are more than the huge document manipulating powerhouses that we know them to be. They're also project-saving gateways for non-Adobe apps, especially when dealing with tables. How do you extract horizontal rows of data from a PDF, and drop them into another app, if the PDF was created in a series of vertical columns? 1.) Open the PDF in Acrobat DC. 2.) File > Export to > Spreadsheet > Microsoft Excel Workbook. 3.) Open that newly created .xlsx file in Excel or Numbers. Now that page's tables are a series of cells for you to extract as needed. Then there's the need to extract data from tables on websites. It's easy enough to copy the data and paste it, but when you do that, you may see a hodge-podge of text and graphics, some of which didn't even appear on the web page. Try pasting it into InDesign. The graphics disappear. The website's possible typeface wars cease fire. However, there's probably still a bunch of repetitive text on the page, which you want to get rid of before pasting it into another app. By way of example, there may be 120 instances of "Click Here." How do you delete all of them, fast? 1.) Edit > File Change. 2.) In the "Find What" field, type Click Here. 3. ) Leave the "Change to" field blank. 4.) Click on the "Change All" button. "Poof!" 120 instances are gone. There's even far more power in these features. We'll explore more, later.
Thanks, Brian, for your insights on working with tables. Much appreciated!
Thank you, Steve. This is an actual case usage thing for us. We have a huge project we have been working on, night and day, since last week.
Did you know that there's no reason to pick-up the phone and call a company's executive suite, on Christmas Day, and say, "Ummm... did you know that there are some issues with copying and pasting your price list? Could you please send that to me as an xlsx file?"
That's right up there with asking yourself, "Why is a very prayerful Catholic couple working on Christmas Day?"
When you get sick of looking for answers in Numbers, Excel, Pages, and Word, you can ask yourself, "HEY? Don't the Adobe apps do all this stuff?" Yes, even when working on Christmas Day, Adobe has little Christmas presents hiding in its apps.