+ Reply to Thread
Results 1 to 6 of 6

PDF to Excel Conversion

  1. #1
    Registered User
    Join Date
    07-09-2016
    Location
    Manchester, Englanr
    MS-Off Ver
    2016
    Posts
    2

    PDF to Excel Conversion

    Hi,

    I am a self employed courier and my delivery manifest is given to me each morning, I then input the post codes manually directly into Auto Route (I know its not supported anymore - but still the best).

    I can import date from excel into Auto Route but not PDF's

    Is there any way to convert this PDF document to an Excel spreadsheet?

    Thanks
    Stevie

  2. #2
    Valued Forum Contributor
    Join Date
    05-11-2013
    Location
    Wales
    MS-Off Ver
    Excel 2010
    Posts
    586

    Re: PDF to Excel Conversion

    Hi Stevie,

    Check out the following.

    https://www.abbyy.com/screenshot-reader/

    Regards

    peterrc

  3. #3
    Registered User
    Join Date
    07-09-2016
    Location
    Manchester, Englanr
    MS-Off Ver
    2016
    Posts
    2

    Re: PDF to Excel Conversion

    Thanks Peter

    I'll give it a go

    Stevie

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    Re: PDF to Excel Conversion

    No need to pay for a converter, see this link, looks like there are some free one's there...
    https://www.google.com/webhp?sourcei...f%20to%20excel
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Contributor
    Join Date
    03-21-2013
    Location
    Corvallis, OR
    MS-Off Ver
    Excel 2010
    Posts
    174

    Re: PDF to Excel Conversion

    Depending on the PDF, converters may not always work. Part of my job for many years involved converting PDF invoices to an excel format for specific data extraction, and I ran into this problem with converters a lot. Sometimes they worked, and sometimes they didn't. My only consistently valid solution was to write my own conversion system that was specific to the particular invoices; i.e. company specific. This was done with a combination of managing copy/paste functions and text manipulation formulas that split up incoming strings into their various parts, often based on the existence of specific characters, string lengths before spaces, and other consistencies within the PDF layout of each company, and VBA code that placed the split results into cells where I wanted them. I never had a PDF I couldn't convert this way, but it can be A LOT of work to get it set up right. So, it's really only worth it if you have to do it a lot, and if the converters do work, then definitely go that route... Good luck!
    If I helped, please click on Add Reputation.

  6. #6
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Office 365
    Posts
    14,987

    Re: PDF to Excel Conversion

    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. PDF to Excel Conversion
    By PCochrane in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-02-2012, 09:07 AM
  2. conversion excel - TO - vba help
    By alphecca in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-11-2011, 05:37 AM
  3. Issue with Conversion of Excel 2010 file to Excel 2007
    By vipulunadkat in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-07-2010, 01:09 AM
  4. Excel xls to txt conversion
    By addictive_mate in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-24-2010, 04:49 PM
  5. Pdf To Excel Conversion
    By stevesunfold in forum Excel General
    Replies: 0
    Last Post: 05-15-2008, 03:42 PM
  6. [SOLVED] Excel VBA to VB.NET conversion
    By KreativeKai in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2006, 11:55 PM
  7. [SOLVED] Excel conversion
    By Realstar in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 01-22-2006, 09:25 PM
  8. [SOLVED] Excel to PDF Conversion
    By cheeri0_girl in forum Excel General
    Replies: 0
    Last Post: 04-12-2005, 08:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1