Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
If you want to see something really incredible, check out how great Adobe Acrobat exports to Microsoft Excel, or basically any spreadsheet format. What we are looking at here is kind of a lengthy table. It was exported from Adobe InDesign, so it's not from Excel. If you want to see, by the way, how the PDF was created, just go to File > Properties. You can see that this was exported from Adobe InDesign, right? What we want to do is we want to export this to Excel and not have it come in as like a big picture, or bunch of text.
We wanted these things to be in individual cells. So how do you do that? Go to the File menu, choose Save As, and just as we were exporting to Microsoft Word, go down to Spreadsheet. So you can export something as a Microsoft Excel workbook, or you could also export it as an XML spreadsheet from circa 2003. We are going to just stick with Microsoft Excel Workbook, and that's an XLSX file.
Let's export it to the Desktop and check out our settings before we click Save. The settings are pretty much of a no-brainer. If you want to run OCR, this is always a good option to turn on because that means that if necessary, Acrobat's built-in powerful Optical Character Recognition engine will kick in, helping to tell Acrobat if something is a piece of artwork, if it's a background, or if it's a letter. So we'll just say OK and then click Save. You get a little processing bar very quickly, and let's jump over to Excel and open up that file.
It was on the Desktop, this guy right here. There we go. Check that out! Is that amazing or what? I don't know. I am blown away by this. I think it is so cool. This will save us so much work that anything that you have to look like a spreadsheet basically Acrobat can figure out is a spreadsheet. Now some things didn't quite make it all the way through, like these things were all supposed to be centered. Apparently, while it was processing this field, it thought, "Oh, this is supposed to be left -aligned," maybe because it is kind of a long word. I am not quite sure how it did that.
And it didn't retain our align on the decimal point that we had in Acrobat, and that came from InDesign, but at least all the figures are there. This gray bar here is the header from the page 2 of PDF, and it didn't create two pages for the spreadsheet; it just created one page, and it put it altogether, which is usually exactly what you want it to do. So I thought that was an incredible job. Now let's check out another interesting little feature here, in that you can also export selections to a spreadsheet.
We could select something from here, but I thought, let's try a different document. I have that presentation open that I have been using on and off. This is an export to PDF from PowerPoint, and I am opening up the Page Thumbnail panel so we can come down here where there is a chart. I have no idea how this chart was made. I am suspecting this looks like something that was built in PowerPoint. But all you need to do is make a selection, and you can export the selection to Excel. So you have this Selection tool selected. I am just going to come out here, and let's grab say from the Plains to the Mideast.
Let's actually get a better selection. Make sure I get all of the Mideast. There we go: Plains, South, Mideast. Now with that selected, I am going to right-click and choose Export Selection As, and I want it to export it as an Excel workbook. With my fingers crossed, I am going to call this PPT chart. Check our Settings. Yes, they haven't changed since we last looked. Click Save.
So it did a little processing. Let's jump over to Excel and open that file. And there is PPT-chart. Did it work? Yes it did. Look at that! Is that great? I think it's fantastic. It even brought over the background color of green, which is kind of interesting. So that's about it. It's really simple, and I love simple. I don't know about you. But if you have a spreadsheet, or something that looks like a spreadsheet, in Acrobat, all you need to do to get it into an editable format in Excel would be to go to File > Save As and choose the Spreadsheet option for Microsoft Excel Workbook.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 91392 Viewers
80 Video lessons · 138268 Viewers
59 Video lessons · 57099 Viewers
52 Video lessons · 70752 Viewers
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.