Skip to main content
B
Barry28758648qc10
Participant
March 7, 2023
Question

PDF Conversion issues

  • March 7, 2023
  • 1 reply
  • 1701 views

Hi , 

 

im hoping someone can shed some light on this.  

 

we have been happily using acrobat to convert files to excel amongst much much more over the years and suddenly now having issues.  it would SEEM to be related to the PDF but i have no recouirse with how they have been created so would like to understand if any setting could be changed somehwere within the application that would offer a resolve !

 

The problem is that when we export the PDF to Excel , Much of the data looks great , seperated properly but then some is mis-alligned , Wrapped text and lines are merged which would mean sorting that before then resuming the tasks needed within Excel.  

 

My only workaround so far is to export to Word and then copy and paste the data needed into Excel which is ok but obvious adds a step. 

 

Anyone come across this ? 

 

Attatched are snips or Correct and incorrect data exported 

This topic has been closed for replies.

1 reply

Dave__M
Community Expert
Dave__MCommunity Expert
Community Expert
March 7, 2023

Conversions accuracy from PDF to other formats are dependent on how the PDF itself was created.  That said, I have always found that a clean-up process is nearly always required.  Is this a consistent issue, or limited to just a certain or collection of PDFs?

Dave

    B
    Barry28758648qc10Author
    Participant
    March 8, 2023

    Thanks for that @Dave__M , perhaps ive just had it too good with no cleanup needed at all up until now.   We convert a bunch of docs monthly to excel so we further manipulate and suddenly its just started happening.  I can get no information from the sender on what may have changed as i cant seem to get to speak the person i need to.   Also , wheen comparing the historical PDF's that work to those that dont i can see no difference.   the added step of word conversion is working just awkward 

    Dave__M
    Community Expert
    Dave__MCommunity Expert
    Community Expert
    March 8, 2023

    Got it.  As for not being able to see a difference between the historical PDFs and the newer ones... two PDFs can look identical, and be radically different in how they are constructed under the skin. Just a fact of life with PDFs one acquires vs. creating one.

    My best,

    Dave

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