Tabula is a tool for liberating data tables locked inside PDF files.
Contents
How Can Tabula Help Me?
-and-paste rows of data out of PDF files. Tabula allows you to extract that data into a CSV or Microsoft Excel spreadsheet using a simple, easy-to-use interface. Tabula works on Mac, Windows and Linux.
Who Uses Tabula?
Grassroots organizations like SchoolCuts.org rely on Tabula to turn clunky documents into human-friendly public resources.
And researchers of all kinds use Tabula to turn PDF reports into Excel spreadsheets, CSVs, and JSON files for use in analysis and database applications.
How to Use Tabula
Start the local application
cd ~/bin/tabula
java -Dfile.encoding=utf-8 -Xms256M -Xmx1024M -jar tabula.jar
Launch the local website
- point your browser to http://localhost:8080/
Once you do this, you're able to interact with the graphical browser-based version of Tabula. You can also use the command-line version tabula-java[1]
- Upload a PDF file containing a data table.
- Browse to the page you want, then select the table by clicking and dragging to draw a box around the table. (Note it will auto-scan the document so text selection may not even be necessary.)
- Click "Preview & Export Extracted Data". ...
- Click the "Export" button.
Now you can work with your data as text file or a spreadsheet rather than a PDF!