PDF to EXCEL Automation PO

Hello Team,

Is there any API that converts PDF purchase orders to EXCEL file? Or any pdf to excel converter software? The pdf format is bit complicated and semi or unstructured data. It's not tabular data. One line item will have 5 columns like Number, Desc, Qty, UOM, Unit price. But in the pdf, there is no clear line/border to separate these columns. Also, the line item may be multi-line - like the Desc column is 2 lines for 1st line item, 3 lines for 2nd line item.

Attached the sample with line items.

Please support.
 

Attachments

  • PDF to EXCEL.PNG
    12.1 KB · Views: 17
It's possible to extract the information you need by using the PDF Extract Text activity, ensuring that the "Structured text" option is selected, and looping through each line of the resulting text file. You can use regular expressions with the various String Operations to get the information you need.
 
Hello Team,

Is there any API that converts PDF purchase orders to EXCEL file? Or any pdf to excel converter software? The pdf format is bit complicated and semi or unstructured data. It's not tabular data. One line item will have 5 columns like Number, Desc, Qty, UOM, Unit price. But in the pdf, there is no clear line/border to separate these columns. Also, the line item may be multi-line - like the Desc column is 2 lines for 1st line item, 3 lines for 2nd line item.

Attached the sample with line items.

Please support.
Hey there!
Yes! I have very good software for converting PDFs to Excel. The seotoolsystem is the best software for conversion. I am trying this software, which gives very quick responses and good results. If you are interested to convert your documents so please visit................
 
Top