Forum Discussion

LizA2020's avatar
LizA2020
Copper Contributor
Aug 09, 2024

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

  • LizA2020's avatar
    LizA2020
    Copper 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.

     

Resources