Export document to Word to extract tables to use in Excel

Forum|Forum|2 years ago
August 26, 2023
2 replies
1043 views

It was straight forward to export a pdf document to word. Then you copy the table from the word document. You go to excel sheet and you paste the table using the feature "Paste Match destination formatting" then you get all your table data in the sheet and you can add subtract & do whatever.
Now this is not happening, when you paste in excel sheet with Match destination formatting it will paste it like an image. Hence you won't be able to use in excel. Something happened in the past couple of months that is not allowing the extract, copy, paste with matching format to work anymore.

This topic has been closed for replies.

JR Boulay

Community Expert

Try with this attached document.

Acrobate du PDF, InDesigner et Photoshopographe

Monday_Sales_Report.pdf

JR Boulay

Community Expert

You don't need to export to Word, you can copy(with formatting) from Acrobat and paste directly in an Excel sheet.

Acrobate du PDF, InDesigner et Photoshopographe

Khaled ShammaaAuthor

Participant

Thank you very much for your answer but it is not marking the text as text
instead, it is selecting the whole table as an image ...lucky me I right clicked and exported this image to word (only option) and at last was able to copy from word and paste in excel and my problem is solved. Too many steps but at least I am back to work . Thank you so much for your hint it really helped a lot

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded