I have a PDF with several hundred pages. Each page is formatted identically and contains data on a single person, divided into various tables. I want to parse the PDF so that each person's data is a single row in a spreadsheet, with various key points (e.g. "name") in the same column. I feel like this has to be an already-solved problem. How can I do this?
Help me turn my iPad into a work productivity tool. [more inside]
I have an Excel spreadsheet with couple hundred rows: URLs, a few fields of identifying information (outlet, etc.), for media hits on the organization I work for. I need to make this into a pretty (or at least semi-legible to the computer illiterate) document that I can give to board members, senior staff, etc. What I would like is to use some form of scripting to automate this. Bonus points if the script can somehow open the URL and take a screenshot of the story so that I don't have to. I have a Mac, and both the Adobe and Microsoft suites. How do I not spend tedious hours manually doing this? Especially since I have to do it each month and quarter.
Is there an automated way of placing elements from one PDF file into another? Open to coding this via Python if a relevant module exists. [more inside]
ExcelFilter: I have a whole bunch of excel files. More than 100 of them. Each file has about one page of print area, but some in portrait and others in landscape. They are mostly text in cells; not a lot of formulas being used. I would like to (1) merge all these files into one Word document; (2) have a page break so that each file (more or less) is one page; and (3) do it with a minimum of cutting and pasting. Opening everything as a PDF and viewing in Preview is also an option, but less optimal since I'll certainly need to adjust some formatting and page breaks. Maybe on publisher? Is anything like this possible? Or do I need to do it page-by-page? What would you do? I'm on a Mac 10.8.2.
How to batch insert links to an excel document? [more inside]
How to populate PDF form from Excel data: number of copies based on number of rows? [more inside]
I have a PDF document and a spreadsheet in XLS format. We want to be able to put the spreadsheet into the PDF and allow users to click on the sheet's column headings to sort the data alphabetically depending on need. Is this possible? If so, what is the best way to do it? [more inside]
I have about 4000 pdfs that i need to scrape data from and put into a database. [more inside]
Scanning, Excel, data input help needed. I need to convert info from a lot of hard copy bank statements into a an excel spreadsheet. Have tried scanning directly into xls and it results in a disorganized mess. Have tried to cut and paste from scan created pdf but it will not allow. Please help in automating this process and making my life a much happier place. [more inside]
Is there a way to create a link in an Excel spreadsheet to a specific page or destination in an external PDF file? I've read some tutorials that show how to do this in html documents but can't seem to figure out if it's possible in Excel. I'm using MS Excel 2000 and Adobe Acrobat 8.1.2 Professional. Thanks!
OCRfilter: any software that will take a PDF and convert it to Excel? [more inside]
I need to generate fillable PDF forms with calculations from an Access db or Excel spreadsheet. [more inside]
DataOrganizationFilter: I am looking for software that will allow my market research team to efficiently store and access information from PDF and Excel files. [more inside]
Mostly an Excel question (though maybe crossover to PDF). [more inside]