Pdf To Excel Converter.

Discussion in 'Software' started by Eldon, Mar 25, 2018.

  1. Eldon

    Eldon Major Geek Extraordinaire

    I have tried 4 online PDF to Excel converters.

    Smallpdf converted the first 2 lines. :eek:

    Nitro converted only the first page.

    Covert PDF to Excel creates different columns for different pages.

    Online2PDF makes the column width, row height and font size way to small.

    The PDF documents were created with txt2pdf PRO v8.5 © SANFACE Software 2005 and iTextSharp 4.1.6 by 1T3XT.
    Any recommendations?
     
  2. GermanOne

    GermanOne Guest

    Years ago I tried the same without much success. It's the way how data is saved in a PDF file that makes things difficult. The PDF format claims to visualize a document always the same way independently of the used platform or local settings. In order to achive this, tables aren't tables anymore and tabs not tabs. Often a various number of spaces is inserted to separate the data. Try to find a program where you can adjust the column width. But if some data is larger than this column width then you should expect that it will be split at the position where you defined the column edges.

    What I try to tell is that such software can only guess where a column begins and ends and even if you can adjust it manually it may still fail to convert your data properly. If Online2PDF recognizes the columns correctly for your data then keep on using it. It's certainly not a big deal to format the table once you have the right data in the right cells ;)
     
  3. Eldon

    Eldon Major Geek Extraordinaire

    That's what I'm doing.
    After 4 PDFs (2-3 pages each) it's not that big a deal.
    I'm expecting the impossible - looking at the PDF the font is tiny to begin with. How can I expect more? :oops:
     
  4. GermanOne

    GermanOne Guest

    Actually you can but it needs a lot of efforts to write a program with a good customization. I assume those programs are not for free anymore.
    Imagine your program gets raw data like that:
    Code:
    Sizes of machine components.
    width        length
       32 inches    100 inches
      234 inches     18 inches
    Now the program has to guess. Maybe
    Code:
    Sizes|of|machine|components.
    width|  |    len|gth
       32|in|ches   |100 inches
      234|in|ches   | 18 inches
    ... or rather ...
    Code:
    Sizes|of mac|hine c|ompone|nts.
    width|      |length|      |
       32|inches|   100|inches|
      234|inches|    18|inches|
    As you can see Online2PDF is already not too bad if it recognizes the columns as expected ;) You're a lucky guy.
     
    Eldon likes this.
  5. Eldon

    Eldon Major Geek Extraordinaire

    I'm staying with it.
    Unfortunately I started with 4 months invoices combined into 1 PDF totaling 22 pages.
    Next month it'll be just 6-7 pages of which I only need 2-3.
    Thanks for the input.
     
  6. plodr

    plodr MajorGeek Super Extraordinaire Moderator Staff Member

    I don't mean to sound smart but sometimes it is just easier to retype the thing in Excel instead of trying to convert something and being unhappy with all the results.
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds