csv-sort-cli^4.0.20

Installation

Call on a file

Call csvsort (or sortcsv) appending your file name (with or without -o/--overwrite flag):

csvsort YOURFILE.csv

csvsort -o YOURFILE.csv
csvsort --overwrite YOURFILE.csv
csvsort -v
csvsort --version
csvsort -h
csvsort --help

like this:

Or omit the file’s name

It will let you pick a CSV:

csvsort # omit the file's name, but you can include -o/--overwrite flag

omit the file name and csv-sort-cli will offer a list of CSV files in the current folder to choose from:

You can even try it without installing — use npx:

npx csv-sort-cli YOURFILE.csv

What it does exactly

1. It sorts CSV file rows to correspond to the double-entry bookkeeping principles:

Sometimes internet banking CSV’s have rows in a wrong order, especially when entries are on the same date. This library helps to sort the rows in correct order.

2. As a bonus, it will trim the empty columns/rows:

3. Not to mention, the our custom CSV parser csv-split-easy used here will ensure that all CSV cell contents are trimmed, and there are no empty rows between the content rows. It also accepts any commas as content if the cell is wrapped with a double quotes.

Changelog