How to convert PDF invoices into excel/csv format

Hello Folks,

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

Thanks
Minal

HI @minal.patil

Check out this Video link

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 :

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

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