read multiple PDF files in Alteryx and convert (output) them to Excel workbook?

[gurpreet-singh]

Hi Community, 

I have a batch of 50+ PDF files that I would like to convert to Excel workbook. 

keeping the same name for each file. 

Is it possible using Alteryx?

so 50PDF's -->> 50 excel files

any help/support would be much appreciated. 

[Aguisande]

Hi @gurpreet-singh 

Yes, can be done, but you'll need an external tool to capture the contents of the PDF.

Maybe you can use some R or Python packages to get the contents from within the PDF files first.

This macros can give you a good starting point: 

https://gallery.alteryx.com/#!app/PDF-Input--Text-and-Image-/5be5ec8d0462d71ffce6deaa

https://gallery.alteryx.com/#!app/PDF-Input/5b685aff0462d710907f7a3b

Hope this helps pointing you in the right direction.

Best

_AG_

PS: I used PDF2Text for a similar project, so it can be helpful too.