Parsing CSV files in C#, with header

by

A CSV parser is now a part of .NET Framework.

Add a reference to Microsoft.VisualBasic.dll (works fine in C#, don’t mind the name)

using (TextFieldParser parser = new TextFieldParser(@"c:\temp\test.csv"))
{
    parser.TextFieldType = FieldType.Delimited;
    parser.SetDelimiters(",");
    while (!parser.EndOfData)
    {
        //Process row
        string[] fields = parser.ReadFields();
        foreach (string field in fields)
        {
            //TODO: Process field
        }
    }
}

The docs are here – TextFieldParser Class

P.S. If you need a CSV exporter, try CsvExport (discl: I’m one of the contributors)

More Related Contents:

  1. Write to a file from multiple threads asynchronously c#
  2. How to have nested query with LINQ
  3. Unable to read from a CSV using List
  4. How to split csv whose columns may contain ,
  5. Reading CSV file and storing values into an array
  6. File being used by another process after using File.Create()
  7. How can I read a file even when getting an “in use by another process” exception?
  8. How do I read a specified line in a text file?
  9. Wait Until File Is Completely Written
  10. Getting path relative to the current working directory? [duplicate]
  11. C#, regular expressions : how to parse comma-separated values, where some values might be quoted strings themselves containing commas
  12. How to create CSV Excel file C#? [closed]
  13. How can I determine if a file is binary or text in c#? [duplicate]
  14. Find out username(who) modified file in C#
  15. How to copy a file to another path?
  16. Read binary file into a struct
  17. Detect if PDF file is correct (header PDF) [closed]
  18. Read from a file starting at the end, similar to tail
  19. What is the difference between StreamWriter.Flush() and StreamWriter.Close()?
  20. C# – Check if File is Text Based
  21. OpenFileDialog can’t load CSV files but can load xls/xlsx Excel files [duplicate]
  22. ValueError : I/O operation on closed file
  23. How do you read a file which is in use? [duplicate]
  24. Writing a CSV file in .net
  25. open file in exclusive mode in C#
  26. Upload CSV file to SQL server
  27. File.GetLastWriteTime seems to be returning ‘out of date’ value
  28. Does FileStream.Dispose close the file immediately?
  29. Using async / await with DataReader ? ( without middle buffers!)
  30. Writing a Header using CsvHelper? C#

Leave a Comment