Join 3,512 readers in helping fund MetaFilter (Hide)

15 posts tagged with excel and PDF. (View popular tags)
Displaying 1 through 15 of 15. Subscribe:

Taking data from a PDF and putting it into a spreadsheet

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 - 6 answers

iPad iDiot

Help me turn my iPad into a work productivity tool. [more inside]
posted by sardonyx on Feb 17, 2014 - 10 answers

Excel spreadsheet to pretty clips report?

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 - 8 answers

Automated PDF modification

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 - 4 answers

Converting lots of little excel into word?

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 - 9 answers

How to insert a bunch of links to an excel document?

How to batch insert links to an excel document? [more inside]
posted by Sentus on Sep 4, 2012 - 1 answer

How to populate PDF form from Excel data?

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 - 3 answers

Can a sortable spreadsheet exist in a PDF?

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 - 5 answers

scraping pdf content?

I have about 4000 pdfs that i need to scrape data from and put into a database. [more inside]
posted by buttercup on Dec 11, 2011 - 8 answers

Help Me Convert Hard Copy Data to Excel

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 - 9 answers

Link from excel cell to a specific PDF page?

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 - 3 answers

Need magic to convert PDF to Excel

OCRfilter: any software that will take a PDF and convert it to Excel? [more inside]
posted by bartleby on Oct 23, 2007 - 9 answers

How do I create PDF forms from Access/Excel data?

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 - 3 answers

Data Organization Software Anyone?

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 - 6 answers

Excel help

Mostly an Excel question (though maybe crossover to PDF). [more inside]
posted by dobbs on Jun 15, 2004 - 3 answers

Page: 1