← All Project Ideas

CSV to JSON Converter CLI

beginner

A CLI tool that converts CSV files to JSON with type inference, schema validation, nested object support, and streaming for large files. Handles various delimiters, encoding, and produces clean str...

Target user

Data engineers and developers who transform CSV data to JSON

Problem

Data engineers frequently need to convert CSV to JSON with proper type inference and nested structures, but manual conversion is error-prone and tedious without a reliable CLI tool.

Requirements

  • Convert CSV to JSON with type inference
  • Support custom delimiters and encoding
  • Handle nested objects via dot notation
  • Stream large files without memory issues
  • Validate output against JSON schema

Core technologies

Node.js, TypeScript, csv-parse

Completion criteria

Users can convert CSV to JSON with type inference, custom delimiters, nested objects, and streaming for large files.

Optional extensions

  • Add reverse JSON to CSV conversion
  • Implement custom type mapping
  • Add batch directory conversion
  • Support Excel input