Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Feb 2008
    Posts
    1,023
    Thanks
    63
    Thanked 2 Times in 2 Posts

    PDF to CSV Converter

    I am looking for a software that converts PDF to CSV file format

    I have a PDF file that is downloaded each month from a supplier , but need it to be in CSV format as the CSV file needs to be uploaded in a program that extracts certain fields from the csv file

    I would like the PDF data to be converted to CSF format on one sheet

    It would be appreciated if someone can recommend suitable software to be able to do this efficiently

  2. #2
    Platinum Lounger
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    3,837
    Thanks
    7
    Thanked 253 Times in 238 Posts
    I can't see how you can do this automatically as the PDF format doesn't define which bit you want as CSV. What you can do is open the PDF in a PDF reader / Word / OpenOffice / LibreOffice and extract the data manually, if, and only if, the PDF is NOT published as an image. If the PDF is in a consistent format you could probably write a macro to extract the data, copy it to a spreadsheet and save as CSV. To test if this is possible, open the PDF in a PDF reader and try to select the text / data, then copy and paste into a spreadsheet.

    cheers, Paul

  3. #3
    5 Star Lounger
    Join Date
    Feb 2008
    Posts
    1,023
    Thanks
    63
    Thanked 2 Times in 2 Posts
    Hi Paul

    Thanks for the information. The PDF is not published as an image. Are there any PDF readers you can recommend? I will also try Libre Office

    I found some software that can convert PDF to CSV but reluctant to purchase unless recommended by others on a forum

    http://www.sharewareguide.net/Busine...converter.html

  4. #4
    Platinum Lounger
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    3,837
    Thanks
    7
    Thanked 253 Times in 238 Posts
    Adobe is the standard, but forum users seem to recommend Foxit - I use Foxit for that reason.
    Given all current word processors will open PDF files I wouldn't rush to buy anything.

    cheers, Paul

  5. #5
    5 Star Lounger
    Join Date
    Feb 2008
    Posts
    1,023
    Thanks
    63
    Thanked 2 Times in 2 Posts
    Thanks for this info, Paul
    Last edited by HowardC; 2014-06-14 at 08:53.

  6. #6
    Silver Lounger
    Join Date
    Oct 2012
    Posts
    2,147
    Thanks
    12
    Thanked 248 Times in 241 Posts
    I wonder why it seems more and more PDFs are being used when the data they contain needs to be edited or extracted at the other end because the conversion process usually has a variable but persistent error rate. In my mind these should all be encrypted zip files containing the original copies.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •