There are around 560 pdf files that need to be converted to an excel file. All the pdf files have the same format. The pdf files are themselves in a tabular format but I need to add a couple of more columns in the excel which would require basic logic on excel only. All the pdf files are available on a website, the link to which I will provide.
I want a code which downloads all the pdfs one by one and converts and compiles their data in a single excel file.
I am attaching a sample pdf file and the sample of the required o/p excel file. Details for the extra columns required are also mentioned in the excel file with a small comment.