Without any special software, there is a great tool called the Alt key. If you want to copy the data into excel a column at a time, you click on the top of the column in pdf and hit the Alt key as you drag across the data in that column. This assumes you have a document with recognizable text. When highlighted, hit copy and paste. Repeat for each column. Yes, this is old style, but it is handy.
If no suitable solution can be found, you can also use Tabula rasa or OCRmyPDF and extract all your data from the PDF file using our parser. Please have a look at Doc parser website. Click here for installation details. For those who are wondering what PDF extraction is all about we have a short explanation. When converting PDF files into relational tables, you are not just looking to extract data but also to make the tables “look pretty”. This is not something that you need to worry about if you are storing the PDF in plain text files for some reason. Converting to JSON Converting data to CSV, Excel or other databases is also possible. There were several online services offering PDF conversion tools in the past, but this was when PDF was not really standardized. The standardization of PDF allowed us to use one of the most powerful data-extracting.