CsvHelper

# CsvHelper

<!-- docs:exclude -->
[![NuGet Version](https://img.shields.io/nuget/v/CsvHelper.svg)](https://www.nuget.org/packages/CsvHelper)
[![NuGet Downloads](https://img.shields.io/nuget/dt/CsvHelper.svg)](https://www.nuget.org/packages/CsvHelper)

**[Documentation](https://joshclose.github.io/CsvHelper/)**: guides, the API reference, the changelog and migration guides.

**Upgrading from CsvHelper 33?** Version 34 is a rewrite: the [migration guide](docs/releases/v34.0.0/migration.md) goes
through each concept with before and after code.
<!-- /docs:exclude -->

A CSV reader and writer for .NET, built for speed. It targets .NET 10 and .NET 8, and also runs on .NET Framework 4.7+
and .NET Standard 2.0 and 2.1 (see [Target frameworks](#target-frameworks)):

- **Reader**: parses UTF-8 directly with SIMD (AVX-512, AVX2 or 128-bit vectors), finds quoted regions
  branch-free with a carry-less multiply, and exposes fields as zero-copy spans. Flexible: it adapts to
  most real-world files and has explicit options for malformed ones. Besides RFC 4180 it reads escaped
  (`a\,b`), unescaped and fixed-width files ([Parsing modes](#parsing-modes)).
- **Writer**: strict RFC 4180 output by default (CRLF, minimal quoting, doubled quotes, consistent field
  counts), formatting numbers straight into a UTF-8 buffer; also escaped, unescaped and fixed-width output.
- **LINQ**: the CsvHelper.Linq package queries CSV with any LINQ operator, reading only the columns and rows a
  query uses, joins with Entity Framework Core and other providers by sending them only the keys it needs, and
  writes query results as CSV.

Benchmarks against [Sep](https://github.com/nietras/Sep) and [Sylvan.Data.Csv](https://github.com/MarkPflug/Sylvan)
are in [`bench/`](bench/CsvHelper.Benchmarks); results are in [Benchmarks](#benchmarks) below.

For another cross-library view, see the [.NET Matrix CSV Processing comparison](https://matrix.dev-team.org/?category=csv-processing&library=CsvHelper).

<!-- docs:exclude -->
## Install

```shell
dotnet add package CsvHelper
```

Or in Visual Studio's Package Manager Console: `Install-Package CsvHelper`.

## Reading

A summary. The documentation has the full guides, with examples of every mode, attribute and option:
[Reading](https://joshclose.github.io/CsvHelper/reading.html), [Records](https://joshclose.github.io/CsvHelper/records.html),
[Messy files](https://joshclose.github.io/CsvHelper/messy-files.html) and
[Writing](https://joshclose.github.io/CsvHelper/writing.html).

```csharp
using CsvHelper;

using var reader = CsvReader.FromFile("data.csv");        // or Create(stream), Create(byte[]), Create(TextReader), FromText(string)
int price = reader.GetFieldIndex("Price");                // header lookup: exact, then case/whitespace-insensitive
while (reader.Read())
{
    string name = reader.GetString(0);
    double value = reader.Parse<double>(price);          // also int, long, decimal, bool, DateTime, Guid, ...
    ReadOnlySpan<byte> raw