title: I want to automate the manual process of extracting data from PDF to excel
body: <p>I have hundreds of PDFs and all of them have exact same format (mostly tabular). I have an excelsheet where I pick values from tables (PDF) and paste them to specific location in excel (also in table) to analyse the data. I have been through hell : powershell, itextsharp, acrobat forms, export data etc etc but so far I have been unlucky. Is there anyway I can automate this manual process of picking data from PDF and putting them into excel. Again all PDFs are of exact same format (only value differs).</p>
  <p>Edit: To add more details these PDFs are tax returns. I have to consolidate tax returns which are filed monthly. Therefore the table heads remain same in excel only value changes for each month because different return for different month. Right now I am opening individual PDF and copying values and pasting them to excel sheet. I want to automate this process.</p>