How we can Extract data from PDF to Excel file?

  • 25 June 2020
  • 3 replies
  • 39 views

I tried to extract data from PDF to Text file.

 

I'm trying to do it in Excel, but it was not working.

Can you suggest me something?


3 replies

Hello,

 

Please check the follow related article in KryoNet:

 

https://kryonsystems.force.com/KryoNet/s/question/0D51o00006eBCZrCAO/how-to-read-and-extract-contents-from-digital-pdf-documents

 

This way you could be able to read the data from the PDF file.

Please note that if you want to store the data in to a text file you have to add a “Write to text file” advance command inside the “Analyze digital PDF file” loop.

 

In case that you are facing any errors please share them, also please specify which version of RPA you are using.

 

Please let us know if you have any additional questions on the matter.

 

Thank you.

Thanks for your response.

 

This is not the solution I'm looking for. I'm looking to convert the PDF to Excel.

Already I have converted PDF to Text and removed the blank spaces but I'm not getting the desired result into excel.

 

Can you help me out. (I'm using the Kryon Trial version 19.1)

 

Hello,

 

You can easily put your data to excel using “Paste to Excel” advance command.

Please note that most probably you will have to additionally format the data before using the command, so the cells are populated correctly. It’s highly dependent on your current scenario.

 

Thank you.

Reply