Open Source Unix Shell CSV Software

Elevations moves data from Excel to Unix systems. It connects VBA with Cygwin SSH, CGI and HTTP POST to deliver to a QuantLib C++ server through pipes. Provides C++ classes to process CSV files and the strings to C++ types. File schema definitions.

A set of Unix command line tools for quick and convenient batch processing of tabular text files (a.k.a., tab-delimited, csv, or flat file format) with a header line. Provides delimiter and compression detection, column reference by name. * tblmap: per-line ("map") computation: derive columns through an expression, delete, reorder, filter rows. * tblred: compute ("reduce") aggregations (e.g., sum, average) over groups defined by key columns. * tbldesc: Summarize columns in file (e.g., proportion of character/numeric values, min/mean/median/max, missing values, correlation with a target column). * tbljoin: Relational join without the need of pre-sorting and column matching. * ... See HostedApps/MediaWiki for examples.

This bash script adds several csv files into an existing .ods spreadsheet. Each csv file creates a sheet. If there is no input spreadsheet provided, it creates one and inserts all csv files in it.