I would stuff the CSV file somewhere in the data directory, then create a content adapter. See:
- https://gohugo.io/content-management/content-adapters/
- https://gohugo.io/functions/transform/unmarshal/
This might be helpful too:
https://discourse.gohugo.io/t/content-adapters-examples-and-performance/49830