How to extract data from PDF file to multiple fields in excel spreadsheet?

Copper Contributor

I am having a excel file in which I want to extract data from a PDF files and want that spreadsheet to get updated whenever a new file is saved in PDF file folder.

 

So, my main concern is that I am having a macro enabled excel file with which we makes invoice and after printing invoice it gets saved as PDF. Now I want data of that PDF files get entered into the excel spreadsheet automatically. 

 

I am attaching link of excel file I hope somebody will help.

 

https://docs.google.com/spreadsheets/d/1750uJcm2uVDrZoI0J8M-luJdXwD-4poa/edit?usp=share_link&ouid=11...  

 

  

1 Reply

@Gautam_Matani 

Perhaps Power Query works, but it depends on which Excel platform/version you are and how PDF files are structured.