Which is the best Software you can buy to convert PDF into Excel ?
Thread poster: Rita Utt

Rita Utt  Identity Verified
France
Local time: 17:39
Member
English to German
+ ...
Jan 10

For translation of annual reports, so I'm not interested in free online tools ...
Is there an efficient tool to extract all those tables into Excel (without having to check all numbers?)
I do have a very old Abby Fine Reader, but it's no good for tables.
Any better ideas or a newer version you could recommend ?


 

Bernd Albrecht
Germany
Local time: 17:39
English to German
I don't know if it's really "the best PDF converting software" money can buy Jan 10

Have you tried this one?

https://acrobat.adobe.com/us/en/acrobat/export-pdf-online-pricing.html


 

Dan Lucas  Identity Verified
United Kingdom
Local time: 16:39
Member (2014)
Japanese to English
Do you mean dead PDFs? Jan 10

Rita Utt wrote:
I do have a very old Abby Fine Reader, but it's no good for tables.

Rita, do you mean PDF files that are not machine-readable? In that case it's down to OCR, and I have found v14 of FineReader reasonably good at that. However, I have found most annual reports are machine-readable these days.

Regards,
Dan


Merab Dekano
 

Rita Utt  Identity Verified
France
Local time: 17:39
Member
English to German
+ ...
TOPIC STARTER
Machine readable ? Jan 11

Hello,
thank you for your answer,
but sorry, I'm not very good in PDF-technology.
Does machine readable mean, PDF-Files I could write in, if I had the appropriate software (which would be what ?) ?


 

Rita Utt  Identity Verified
France
Local time: 17:39
Member
English to German
+ ...
TOPIC STARTER
Hello Bernd Jan 11

I would like to use an online-Tool, but I'm worried about confidentiality ...
Or do you think I shouldn't be ?


 

Samuel Murray  Identity Verified
Netherlands
Local time: 17:39
Member (2006)
English to Afrikaans
+ ...
@Rita: no, none Jan 11

Rita Utt wrote:
Is there an efficient tool to extract all those tables into Excel (without having to check all numbers?)


No, you're always going to have to check the numbers.

Even if the PDF is editable, i.e. you can copy the text and paste it in a text editor, you can't predict in which sequent the PDF creator added the numbers. Programs that outputs PDF do not write the table cells in necessarily the same sequence as in Excel (often there doesn't seem to be any logic to it). In addition, as you may know, copy/pasting from a table sometimes converts the tabs into spaces, but sometimes converts them into nothing, so numbers end up all squished together. So even if you can copy/paste the numbers, you'd still have to check them.

There was a time when I translated annual and financial reports, and for that I always used Acrobat 5.0.5 to copy the text, because Acrobat 5.0.5 has a block copy feature called "column select" which was replaced in modern versions of Acrobat with something called "graphics select", which can't copy blocks of text. However, most modern PDF files are "PDF 1.6" files, and Acrobat 5.0.5 can only open PDF 1.4, and the only way I know of to convert a PDF 1.6 file to a PDF 1.4 file is by using an online converter. Also, not all columns in PDF files like to be selected, so sometimes you just can't win.

Added: I just discovered that my current PDF program (PDF X Change) can copy columns, if you press the Alt key while dragging with the mouse.

[Edited at 2019-01-11 09:41 GMT]


 

Heinrich Pesch  Identity Verified
Finland
Local time: 18:39
Member (2003)
Finnish to German
+ ...
Error prone process Jan 11

I would ask for the original file format, Excel or whatever, and not try to convert to from pdf. It might take ages to get the stuff formatted. If the customer does the conversation themselves, that's another possibility. You translate that and the customer takes over the formatting. If the result is not good enough its not your problem.

neilmac
 

Dan Lucas  Identity Verified
United Kingdom
Local time: 16:39
Member (2014)
Japanese to English
Can be read by CAT or other tools Jan 11

Rita Utt wrote:
Does machine readable mean, PDF-Files I could write in, if I had the appropriate software (which would be what ?) ?

For many/most recently generated PDF files, the text they contain can be read by software such as SDL Studio, MemoQ, etc. So you can often import the file, translate the text, and then create a Word file that is similar to the original. If you use a CAT tool, try it with an annual report created within the past 12 months.

But also, if you have a client who is inquiring about it, why not ask them if they have a recommended work flow.

Regards,
Dan


 

John Fossey  Identity Verified
Canada
Local time: 11:39
Member (2008)
French to English
Get the orriginal file Jan 11

I have several clients that come to me each year for their annual report. For these I have asked for the original file, since no document was originally created as a PDF file. Some were created in Word, others were created in InDesign. The tables are often embedded Excel files. All these formats can be translated directly in a CAT tool, eliminating the need of conversion.

[Edited at 2019-01-11 14:21 GMT]


 

Drew MacFadyen
SITE STAFF
ProZ.com Plus members receive 10 free credits at TransPDF a month Jan 11

ProZ.com Plus members have access to 10 free credits at https://www.iceni.com/transpdf.htm per month. Simply login using your ProZ.com profile. Non-members can purchase credits at a discount. That said, I've no information as to TransPDF ability to maintain the formatting of data in Excel tables.

Regards,

Drew MacFadyen


 

Rita Utt  Identity Verified
France
Local time: 17:39
Member
English to German
+ ...
TOPIC STARTER
Your are right Jan 11

I'll ask for the original files (before conversion to PDF), much safer.
Have a nice year, all of you and thank you very much for your help.
Rita


 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Which is the best Software you can buy to convert PDF into Excel ?

Advanced search






memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search