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
Got a tip for us?
Let us know
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.
Converting PDF Data to Excel
- Thread starter SteinMaster
- Start date
- Sort by reaction score
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.
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.