pdf to excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2187797%22%20slang%3D%22en-US%22%3Epdf%20to%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2187797%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20friends%2C%3C%2FP%3E%3CP%3ECan%20you%20help%20me%20to%20transfer%20the%20Pdf%20file%20to%20excel%20so%20that%20a%20i%20get%20each%20line%20and%20column%20of%20the%20pdf%20on%20a%20correlative%20line%20and%20column%20on%20an%20excel%20table%3F%3C%2FP%3E%3CP%3EPlease%20note%20that%20a%20have%20dozens%20of%20pdf%20files%20to%20import%20in%20case%26nbsp%3B%20there%20is%20a%20macro%20or%20power%20pivot%20way%20to%20do%20it.%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%2C%20yasmine%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2187797%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Dear friends,

Can you help me to transfer the Pdf file to excel so that a i get each line and column of the pdf on a correlative line and column on an excel table?

Please note that a have dozens of pdf files to import in case  there is a macro or power pivot way to do it.

Thank you in advance, yasmine

1 Reply

@yasmina2070 

As far as I know, it will be possible to transfer data from pdf to excel with the new Office 365.

Just know that it is slowly being added to most versions in these subscription packages.

 But my knowledge is very limited there.

As for your PDF, it is a photocopy from a multifunction device that will automatically convert it to PDF.

Not a pdf in terms of data entry.

This means that your pdf must first be processed with OCR and then inserted into excel as data.

Or you can use Adobe Acrobat Pro DC as a program where it automatically converts to Excel.

This will be as I indicated above.

With VBA you can automatically convert all sheets from Excel to PDF.

I think that in a short time it will also be possible for microsoft office subscriptions to add data from PDF to Excel.

 I have inserted the example in the excel sheet.

 

Wish you a nice day.

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.