• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers

Merged cells issue

New Here ,
May 23, 2022 May 23, 2022

Copy link to clipboard

Copied

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.

Aleksandra24521440jn0p_0-1653309814260.png

 

TOPICS
Export PDF

Views

45

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Adobe Employee ,
May 29, 2022 May 29, 2022

Copy link to clipboard

Copied

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

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Community Expert ,
May 30, 2022 May 30, 2022

Copy link to clipboard

Copied

LATEST

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.

Likes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources