Philiprehberger.CsvKit

Lightweight CSV reader and writer with header mapping, type conversion, and streaming support.

Installation

dotnet add package Philiprehberger.CsvKit

Usage

using Philiprehberger.CsvKit;

// Read CSV into strongly-typed records
var people = Csv.Read<Person>("Name,Age\nAlice,30\nBob,25");

// Write records to CSV
string csv = Csv.Write(people);

Reading Raw Rows

// Read as string arrays
foreach (var row in Csv.ReadRows("a,b,c\n1,2,3"))
{
    Console.WriteLine(string.Join(" | ", row));
}

Custom Options

var options = new CsvOptions { Delimiter = ';', HasHeader = false };
var rows = Csv.ReadRows("1;2;3\n4;5;6", options);

Column Projection

// Only map specific columns by header name
var options = new CsvOptions { Columns = ["Name", "City"] };
var people = Csv.Read<Person>("Name,Age,City\nAlice,30,Berlin", options);
// people[0].Age is 0 (default) because Age was not projected

Automatic Delimiter Detection

var text = "Name;Age;City\nAlice;30;Berlin";
char delimiter = CsvReader.DetectDelimiter(text);
// delimiter is ';'

var options = new CsvOptions { Delimiter = delimiter };
var rows = Csv.ReadRows(text, options);

Comment Line Support

var csv = "Name,Age\n# This is a comment\nAlice,30";
var options = new CsvOptions { CommentChar = '#' };
var people = Csv.Read<Person>(csv, options);
// Comment lines are skipped

Row Filtering

var options = new CsvOptions
{
    SkipRow = row => int.Parse(row[1]) < 18
};
var adults = Csv.Read<Person>("Name,Age\nAlice,30\nBob,12", options);
// Only Alice is returned

Streaming Reader

using var reader = new CsvReader(new StringReader(csvText));
while (reader.ReadRow() is { } row)
{
    Console.WriteLine(string.Join(", ", row));
}

Streaming Writer

using var writer = new CsvWriter(new StringWriter());
writer.WriteRow(["Name", "Age"]);
writer.WriteRow(["Alice", "30"]);

API

Method	Description
Csv.Read<T>(string, CsvOptions?)	Parse CSV string into typed records
Csv.Write<T>(IEnumerable<T>, CsvOptions?)	Write typed records to CSV string
Csv.ReadRows(string, CsvOptions?)	Parse CSV string into string arrays
Csv.ReadWithHeaders(string, CsvOptions?)	Parse CSV and return headers and data rows separately
CsvReader.ReadRow()	Read the next row as a string array
CsvReader.ReadAllRows()	Read all remaining rows
CsvReader.DetectDelimiter(string, int)	Detect the most likely delimiter in CSV text
CsvWriter.WriteRow(string[])	Write a single row
CsvMapper.Map<T>(string[], string[])	Map header/values to a typed object

CsvOptions

Property	Type	Default	Description
Delimiter	char	,	Field delimiter character
QuoteChar	char	"	Quote character for enclosing fields
HasHeader	bool	true	Whether the first row is a header row
CultureInfo	CultureInfo	InvariantCulture	Culture for type conversions
Columns	IReadOnlyList<string>?	null	Column names to include; null means all
CommentChar	char?	null	Character that marks comment lines
SkipRow	Func<string[], bool>?	null	Predicate to skip rows; true means skip

Development

dotnet build src/Philiprehberger.CsvKit.csproj --configuration Release

Support

If you find this project useful:

⭐ Star the repo

🐛 Report issues

💡 Suggest features

❤️ Sponsor development

🌐 All Open Source Projects

💻 GitHub Profile

🔗 LinkedIn Profile

License

MIT