Sometimes data can be presented in PDF files and we prefer to analyse and manipulate in Excel.
There are many websites online converters but ScraperWiki is fast and easy, taking less than five steps to get the Excel file ready to be scrutinised.
Step 1. Get the data
I am going to use a PDF file from the United Nations on the number of military and police contribution as an example. It can be downloaded here.
Step 2. Upload the file on ScraperWiki – PDFTables
Go here (PDFTables) and select the document from the computer that you want to convert:
Step 3. Preview the paper and download it as Excel
Once it is converted, the previsualization will show that text and numbers from the PDF have been placed into rows and columns.
This file can be downloaded as an Excel file as a single sheet, multiple sheets, CSV or XML:
Step 4. Open the spreadsheet in Excel
Now the data is clean and ready to be explored:
Do you have any other examples? Let me know in the comments