+ Reply to Thread
Results 1 to 2 of 2

How can I Move from PDF file to Excel based on TITLES in he PDF Document?

  1. #1
    Registered User
    Join Date
    02-26-2016
    Location
    San Jose
    MS-Off Ver
    2007
    Posts
    1

    How can I Move from PDF file to Excel based on TITLES in he PDF Document?

    Hi,
    I am aware of google's Data Miner, using which I am able to move web page content to excel files, with required fields using shell script.
    This data scraper works based on the Titles on the Web Pages.
    Is there any similar facility to extract data from PDF to Excel based on titles on the PDF page?

    I want to assist the student community, by providing list of jobs, relevant to their profile, to minimize their efforts.
    This is required for automation project relevant to students. I have the skill sets of 1000 students in PDF files. I want to convert this into 1000 rows of excel file, with skill sets in separate column.

    PDF FILE

    Resume

    SKILL SET
    Java, C++, Hadoop

    EXPERIENCE

    DEGREE


    I want to pull he different contents under different titles into different columns of Excel file.

    Any help is appreciated..

  2. #2
    Registered User
    Join Date
    03-02-2016
    Location
    158
    MS-Off Ver
    Office 2007 Ent.
    Posts
    4

    Re: How can I Move from PDF file to Excel based on TITLES in he PDF Document?

    I would copy the values from the PDF file to a text file using a comma seperated value format and save it as .csv file.

    For Example:

    Text File
    Please Login or Register  to view this content.
    You can save it either as a text file or when saving choose all files and change the extension to .csv (I have more success with this option)

    Under the Data ribbon choose Import from text file, choose your file, and in the options choose the option indicating the values are separated by commas.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Open a URL from a Filtered List of Document Titles
    By TexinsKarate in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-17-2014, 02:37 PM
  2. incert File Names and Titles into Excel
    By amberkratzer in forum Excel General
    Replies: 1
    Last Post: 07-10-2013, 01:02 PM
  3. Macro to move word document based on email address
    By kingsley in forum Excel General
    Replies: 0
    Last Post: 10-03-2011, 02:25 PM
  4. Replies: 0
    Last Post: 06-23-2006, 01:15 PM
  5. [SOLVED] Center document titles over several columns
    By Maggie B. in forum Excel General
    Replies: 1
    Last Post: 03-18-2006, 03:35 PM
  6. Need to browse 100's of file TITLES in Excel 2000
    By jeffbro27707 in forum Excel General
    Replies: 3
    Last Post: 05-02-2005, 05:06 PM
  7. [SOLVED] Song file titles into Excel?
    By Rob McLean in forum Excel General
    Replies: 8
    Last Post: 04-04-2005, 05:06 PM

Tags for this Thread

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