![]() |
Converting PDF to Excel
Would like to know if it is possible to convert a PDF file to Excel like
converting Text to Columns? |
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? |
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? |
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 |
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