Help:Tabular Data
Tabular data allows users to create CSV-like tables of data, and use them from other wikis to create automatic tables, lists, and graphs.
To create a new table, create a new page in the Data namespace with a .tab suffix, such as Data:Sandbox/Name/Example.tab. Feel free to experiment by creating pages with the Sandbox/<username>/ prefix.
For now, page content can only be edited in the raw JSON format and with a basic table editor, but the TabularImportExport gadget allows import/export from/to CSV and Excel files. There are also third-party tools available:
CSV and TSV
- convertcsv.com (select "CSV to JSON Array") - Generate output as JSON Array, under 'output options' select option 'if to JSON Array, create array for column names with name'. You will still need to manually add "name": and "type": to each entry in "fields" (see example above for formatting)
XLS
Usage
The content of a .tab file stored in Commons data name space can be shown as table on some other wikis using the {{Json2table}} and Module:Json2table (talk | +/− | links | doc | subpages | tests – results).
The content can also be shown as interactive diagrams using the chart extension.
Category:Tabular data