Reading CSV files using CSVHelper package (C#, IEnumerable)

I have come across many times the need to incorporate the reading of CSV files in an application.  Below I will show how to use Josh Close’s CsvHelper to  import a CSV file which looks like the following (file will be included below).

Argentina,Argentine Republic,54,ARG
Armenia,Republic of Armenia,374,ARM
Australia,Commonwealth of Australia,61,AUS
Austria,Republic of Austria,43,AUT
“Bahamas, The”,Commonwealth of The Bahamas,-241,BHS
Bangladesh,People’s Republic of Bangladesh,880,BGD

Note this CSV file is a simpler file based on the file which is located here.

The first thing to do is to Install CsvHelper.  To do this run the following command in the Package Manager Console:

Now add CsvHelper to the program by adding:

The next step is to create a class which has properties with the same name of the column headings found in the csv file.  Below you will find an example of a class which does this:

Finally create an instance of CSVReader and invoke the GetRecords method using the DataRecord class.  Below you will find an example of this:

An completed example can be found below:

You can download this sample code with  CsvHelper and CSV file here: CVSHelperReadSample

About Carlos Ferreira


  1. Jason Canter says


  2. Luis Santos says

    You have a small type before creation of the reader class. Thanks for putting this up.

  3. Csvreader doesnt have a GetRecords

    • Hi Matt –

      Sounds like you might have not loaded CSVHelper correctly in your project. Follow the steps for adding it via Nuget in your project. There’s a sample project you can download if you want to experiment (link is at bottom of screen).



  4. Ah, I figured it out. I had my .Net framework set to 2.0 when I installed the csvhelper package. Uninstall, change to 4.0, reinstall fixed it.

    Also, I noticed there is a difference between this page and the sample project.

    IEnumerable should be IEnumerable

  5. We are trying to parse a csv file in which the the field delimiters are identified by ^ and end of a record identified by ~. I know there is an option for setting the field delimiter in csvhelper but how do we tell it the delimiter for end of a record.
    Many Thanks

    • Hi Hassan –

      Thanks for visiting. I looked at the source and it looks like there is not. It doesn’t look like it would be difficult to change if you look at the ReadLine method in CsvParser.cs. I would think that this would be useful for parsing files from legacy systems. i might have a stab at seeing if it can be added later on.



      • That would be great. Thanks.
        I just thought of something else, the file we are trying to parse has text fields which could have carriage returns in them so making the end of a record something other than newline is mandatory in situations like this.
        Thanks again.

    • In the latest version you can specify this to change the delimiter:

      csv.Configuration.Delimiter = “,”;

  6. Gerson Cardoso Filho says

    Thanks fot the help!

  7. Wooooow!! This is very helpful and simple ! Thanks:D

  8. Ozer Arslan says

    Hello Carlos, Thank you for your sharing. When I run your sample program. I got following error.
    “CsvHelper.HeaderValidationException: ‘Header with name ‘CommonName’ was not found. ”

    Could you send me your comments on this.


  1. […] is a follow-up on my post on how to read a CSV file using Josh Close’s CsvHelper.  CsvHelper is a fast and […]

  2. Stefan says:


    Reading CSV files using CSVHelper package (C#, IEnumerable)

Leave a Reply to Carlos Ferreira Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: