Recently we came across a great csv helper Nuget package libararry from Josh Close. You could easily find it in the Nuget solution search. I would highly recommend it. Its an incredible option to read CSV and Write to a CSV file as well.I have used it for both of these scenarios and the reading / writing was very easy. Works very well with Azure Functions, Web jobs etc. Simple examples can be found on the below links.
https://joshclose.github.io/CsvHelper/getting-started#reading-a-csv-file
https://joshclose.github.io/CsvHelper/getting-started#writing-a-csv-file
https://joshclose.github.io/CsvHelper/getting-started#reading-a-csv-file
https://joshclose.github.io/CsvHelper/getting-started#writing-a-csv-file