Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Mar 2004
    Location
    North Carolina, USA
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    .pdf documents Import (2000)

    Is it possible to import a .pdf document into Excel? If so, can you please explain how?

    Thanks.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: .pdf documents Import (2000)

    The general answer is probably "No".

    If the PDF document contains tables, and allows selecting text, click the Text Select tool (a toolbar button with an uppercase T and a dotted square), select a table, copy it to the clipboard and paste it into an Excel worksheet.

    That's about it, I think. Copying paragraphs of text into Excel, although possible, isn't very useful.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: .pdf documents Import (2000)

    The easiest way is probably copy/paste.
    Open the pdf file
    Press the Graphics select tool
    highlight the area to copy
    Edit - copy (or ctrl-c)
    goto excel
    edit - paste or (ctrl-v)

    If you didn't want to add it as a graphic:
    you could create a hyperlink to it
    (ctrl-k, then browse to the file)

    or even insert an object
    (insert -object "create from file" (tab) <browse> to find the file

    Steve

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: .pdf documents Import (2000)

    If you actually want the information to be put into Excel cells as text and numbers, not graphics, then your best choice is probably going to be to print the document. Then us a scanner with OCR (Optical Character Recognition) software to scan the document into a text file. Manually look through the text and correct any scanning conversion errors. Then you can use the text file import wizard to import the text file.
    Legare Coleman

Posting Permissions

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