Publish a data table
This page is for editors who publish figures. A table in the page shows them to everyone; the same data as a CSV file lets others reuse it. Tables in rich text are made with the online editor's table tools (Content model and editing, 4).
Contents
Before you start
- The figures are final and approved, with their source and the date they refer to.
- The table is small enough to read on a screen (a few columns, tens of rows). Large data belongs in a file.
- A CSV export of the same data, with a header row.
Steps
- Edit the page; in the rich text field, place the cursor and insert a table with the editor's table button.
- Give the table a caption (what it shows, the unit and the date), if your editor offers it; otherwise a heading just above.
- Make the first row header cells (the table properties have a header option); for row labels, make the first column header cells too.
- Type or paste the figures; align numbers consistently; write units in the headers ("Amount (thousands)") rather than in every cell.
- Below the table: "Source: <source>, <date>." and a short sentence with the main message.
- Attach the CSV: Upload new in a relation field, or upload it as a File and link it ("Download the data (CSV, 12 KB)").
- Preview, then Send for publishing.
Check the result
- To do: With a screen reader, header cells are announced for each cell.
- To do: At 200% zoom and phone width, the table can be read (a wide table may scroll inside its box).
- To do: The CSV opens in a spreadsheet with correct characters.
Pitfalls
| Pitfall | Avoid it |
|---|---|
| A table pasted as an image | text tables only |
| Merged cells and nested headers | keep tables simple; split into two tables |
| Color as the only signal (red for overspend) | add words or symbols |
| Data without a license note for reuse | state the license you publish data under (Open Definition) |
| Typing the same figures again every month | let your administrator set up an import (below) |
When the figures come every month
Figures that another system delivers again and again (a monthly spending file, weekly waiting times) need not be typed by hand. With the extension 7x SQLI Import, an administrator imports the CSV file into content items or a data table, checks a dry run first, and lets it run on a schedule; a page of the site can then show the current figures. See 7x SQLI Import: start here and Data tables.
Related pages
- Publishing tasks
- Write a plain-language summary
- Accessibility for site builders
- Free documentation: this page is free to copy, translate and improve under the GNU FDL 1.3.
Become an Exponential Partner
Partners share their information, provide funding, contribute back and develop the products with us, and that is how Exponential grows. A partner website and dashboard are planned for mid-2027: please become a partner today to speed up our growth rate and land new features faster.