Copy/Paste PDF to Excel

Report · Sep 15, 2019

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)'

Report · Sep 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!

Report · Sep 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?

Report · Sep 15, 2019

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

Report · Sep 15, 2019

Ideally, I would like to be able to highlight the text and copy with formatting from the locked pdf. It does work but it's slow, but it's very quick and easy when I Print Adobe. It's just an extra step though and it would be nice if there's a better way for me to manage my workflow. Is there something I can do with the pdf document? I read something about tags but that confuses me.