Skip to main content
T
traceyc28668387
Inspiring
September 15, 2019
Question

Copy/Paste PDF to Excel

  • September 15, 2019
  • 2 replies
  • 1686 views
I had struggles with trying to figure out how to copy data from a PDF to excel.  What I have figured out and how I am currently doing this works very well which I can keep doing, unless there are any better suggestions on how I am currently doing this, with my explanation below from beginning to end.  Is there something I can do with the PDF to make it quicker and easier to copy and paste?  I am using Acrobat.  Thank you in advance for any help!  This is one last issue I need to figure out, I think! 

 

'The PDF was created from a Word Document with a table inserted where I have added text fields for data to populate, which needs to be copied and pasted from the PDF to excel.  I only need parts of the table to copy and paste from the PDF to excel and keep the formatting, formulas are not required.  There are several PDF's with lots of copying and pasting required daily.  I am able to copy and paste from the digitally signed and locked document, however it is very slow, so the only way I have found that is able to quickly copy and paste is to refry the PDF.  After that I hold down the Ctl key, use my mouse to select the data, right click and select copy with formatting, paste into excel and right click again in excel to change the font bigger.  I am now saving the digitally signed and locked PDF (not the refried one I have used to copy/paste) into our Master Filing System (edocs)'

 

    This topic has been closed for replies.

    2 replies

    ls_rbls
    Community Expert
    ls_rblsCommunity Expert
    Community Expert
    September 15, 2019

    Hi,

     

    When you say refry the locked PDF document,  do you mean that you are flattening the document by using Print as PDF method and/or "Save As" postscript(.ps) file?

    T
    traceyc28668387Author
    Inspiring
    September 15, 2019

    I Print then I choose Adobe, sorry not sure what the difference it

    T
    traceyc28668387Author
    Inspiring
    September 15, 2019

    Thank you so much for the replies, it has been super helpful for me!  I hope this isn't a stupid question, but is there a way to track if any changes were made before the last signature has been applied and locked?  Is there something in the PDF that says if the second or third person prior to signing made some changes?  Just curious 🙂  Edit...comments on wrong post....oops!

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices