datatools
Various utilities for simplifying JSON, Excel Workbook and CSV data work on the command line.
- csvcols - a tool for formatting command line arguments intoa CSV row or filtering CSV rows for specific columns
- csvjoin - a tool to join to CSV files on common values in designated columns, writes combined CSV rows to stdout
- csv2mdtable - a tool to render CSV as a Github Flavored Markdown table
- jsoncols - a tool for exploring and extracting JSON values into columns
- jsonrange - a tool for iterating for JSON maps and arrays
- xlsx2json - a tool for converting Excel Workbooks to JSON files
- xlsx2csv - a tool for converting Excel Workbooks sheets to a CSV file(s)
Compiled versions are provided for Linux (amd64), Mac OS X (amd64),
Windows 10 (amd64) and Raspbian (ARM6, ARM7). See https://github.com/caltechlibrary/datatools.
Use the utilities try “-help” option for a full list of options.
Installation
datatools is go get-able.
go get github.com/caltechlibrary/datatools/...
Or see INSTALL.md for details for installing
compiled versions of the programs.