Forum Discussion
Gautam_Matani
May 04, 2023Copper Contributor
How to extract data from PDF file to multiple fields in excel spreadsheet?
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=111356660266135454292&rtpof=true&sd=true
1 Reply
- SergeiBaklanDiamond Contributor
Perhaps Power Query works, but it depends on which Excel platform/version you are and how PDF files are structured.