Quickly convert column of currency amounts to other currency via historical data?

Hi

I traded crypto spot markets in 2020 and am now in the process of journaling all those trades.


I want to know if via excel I can create something that instantly converts all the amounts of BNB trading fees in column G to USD using exchange rates from historical price data from 2020.



I tried googling for a free BNBUSD converter type tool that lets me input the amount of BNB I want converted and to what currency, date+time in the past to lookup the exchange rate then and tell me how much that BNB was worth at that moment. Unfortunately, couldn’t find anything.



I do not want to resort to manually scrolling through 1000s of rows of timestamps in a downloaded excel sheet to individually convert the fees of each 100+ trades.



From what people have told me I need a table with all the historical data. I did find a 400+mb excel file with 1m OHLC data going back to 2017 (more rows than the max excel will allow). Will this work for what I want to do? How do I use it? What's the next step?



Do I still need to mess around with APIs or do I have everything I need with this big excel file?



Is this whole process actually really quick,easy and straight forward for an excel pro?



I have no clue what I'm doing and have been at this for hours.



See attached



Thanks