Menu
I have been trying the whole day to convert several. pdf files which contain traffic flow for São Paulo to spreadsheets like MS Office Excel, or LibreOffice Calc in Ubuntu. When I open the .pdf file with LibreOffice Calc it opens LibreOffice Draw, and I can't get the spreadsheet.
The most promising method that I found was here with pdftotext. It works fine and I can get the tables in LibreOffice Calc but adjusting manually the columns.
My problem is that I have so many .pdf files that it would take me a lot of time.
Does anyone know a better method?
234
How to convert PDF files into Excel spreadsheets: Open a PDF file in Acrobat. Click on the “Export PDF” tool in the right pane. Choose “spreadsheet” as your export format, and then select “Microsoft Excel Workbook.”
Follow these easy steps to turn a PDF document into a Microsoft Excel spreadsheet: Click the Select a file button above, or drag and drop a PDF into the drop zone. Select the PDF you want to convert to the XLSX file format. Watch Acrobat automatically convert your PDF to Excel.
Go to Edit > Preferences > Security (Enhanced). Uncheck the Enable Protected Mode at startup under Sandbox Protections pane. Click Ok. Relaunch PDF reader.
Another option is to use Okular (http://okular.kde.org). It has table selection tool (Ctrl+5). You may select a table, add lines for additional rows and columns and copy the resulting table into a clipboard. It works fine for me.
190
Tabula can work quite well. PDF is not an easy format to extract structured information from, so it's not always possible.
19
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
