Things to ponder:
Excel VBA will limit you to Ms windows, and windows tools.
To make your code global, and usable from non ms tools I'd use pandas.
There are several options for storing your data, to a CSV as you suggest, but a more flexible method would be to store to a simple database like sqlite. Or simple save the pandas dataframe, using pickle see:
https://pandas.pydata.org/pandas-docs/st...ickle.html
Merely a suggestion. In the end, it's whatever floats your boat