How to convert PDF invoices into excel/csv format

Help Studio
1

Hello Folks,

How to convert full PDF invoices into excel/csv format?

Thanks
Minal

2

HI @minal.patil

Check out this Video link

3

Hi @minal.patil ,

If the PDF is digital and table is following the same format throughout for other samples as well, we could try first to perform by Reading the Table Data as a Text/String data and perform Regex/String manipulations on it.

Some other ways would be to check if the PDF can be accessed/opened as a Word document and then perform Interop.Word operations on retrieving the Table data. One such example is show below :
https://forum.uipath.com/t/how-to-extract-dat-from-pdf-file-row-items-might-be-more-in-many-pages-also-i-have-to-extract-one-by-one-storing-them-in-a-excel/485321/4?u=supermanpunch

Let us know if these two approaches are not working and tell us what is the issue faced.

4

Here’s how it works:
Launch Acrobat and open your PDF file.
Select the Export PDF tool from the menu bar on the right.
Select the Excel file format from the Convert To drop-down menu.
Select the Convert button.
Name your Excel file and select Save.

Regards,
Will