Feb 7, 2018

CSV applications and tools

xls2csv - reads MS-Excel file and puts its content as comma-separated data on standard output
csvkit is a suite of utilities for converting to and working with CSV, the king of tabular file formats. csvkit is to tabular data what the standard Unix text processing suite (grep, sed, cut, sort) is to text.

in2csv will convert a variety of common file formats, including xls, xlsx and fixed-width into CSV format.

All the csvkit utilities work standard input and output. Any utility can be piped into another and into another and then at some point down the road redirected to a file. In this way they form a data processing “pipeline” of sorts, allowing you to do non-trivial, repeatable work without creating dozens of intermediary files.

CSV Utility programs in Linux:

  • column (-s to change the delimiter character(s))
  • cut (-d to change the delimiter character)
  • paste (-d to change the delimiter character(s))
  • join (-t to change the delimiter character)
  • sort (-t to change the delimiter character)
  • uniq (-f to skip comparing the first N fields)
  • emacs (using csv-nav mode)[11]
  • awk (-F to change the delimiter character)
Java CSV Tools:
Apache Commons CSV (Apache 2 Licence)
SuperCSV (Apache 2 Licence, RFC compliant)
OpenCSV
Flatpack
JavaCSV
QN CSV
CSVReader/Writer
CSVFile
ExcelCSV
CsvReader
FlatTree
CSV/Excel Utility Package
Jackson CSV module
JSaPar (Schema based parser with Apache 2 License)

Post a Comment

Featured Post

Datasets

Google Tables helps you search thousands of public Fusion Tables, or millions of public tables from around the web you can import to Fusio...