+ Reply to Thread
Results 1 to 3 of 3

Retrieving data from PDF and to put it in an Excel sheet

  1. #1
    Registered User
    Join Date
    06-15-2012
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    2

    Wink Retrieving data from PDF and to put it in an Excel sheet

    Hello guys,
    I wanna ask you a favour that i'm in reallllly bad need for it:
    I wanna know some way to collect data from a daily report from PDF files that are uploaded on certain web siet and put it in an excell sheet >how could i do that , any one can help????????

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Need help for retrieving data from PDF and to put it in an excell sheet

    You can highlight the data in the PDF file and then copy/paste it into Excel. This will tend to put all the data in one column, so you can then apply Text-to-columns (on Data tab) to split it out into columns. You may need to remove header information etc.

    An alternative is to use an OCR package.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    06-15-2012
    Location
    Egypt
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Retrieving data from PDF and to put it in an Excel sheet

    Thanx alot PETE but this isn't what i'm askin' about, Again just to clarify :
    If I got a punch of PDF files with the same form containing many data ,How could I make something to collect a certain data from a certain part in every PDF file and to put it in an Excell sheet without opening every file and copy/paste it . I wanna something to make it automatically.
    I really appreciate your help gentle man

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1