Cool Tools: How to pull data from a PDF for use in Excel

This post is reposted from

Have you ever wanted to pull all of the raw data out of, let’s say, a pdf file of government data or a journal article? It’s the worst! You can’t just copy and paste from it, so first you try to contact the author, but you never hear back invariably. Second, you try to hand type the data, but if it’s a worthwhile amount of data, by the time you are half way through, you realize that none of your rows match up to what they are supposed to be, or you have carpel tunnel so bad that you are forced to bathe your delicate hands in your kitchen ice maker to reduce the swelling. After these two abominable efforts, you finally decide that you are willing to pay whoever or whatever to get some sort of tool to extract the data.

And this is where you suddenly wonder if the tool you are about to install is a real app, or just a devious technique to take your credit card information, and probably the deed to your house as well.

Have no fear, Tabula is here to help you in your moment of need without all of those pesky viruses.

tabula icon


Working with Tabula is simple. From the Tabula website, here’s how it works:

  1. Upload a file with tables you would like to copy.
  2. Draw a box around the area of the table you would like to copy. (Note: currently, Tabula can’t select tables over multiple pages)
  3. You will be given the option to copy the table as a CSV (comma-separated values) file or download the CSV or TSV (tab separated values). If you notice any errors in the table, you can make text edits to the selected text before copying or downloading.

Wow! all with a free tool for Windows, Mac, or, for our favorite penguin-lovers out there, Linux. If you haven’t checked it out yet, let us know how useful you find it!

Tagged with: , , ,
Posted in Cool Tools, The Exchange
4 comments on “Cool Tools: How to pull data from a PDF for use in Excel
  1. clair filip says:

    Really a great addition. I have read this marvelous post. Thanks for sharing information about it. I really like that. Thanks so lot for your convene.
    Power Washing Centreville VA

  2. Cameron Sharland says:

    By following this procedure I have successfully transferred my data from pdf to Microsoft excel. And I also grateful to USEssayWriters
    that are helping the students in getting their education and making it easier for them to gain this knowledge.

  3. ben stokes says:

    I am happy to find this post Very useful for me, as it contains lot of information. I Always prefer to read The Quality and glad I found this thing in you post. Thanks
    Residential Moving CUPERTINO CA

  4. John Micson says:

    Thanks for taking the time to discuss that, I feel strongly about this and so really like getting to know more on this kind of field. Do you mind updating your blog post with additional insight? It should be really useful for all of us. Upholstery Cleaning Medford MA

Skip to toolbar