CSV Engine vs qsv

CSV Engine is a web tool for cleaning and validating uploaded spreadsheets before export. It maps source columns to reusable templates, sanitizes values, detects duplicates, previews row-level failures, and can export only records that pass configured rules. Uploads use drag and drop, with automatic detection of delimiters, encodings, and headers. Column mapping supports aliases and fuzzy matching, and mappings can be saved per template. Listed cleanup includes whitespace trimming, casing normalization, email checks, phone parsing, and date fixes. Duplicate matching can use multiple fields and merge strategies, with conflicts reviewed before commit. Templates preserve schemas, field types, and validation rules for reuse. One credit processes up to 1,000 rows, including validation, deduplication, and export. The Free plan provides five credits per month and three active templates; the Starter plan is $15 a month billed annually. One-off credit packs are also available, beginning at $8, paid once, with credits that never expire. Pro includes email support with a 24-hour response; its developer API is listed as coming soon.

qsv is a CSV data-wrangling toolkit for slicing, analyzing, and transforming data through more than 50 commands. Most commands stream their input and use constant memory, so they can handle very large CSV files without loading the full dataset into memory. It works with CSV, Excel, OpenDocument Spreadsheet, JSON and JSONL, DataPackage, Apache Arrow and Parquet, SQLite, and PostgreSQL. Luau and Python scripting are built in, and the join, joinp, and sqlp commands support SQL and join queries without a SQL database. qsv is designed to interoperate with Airbyte, Airflow, Pentaho Kettle, and command-line tools. Its qsv pro desktop app adds graphical spreadsheet viewing and transformation, plus CKAN upload and download. The code is automatically checked for security vulnerabilities, and prebuilt binary archives are zipsigned with integrity checks during self-updates. qsv requires UTF-8 input. The Free plan costs nothing and includes spreadsheet imports up to 1MB; Pro costs $99.99 a month after the trial ends.