Accessibility empathy for spreadsheets
This spreadsheet contains a cover sheet and one worksheet of data which has been blacked-out: Dinosaur spreadsheet (ODS, 21KB).
The idea is the blacked-out worksheet shows you what it is like trying to navigate a data table when you cannot see the layout. This should give you some idea of the issues faced by users with visual impairments.
Can you answer the following questions from the data in the blacked out worksheet?
Hint: you can see what is in each cell by looking in the formula bar – this is similar to what a screen reader would read out.
- What percentage of children in Wales owned a dinosaur without a license in 2017?
- Can you tell if there is a trend in the percentage of pensioners in London who owned a dinosaur with a license between 1998 and 2021?
- When did information that led to revisions become available?
- Can you find the link to get back to the cover page when on the blacked-out worksheet?
Answers to the exercise are at the bottom of this page.
Other empathy approaches to try
Often we tend to focus on screen reader users when we talk about accessibility. But accessibility needs are broad. Here are some other empathy approaches you can try.
Go to the blacked out worksheet, turn off the black colour fill and instead:
- zoom in to around 300% – this will help you understand what it is like for people with visual impairments who use zoom functionality instead of screen reader software
- use your non-dominant hand to navigate the sheet – this will help you understand what navigation of spreadsheets is like for people who have motor disabilities.
- only use your keyboard to navigate the sheet – this will help you understand what spreadsheets are like to navigate for keyboard-only users
- turn on high contrast mode (most computers will have this somewhere in the settings) – this will help you understand what it is like to have a visual condition like cataracts.
- get some earphones and play this YouTube video while you try and complete the exercise – this will help you understand what it is like to have an auditory condition like Tinnitus.
- lower your screen’s brightness – this will help you understand what it is like to have a visual condition like glare.
How we can improve accessibility
To illustrate some of the impacts we can make on spreadsheet accessibility, James (a tester at the Digital Accessibility Centre) has made a video showing him using his screen reader software to access tables in spreadsheets. In particular, he shows the impact of accessible column headers, which is something you may not have considered before.
- wrapping text within cells and not allowing text to run too far across a page helps people who use zoom functionality
- keeping information in cover sheets, content sheets and above tables within one column, helps navigation for people who struggle to use a mouse or who rely on keyboard-only navigation
- marking up tables so they can be tabbed through in a sensible order also makes things easier to navigate
- using the ‘automatic’ colour for fonts and not putting on any background fill helps people who have issues with colour contrast or glare by allowing their software to take on colour settings specific to them
Guidance to help you publish more accessible spreadsheets and publications:
- Releasing statistics in spreadsheets
- Making spreadsheets accessible: a checklist of the basics
- Making analytical publications accessible
Other ways to access help with accessibility in statistics
Join the Basecamp message board for accessibility in statistics.
News article about how to make best use of the Basecamp message board.
Want to know more about accessibility empathy?
To learn more, you can:
- take a look at the approaches suggested on this empathy prompts website
- read about the seven accessibility personas created by the Accessibility Team in the Government Digital Service (GDS)
Answers to the exercise questions:
- No trend (numbers were generated randomly)
- 2019 (there is a note below the table)
- If you couldn’t find it, the link is in cell F2