everydayExcel Newsletter Header

Converting PDF to Excel Format

The conversion of PDF documents to Excel is a solution Excel users frequently look for. These PDF documents usually contain columns and rows of information such as price list, invoice details that Excel users like to store in a spreadsheet. The problem with converting PDF documents to Excel is the change of layout during the copying of data from PDF and pasting it in Excel. The data which is in multiple columns is re-arranged into one single column. In the market, there are many third party tools which claim to be able to do the conversion for you. But a lot of them are not able to do a good job despite paying for them.

I was in the same situation recently when I tried to transfer the invoicing details in a PDF file to Excel. But this time, I decided to try something different. Instead of copying and pasting, I saved the PDF document as a text file and then open the text file in Excel. Voilŕ! The table which is my major concern turned out to be in the same layout as shown in the PDF document and all I have to do is a simple Text-to-Column to split them up into the respective columns. I found out that not all the PDF readers work the same way. I definitely cannot apply use the same method on Acrobat Readers. The PDF reader that works with my method is PDF Creator. So if you need to convert PDF to Excel, remember to install PDF Creator. To get the step by step guide on how to do the conversion with PDF Creator, watch this YouTube video.

Convert PDF Document to Excel


Ask us an Excel question and get your question answered by our team of Excel experts

Click on this link to post your question.


Upcoming Courses

With the newly introduced PIC bonus, you are now paid (not paying) 60% of the course fees for sending your staff to our courses. Check out now in this IRAS PIC Link.

Hidden Secrets in Data Analysis with Excel 2007/2010 - 11 & 12 Aug 2014 (Full!)

Hidden Secrets in Data Analysis with Excel 2007/2010 - 14 & 15 Aug 2014 (Full!)

Hidden Secrets in Data Analysis with Excel 2007/2010 - 4 & 5 Sep 2014

Interactive Dashboard Reporting with Excel 2007/2010 - 2 & 3 Oct 2014

Gaining Stunning Business Insights with Excel Power Pivot - 10 & 11 Nov 2014

Learning the Magic of Macros 2007 (Excel VBA) - 18 & 19 Aug 2014

Breakthrough Performance for HR in Excel 2007/2010 - 28 & 29 Aug 2014 (Limited Seats)

Dynamic Real-Time Forecasting with Excel 2007/2010 - 16 & 17 Oct 2014

For the details of the courses, please refer to our Excel courses page.


Subscribe to our newsletter

If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.


Follow us at Facebook, LinkedIn

If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.


Yours Sincerely,

Jason Khoo
Chief Trainer
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and 
"Excel Secrets for Highly Effective Marketers"

 

Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.