Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Content design for data tables, spreadsheets, CSVs and APIs
@benjystanton

This comment has been minimized.

Copy link
Owner Author

@benjystanton benjystanton commented Apr 28, 2020

@benjystanton

This comment has been minimized.

Copy link
Owner Author

@benjystanton benjystanton commented Apr 28, 2020

From my own research, the following is important to get right…

  • Download file names
  • Latest data first
  • Table headings should be unique and descriptive
  • Link to longer table heading descriptions could be useful
  • Consider whether human readable and machine readable data could be provided as different files
  • Fixing typos
  • Consistent capitalisation
@benjystanton

This comment has been minimized.

Copy link
Owner Author

@benjystanton benjystanton commented May 29, 2020

@benjystanton

This comment has been minimized.

Copy link
Owner Author

@benjystanton benjystanton commented Jun 9, 2020

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

This comment has been minimized.

Copy link
Owner Author

@benjystanton benjystanton commented Jun 9, 2020

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

@benjystanton

This comment has been minimized.

Copy link
Owner Author

@benjystanton benjystanton commented Jun 13, 2020

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

This comment has been minimized.

@benjystanton

This comment has been minimized.

Copy link
Owner Author

@benjystanton benjystanton commented Jul 24, 2020

@benjystanton

This comment has been minimized.

Copy link
Owner Author

@benjystanton benjystanton commented Aug 10, 2020

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