You want to get data from a table in a PDF file to Excel.
Exporting Excel data as a PDF
Today's trick is from Katie Sullivan on the Word team
There are a few cases where Microsoft Word can do things better than Excel
One of those is pasting data from PDF files
Paste to Word
Copy the data from Word
Paste to Excel
In the recap, a way in Acrobat to Copy with Formatting and it will paste half-correctly to Excel
Exporting Excel data as a PDF
Today's trick is from Katie Sullivan on the Word team
There are a few cases where Microsoft Word can do things better than Excel
One of those is pasting data from PDF files
Paste to Word
Copy the data from Word
Paste to Excel
In the recap, a way in Acrobat to Copy with Formatting and it will paste half-correctly to Excel
Transcript of the video:
Learn Excel from MrExcel podcast, episode 2052 - PDF to Excel!
Hey, welcome back to the MrExcel netcast, I'll be podcasting this entire book, click the “i” in the top-right hand corner to get to the playlist!
Today, we're talking about those evil people who have data in Excel, but they don't send you the data in Excel, they send it as a PDF.
So File, Export, create a PDF, want to Open file after publishing, call it Podcast2052, click Publish, alright, there is our data in the PDF.
Now I got this PDF, but I want to create a Pivot table or to create a chart or do something, but I can't do that from the PDF, so I select the data in the PDF, Ctrl+C to copy.
This annoys me so much, why can't the Excel team take their own data, they created that PDF, why can't they paste correctly, and have it pasted into a table instead of down a column?
Alright, Word, Ctrl+V, look, it pastes correctly, select the data in Word, Ctrl+C, switch from Word back to Excel, Ctrl+V to paste, and it round-trips correctly.
Why can Word do this and not Excel?
Well this tip, and a lot of other tips, are in the book, click the “i” in the top-right hand corner to buy the book.
Alright, episode recap: Started out exporting Excel data as a PDF, today's trick is from Katie Sullivan on the Word team.
One of those things where Word is better than Excel is accepting pasted data from PDF files.
Scrape the data from the PDF file, Ctrl+C to copy, go to Word, paste to Word, it'll paste correctly, copy the data from Word, go back to Excel, paste to Excel.
Yet another thing that Microsoft Word does better then Excel.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel!
This is an outtake, it's such a weak, weak trick.
If you need to go directly from the PDF to Excel, and you have full Adobe Acrobat instead of just Acrobat Reader, you can right-click and Copy With Formatting.
Then, when you come to Excel and paste, Ctrl+V, but look, it's not as ju- urrrrrgh!
Hey, welcome back to the MrExcel netcast, I'll be podcasting this entire book, click the “i” in the top-right hand corner to get to the playlist!
Today, we're talking about those evil people who have data in Excel, but they don't send you the data in Excel, they send it as a PDF.
So File, Export, create a PDF, want to Open file after publishing, call it Podcast2052, click Publish, alright, there is our data in the PDF.
Now I got this PDF, but I want to create a Pivot table or to create a chart or do something, but I can't do that from the PDF, so I select the data in the PDF, Ctrl+C to copy.
This annoys me so much, why can't the Excel team take their own data, they created that PDF, why can't they paste correctly, and have it pasted into a table instead of down a column?
Alright, Word, Ctrl+V, look, it pastes correctly, select the data in Word, Ctrl+C, switch from Word back to Excel, Ctrl+V to paste, and it round-trips correctly.
Why can Word do this and not Excel?
Well this tip, and a lot of other tips, are in the book, click the “i” in the top-right hand corner to buy the book.
Alright, episode recap: Started out exporting Excel data as a PDF, today's trick is from Katie Sullivan on the Word team.
One of those things where Word is better than Excel is accepting pasted data from PDF files.
Scrape the data from the PDF file, Ctrl+C to copy, go to Word, paste to Word, it'll paste correctly, copy the data from Word, go back to Excel, paste to Excel.
Yet another thing that Microsoft Word does better then Excel.
Thanks for stopping by, we'll see you next time for another netcast from MrExcel!
This is an outtake, it's such a weak, weak trick.
If you need to go directly from the PDF to Excel, and you have full Adobe Acrobat instead of just Acrobat Reader, you can right-click and Copy With Formatting.
Then, when you come to Excel and paste, Ctrl+V, but look, it's not as ju- urrrrrgh!
