Relational Database system from an Apple subsidiary. Can import and export CSV (both comma and tab separated). There is also a simplified version of FileMaker (called Bento) that also runs on IOS; development of Bento stopped in autumn 2014.
A suite of utilities for converting to and working with CSV, the king of tabular file formats
CSV Schema Language and CSV Validator
The National Archives (UK)
XSLT for converting CSV to XML: https://github.com/digital-preservation/csv-tools/
Data Pipes is a service to provide streaming, "pipe-like" data transformations on the web – things like deleting rows or columns, find and replace, head, grep etc.
Python's CSV module
It is part of the official Python distribution since version 2.3. Provides a simple shell around CSV files to read or write line-by-line, possibly use the header row's elements as keys. It is customizable to handle different separation characters (comman, tab, etc.). It uses Python's iteration model around the standard file object, meaning that it is usable with possibly large files.
PHP's built-in CSV parser
Streaming CSV parser for node.js
Tablinker is an experimental software for converting manually annotated Microsoft Excel workbooks to the RDF Data Cube vocabulary.
PLSheet is a SWI-Prolog library for analyzing ODF spreadsheets.
Harmonize is a tool (prototype) for normalizing and aligning RDF Data Cube datasets, and getting CSVs out of it.
Seemingly ubiquitous tool for working with tabular data (aka "spread sheets")
Apple's office suite, becoming fairly wide-spread on Macs and IOS platforms; "Number" is the spread-sheet tool within the suite, that can import/export CSV.
Apache Open Office's Calc
Open Source Office suite; Calc is the spread sheet tool within the suite that can import/export CSV. One of the two 'standard' office suites on Linux distributions (the other being LibreOffice).
Open Source Office suite; Calc is the spread sheet tool within the suite that can import/export CSV. One of the two 'standard' office suites on Linux distributions (the other being Open Office).
command-line SQL query interface for tabular text data
"a client-side library for connecting Google Spreadsheets to a website and visualizing the information in tables, maps and charts"
"real-time replication and versioning for large tabular data sets"
"TimelineJS is an open-source tool that enables anyone to build visually, rich, interactive timelines. Beginners can create a timeline using nothing more than a Google spreadsheet."
"An open source tool helping researchers document, manage, and archive their tabular data, DataUp operates within the scientist's workflow and integrates with Microsoft® Excel."
Revision control for tables
Tableau Public is a free interactive data visualization product focused on business intelligence. It is frequently used by journalists to visualize, analyze and tell stories about data. See, for example, the work of La Nacion in Buenos Aires, Argentina.
Google Fusion Tables
Google Public Data Explorer
Tarql is a command-line tool for converting CSV files to RDF using SPARQL 1.1 syntax. It's written in Java and based on Apache ARQ.
MR Data Converter
Client-side conversion of CSV to JSON (3 variations), XML (3 variations) and other formats.
"Functions and tools for tranforming and changing tab delimited and comma separated table files - useful for Excel sheets and SQL/RDF output"
"Easily create Open Data from Google Spreadsheets"
(sorry about the poorly chosen name!) Converts tabular data (XLSX,XLS,TSV,CSV,PSV) into an XML data structure then passes it to XSLT for conversion (generally into RDF+XML)
Also worth looking at the command line options: https://github.com/cgutteridge/Grinder/blob/master/bin/grinder#L91
Tablib is an MIT Licensed format-agnostic tabular dataset library, written in Python. It allows you to import, export, and manipulate tabular data sets. Advanced features include, segregation, dynamic columns, tags & filtering, and seamless format import & export.
TextQL is an MIT Licensed command-line application that allows one to execute SQL commands against tabular (CSV, TSV) data.
Copied in from WebSchemas wiki.
R, Mathematica, Matlab and Octave
- The R language has a 'data frame' construction, http://www.r-tutor.com/r-introduction/data-frame
- Octave has http://www.gnu.org/software/octave/doc/interpreter/Cell-Arrays.html and also http://octave.sourceforge.net/dataframe/overview.html which is close to the R approach.
- Matlab has recently added a similar construct, see http://www.mathworks.se/help/matlab/tables.html (via http://www.mathworks.se/help/matlab/release-notes.html http://www.mathworks.se/products/matlab/whatsnew.html )
- Matlab tables construct may be closer to matlab/octave structure (named fields) than to a cell array (though they're related); also new in Matlab 2013b. (via b_jonas, jwe in #octave IRC.freenode.net)
- http://pandas.pydata.org/ has data frame in python
- R/JSON/D3 discussion
- See http://www.wolfram.com/mathematica/new-in-9/built-in-integration-with-r/create-and-display-data-frames.html http://mathematica.stackexchange.com/questions/19136/creating-a-r-dataframe-like-construct-in-mathematica