JSON to CSV Converter

Sheetize JSON‑to‑CSV Converter for .NET provides a simple yet powerful API for turning structured JSON documents into flat CSV tables. Whether you are handling API responses, log files, or configuration data, Sheetise can parse the JSON hierarchy, flatten nested objects, and emit a standards‑compliant CSV ready for Excel, Power BI, or any data‑pipeline.

Main features

Convert JSON to CSV

Generate CSV representations of JSON arrays or objects with configurable delimiters, header generation and type handling.

Customisable flattening

Control how nested objects and arrays are flattened using dot‑notation or custom column mapping, ensuring the output meets your schema requirements.

Streaming support

Process large JSON files in a streaming fashion to avoid high memory consumption – ideal for big‑data scenarios.

Detailed instructions

JSON → CSV workflow

To convert a JSON file to CSV with Sheetise, follow these steps:

  1. Initialise the converter – create an instance of JsonConverter.
  2. Configure options – set JsonSaveOptions to define the delimiter, whether to include a header row, and how to handle nested structures.
  3. Define file paths – provide the source JSON path and the destination CSV file location.
  4. Execute conversion – call Process with the prepared load and save options.

Example – JSON to CSV with header and semicolon delimiter 

using Sheetise;

var loadOptions = new LoadOptions
{
    InputFile = @"D:\Data\input.json"
};

var saveOptions = new JsonSaveOptions
{
    OutputFile = @"D:\Data\output.csv"
};

JsonConverter.Process(loadOptions, saveOptions);

Expanded format support

  • Sheetise can also convert CSV back to JSON, allowing round‑trip data transformations.
  • Beyond CSV, the library supports exporting to TSV, pipe‑delimited files, and direct DataTable objects for in‑memory processing.
  • Combine JSON‑to‑CSV conversion with the HTML ↔ XLSX utilities for end‑to‑end reporting pipelines, e.g. JSON → CSV → XLSX → HTML.

With these capabilities, Sheetise makes JSON‑to‑CSV conversion a breeze, whether you need a one‑off script or a production‑grade service.

 Українська