Results 1 to 11 of 11
  1. #1
    New Lounger
    Join Date
    Apr 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pasting reports from PDF to Excel (Office 2000)

    Hello. Our users have to paste a lot of reports from PDF docs to Excel. The best (but not so quick) method we've found is to have them use the column select tool. We wondered however if there's a quicker way to do this (be able to select a whole table at once, and paste it into Excel so that it's automatically divided into the same type of columns that it had in the PDF. Any help would be greatly appreciated!

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Pasting reports from PDF to Excel (Office 2000)

    Are you making the PDF's yourself?

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    New Lounger
    Join Date
    Apr 2003
    Posts
    10
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting reports from PDF to Excel (Office 2000)

    The PDF documents are somehow generated from a Peoplesoft report. I don' t know any more details. I learned today that if you have the full version of Acrobat 5.0, there is a table select tool, but I cannot guarantee that our users have the full version. So, I wondered if anyone has found a way to push content into Excel from Reader 5.0, in an efficient way.
    Thank you.

  4. #4
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Pasting reports from PDF to Excel (Office 2000)

    The best I can do for you is to suggest that you save the PDF as an .rtf file, but you will need permission in Acrobat to do so - you may need to talk to the person generating these files.
    Open in Word, replace the spaces between cells with tabs. You can then copy/paste directly from Word into Excel. Perhaps one could do something more within Acrobat itself - but this is the first thing I've come across..

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting reports from PDF to Excel (Office 2000)

    Acrobat does not do a very good job of saving PDF as RTF.

    You could purchase other software, such as OmniPage Pro, which may do a better job of converting PDF to RTF.

    Or, you could save the PDF pages as, say, TIFF, or JPEG or ... images and insert those images into Excel..

    Or you can use Acrobat and manually Copy and Paste into Excel.

    Or, if the documents were originally created in Word, you could use macros to Copy and Paste stuff into Excel.

  6. #6
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting reports from PDF to Excel (Office 2000)

    Can you get whoever is sending you the pdf to export the reports into Excel for you and distribute them to you in that format, or am I oversimplifying the issue?

    - Brett

  7. #7
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Pasting reports from PDF to Excel (Office 2000)

    I tested that with my copy of Acrobat - it doesn't have an export to Excel feature <img src=/S/sigh.gif border=0 alt=sigh width=15 height=15>.

    Cheers
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Ankeny, Iowa, USA
    Posts
    298
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting reports from PDF to Excel (Office 2000)

    I actually meant can the reports be output to Excel from Peoplesoft? I don't know anything about Peoplesoft, but if you can export to PDF, it's possible there's more than one option for exporting reports...

    >>The PDF documents are somehow generated from a Peoplesoft report. I don' t know any more details.<<

  9. #9
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Pasting reports from PDF to Excel (Office 2000)

    I know zip about peoplesoft <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>.
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  10. #10
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting reports from PDF to Excel (Office 2000)

    Although I have not done this, I know that our Finance people routinely get output from PeopleSoft directly into Excel. So I would recommend contacting those who provide the data and determine how they can provide Excel (or even CSV) files for your work.

  11. #11
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Missouri, USA
    Posts
    103
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pasting reports from PDF to Excel (Office 2000)

    Yes, I check with our Finance people today. Whoever sets up the database in Peoplesoft can program it to automatically output to Excel files.

Posting Permissions

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