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?
posted by LSK
on Aug 11, 2014 -
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.
posted by klangklangston
on Jan 31, 2013 -
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]
posted by mnemonic
on Dec 17, 2012 -
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.
posted by RandlePatrickMcMurphy
on Nov 19, 2012 -
How to populate PDF form from Excel data: number of copies based on number of rows? [more inside]
posted by GuppieXX
on Jul 13, 2012 -
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]
posted by Servo5678
on Feb 17, 2012 -
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]
posted by mbx
on Nov 10, 2010 -
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!
posted by bepe
on Apr 17, 2008 -
I need to generate fillable PDF forms with calculations from an Access db or Excel spreadsheet. [more inside]
posted by elle.jeezy
on Jan 3, 2007 -
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]
posted by drkrdglo
on Jun 28, 2006 -