Forum Discussion
LizA2020
Aug 09, 2024Copper Contributor
PDF to Excel - Data Mining
Many years ago I used Monarch to perform data mining extracts from a payers 835 remittance advice into excel. We captured all elements spread throughout the PDF into single line item details. Sadly, the times have changed and what used to cost $150 for the Monarch CD to use is now totally different, costing over $5k for a yearly prescription cost.
I have attached a Mock PDF and a mock of what I want to see in excel. Any thoughts of a program that will not break my tiny little bank would be great. Or, using the data extract option in excel to work properly.
2 Replies
Sort By
- LizA2020Copper Contributor
Thank you but I have looked over the processes that I have found on line and I am unable to comprehend the necessary steps to create a successful excel table.
- AshaKantaSharmaIron ContributorPyMuPDF, PDFplumber, or Camelot for more advanced extraction.