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

Merged cells issue

New Here ,
May 23, 2022 May 23, 2022

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.pngexpand image

 

TOPICS
Export PDF
458
Translate
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

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

Translate
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
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.

Translate
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