file_table_formatter
This module provides a field formatter that will display the contents of an uploaded file as a table. This allows you easily display and update table data on a site without importing as nodes or another entity. This module currently only supports CSV-formatted files.
This module can optionally be used with the DataTables module (https://drupal.org/project/datatables) to provide javascript client-side sorting of the generated tables.
Installation
- Copy the file_table_formatter module to sites/all/modules directory.
- Enable the module at Administer >> Modules.
Usage
- To configure the table formatter on a content type, go to Administer >> Structure >> Content Types.
- Add a file field to the content type, if necessary, under Manage Fields next to a specific content type.
- Click Manage Display next to the content type with your file field.
- Select "Display file contents as a table" from the Format box next to the file field.
- If your files have a header row, enable this feature by clicking the gear icon and checking the box.
- Click Save at the bottom of the page.
- Create a node of the selected type and upload a CSV-formatted file to the field you set the formatter on. When viewing the node, you should see tables displayed in place of file links.
- To add titles to the tables, use the file Description field.
To enable javascript sorting of tables:
- Download and install the DataTables module.
- Go to Manage Display for the content type with the file field you want to format.
- Click the gear next the field and check the "Use javascript sortable data tables" box.
- Click Save at the bottom of the page.
NOTE: DataTables tables with this formatter default to disabling pagination
and a default sorting column. To enable these, override the
theme_file_table_formatter_table() function in your theme.
Drupal 8+ Version
It works, but does not have DataTables support. It can be added once the DataTables module is updated: https://www.drupal.org/node/2393345.