Skip to content

Instantly share code, notes, and snippets.

@benjystanton

benjystanton/content-design-for-data-tables-spreadsheets-csvs-and-apis.md

Last active November 29, 2022 15:56
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save benjystanton/f027bfcfa30c009276e069a3e4c74bf5 to your computer and use it in GitHub Desktop.
Save benjystanton/f027bfcfa30c009276e069a3e4c74bf5 to your computer and use it in GitHub Desktop.
Download ZIP
Content design for data tables, spreadsheets, CSVs and APIs
Raw
content-design-for-data-tables-spreadsheets-csvs-and-apis.md

Content design for data tables, spreadsheets, CSVs and APIs

Interfaces for exploring data rely on the data itself being well written.

Improving the way data is labelled and described, wihout affecting the underlying meaning, whilst also making sure it's still machine readable is a tricky task!

Here are some resources that can help (thanks everyone for the suggestions).

Useful resources

@benjystanton
Copy link
Author

Don't use spreadsheet cells for layout
Examples of this might be

  • using the first few rows for the title, description and copyright information (also known as metadata)
  • Or laying out a grid of address labels

@benjystanton
Copy link
Author

Encountered one last week where the "data" was the cell's red/green background colour.
https://twitter.com/psd/status/1270286445509513216

@benjystanton
Copy link
Author

If I wanted to add/append/link to some human readable descriptions for a CSV download without messing up the machine readable stuff. How would I do that? https://twitter.com/benjystanton/status/1266306003861110786

@benjystanton
Copy link
Author

https://www.gov.uk/guidance/content-design/tables#how-to-make-tables-accessible

@benjystanton
Copy link
Author

Writing Alt Text for Data Visualization https://medium.com/nightingale/writing-alt-text-for-data-visualization-2a218ef43f81

@benjystanton
Copy link
Author

Metadata standards for sharing and publishing data https://www.gov.uk/government/collections/metadata-standards-for-sharing-and-publishing-data via https://twitter.com/RosalieMarshall

@benjystanton
Copy link
Author

https://gss.civilservice.gov.uk/policy-store/making-analytical-publications-accessible/

@benjystanton
Copy link
Author

Making excel documents accessible

Via Steve Green

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment