Converting PDF Data to Excel

Discussion in 'Mac Apps and Mac App Store' started by SteinMaster, Jul 5, 2011.

  1. SteinMaster macrumors 6502

    SteinMaster

    Joined:
    Feb 28, 2009
    Location:
    USA
    #1
    Does anyone know about an application that can take PDF data and automate it into Excel. I have a bunch of data that needs to be entered into Excel for sorting, filters, and pivot tables. Manually keying the data will take many days. Thanks
     
  2. CylonGlitch macrumors 68030

    CylonGlitch

    Joined:
    Jul 7, 2009
    Location:
    SoCal
    #2
    Easiest way, copy and paste into a text editor like VI that is very powerful due to regular expression processing. Then us that to format the data into a CSV file that can be imported into Excel.

    I did one for another MR user a few months ago, took about 1 to 2 hours to process the entire 50 to 100k record file.
     

Share This Page