Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 9
Default Converting PDF to Excel

Would like to know if it is possible to convert a PDF file to Excel like
converting Text to Columns?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default 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?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default 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?


  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default 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
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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"

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Converting from WP to Excel Desiree- Excel Discussion (Misc queries) 1 September 6th 07 07:36 PM
Converting WB2 to Excel LadyDi Excel Discussion (Misc queries) 1 January 18th 07 08:42 PM
Converting Excel to PDF? Sigi Rindler Excel Discussion (Misc queries) 3 October 27th 06 02:54 PM
Converting a GIF or JPG into Excel carl Excel Worksheet Functions 1 March 31st 06 10:16 PM
Converting .wk4 to Excel Ginnalee Excel Discussion (Misc queries) 2 September 16th 05 01:39 AM


All times are GMT +1. The time now is 06:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"