How to convert PDF files to spreadsheets

pdf ubuntu converter spreadsheet libreoffice
Sergio picture Sergio · Aug 17, 2013 · Viewed 45.3k times · Source

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?

Answer

Dmitry Somov picture Dmitry Somov · Sep 4, 2014

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.

Related questions

How to merge many PDF files into a single one?

I have 16 pdfs that I want to convert into a single one... I am on Ubuntu 10.10, how can I do it?

Read More
How to generate pdf from docbook 5.0

I've written a docbook 5.0 document with the header: <?xml version="1.0" encoding="UTF-8"?> <book version="5.0" xmlns="http://docbook.org/ns/docbook" xmlns:xlink="http://www.w3.org/1999/xlink" xmlns:xi="http://www.w3.org/2001/XInclude" xmlns:svg="http://…

Read More
An efficient way to convert document to pdf format

I have been trying to find the efficient way to convert document e.g. doc, docx, ppt, pptx to pdf. So far i have tried docsplit and oowriter, but both took > 10 seconds to complete the job on pptx file …

Read More