node package manager

csvnorm

Csvnorm

Command line tool to normalize CSV and *SV files.

Steps:

  • Convert to UTF-8 encoding
  • Replace separator with ,
  • Reformat
    • Date columns to ISO8601
    • Number columns to 1456.25
    • Currency columns to 1539.16 $

Installation

npm install --global csvnorm
yarn global add csvnorm

Usage

csvnorm data.csv
cat data.csv | csvnorm

TODO

  • Print debugging info in TTY mode