ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Converting PDF to Excel (https://www.excelbanter.com/excel-discussion-misc-queries/178428-converting-pdf-excel.html)

Jalal

Converting PDF to Excel
 
Would like to know if it is possible to convert a PDF file to Excel like
converting Text to Columns?

Pete_UK

Converting PDF to Excel
 
There are a number of different approaches. You could highlight the data
area in the PDF file and copy/paste into Excel, though you will probably
have to so a bit of tidying up, as the data will often appear in one column
(use Text to Column) and you may have headers from each printed sheet
interspersed within the data.

Another approach is to use an OCR package such as OmniPage or TextBridge -
the latter often comes free with scanners - and this will enable you to
convert the file into a number of different formats, but again you will
probably have to do a bit of tidying up.

Hope this helps.

Pete

"Jalal" wrote in message
...
Would like to know if it is possible to convert a PDF file to Excel like
converting Text to Columns?




Gord Dibben

Converting PDF to Excel
 
Have you tried a 'net search for PDF to Excel?

There are a multitude of converters to purchase, most in the $30 to $40 range

I don't know of a good free one.


Gord Dibben MS Excel MVP

On Sat, 1 Mar 2008 11:41:01 -0800, Jalal
wrote:

Would like to know if it is possible to convert a PDF file to Excel like
converting Text to Columns?



Dave Peterson

Converting PDF to Excel
 
There are some web email accounts that allow you to see .pdf's in HTML.
Gmail.com is one. Create an account and email the .pdf file to yourself. Then
open the attachment as HTML.

Maybe that would be sufficient for you.

Jalal wrote:

Would like to know if it is possible to convert a PDF file to Excel like
converting Text to Columns?


--

Dave Peterson

laddy7690

Converting PDF to Excel
 
Probably not without putting more than a bit of effort to put some order in
the exported mess.

Dale
http://www.sisense.com
"Analyze Excel data instantly"



All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com