Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
Here I have a PDF with a lot of data in table form and I have a colleague who needs that data in an Excel spreadsheet. I don't want to type it; he doesn't want to type it; we're going to let Acrobat do the typing for us. So under File > Save As Other, I'm going to choose Spreadsheet, and I have two choices: Excel Workbook or the XML format. He wants the Excel Workbook format so I'm going to choose that. And I can just save it on my desktop. We can take a look at the Settings. If you're using a European file, for example, that uses commas and periods differently from the way the US uses them, you can specify that those get changed on the fly.
That's not the situation with this document, so I'm going to leave it at the defaults. And I don't need to run OCR, because this is a digital file with live text in it. When I click OK and save, you see the progress bar. Let's take a look in Excel and see what it gave us. This is great. All the text is there. All the figures are there. Now anytime you do one of these sort of reverse-engineering jobs, you need to pay attention to the result. You almost always had to do some massaging to it to make it right. You can see that the word Albuquerque has gotten split up sort of strangely.
There is a space in there and a hyphen. So a little massaging though is much more fun than having to retype this totally, and now it's in a form that he can use and Acrobat has saved both of us a ton of work.
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.
Your file was successfully uploaded.