Skip to main content
N
Nicholas22697639221q
Participant
January 30, 2023
Question

Unacceptable format issues following PDF conversion to Excel

  • January 30, 2023
  • 1 reply
  • 1616 views

I have a paid anniual account to Acrobat for the purpose of converting PDF Bank Statements into Excel for pivot tables and other data interrogation.  The resulting formatting in Excel is totally unacceptable.  The principal errors are: (1) data from different original columns and rows appear in single Excel cells; (2) Logo images need to be deleted; (3) single column data are distributed into several different Excel columns inconsistently.  The time required to adjust manually is self-defeating and if no remedy is easily available I expect a refund of cost.

This topic has been closed for replies.

1 reply

ls_rbls
Community Expert
ls_rblsCommunity Expert
Community Expert
January 30, 2023

Hi,

 

In what operating system, Microsoft Office and Adobe Acrobat Pro versions are you on?

 

Please also describe which method are you using to export PDF to Microsoft Excel?

N
Nicholas22697639221qAuthor
Participant
February 3, 2023

Hi,

 

Many thx for your response and apols delay but other business intervened.  Not remotely technical but I think the info you seek is as follows.  Windows 10 and O365 for MS Office.  The Adobe is Acrobat Export PDF.  From Account Login, I hit 'Access Yiour Services', then under 'Tools', 'Export a PDF' and 'Drag and Drop' the PDF from an open Windows Explorer window.  Then, I downloaded the resulting .xlxs file for use in O365 Excel because I'm not familiar with editing the web Excel file...although I notice the format errors appear in that latter too.

 

Hope this gives you what you need.  Any suggestions much appreciated. 

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