Skip to main content
A
Aleksandra24521440jn0p
Participant
May 23, 2022
Question

Merged cells issue

  • May 23, 2022
  • 2 replies
  • 614 views

Hello,

Hello,

Does anyone have a suggestion how to quickly transform data table I exported from PDF to Excel. Is there a more effective way to export PDF files to Excel? I already tried using Power Pivot "Get Data" and it returns empty tables, so I cannot use this option. One example would be below. I have tons of tables that I need to "clean up". Sometimes it is merged cells, sometimes a column missing a year header, etc. I am using an Acrobat PDF exporter....Thank you!

Please see this example. There is a merged cell that contains a lot of data in it.

 

This topic has been closed for replies.

2 replies

try67
Community Expert
try67Community Expert
Community Expert
May 30, 2022

Unless the file has been properly tagged, exporting a PDF to another format will never be 100% accurate, as PDF files were meant to be the last stage in the document workflow.

Meenakshi_Negi
Meenakshi_Negi
Legend
May 29, 2022

Hi Aleksandra,

 

Sorry for the delay in response.

 

Could you please confirm if you experienced this issue with a particular PDF?

Are you trying to export PDF using the Acrobat Online account?

Would it be possible to share the PDF with us so we can replicate the behavior?

 

Thanks,

Meenakshi

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