CSVPilot

About

CSVPilot handles CSV files of any size with streaming reads and writes. Features automatic delimiter detection, header mapping, data type inference, column transformation pipelines, deduplication, and output to CSV/JSON/SQL. Processes 1M+ rows with constant memory usage.

Usage Example

const { CSVPilot } = require("csv-pilot");

await CSVPilot.transform({
  input: "./data/users.csv",
  output: "./data/cleaned.csv",
  columns: {
    email: { lowercase: true, validate: "email" },
    age: { type: "integer", filter: "> 0" },
    name: { trim: true, titleCase: true }
  }
});

Tags