Accessible spreadsheets can be read and used by everyone. They organize data with tables and headings, use descriptive titles, and have accessible colors and visualizations.
We do not recommend using spreadsheets as fillable forms or for long sections of text. Other document types, like forms or documents, are better for those purposes.
- Learn more in Spreadsheet Accessibility (U-M Canvas)
- Use Grackle tools for accessibility in Google Docs
- Review best practices for Google Sheets (Google)
- Review best practices with Excel spreadsheets (Microsoft)
Create and Format Tables
- Convert data into tables to create headers, add placeholders for easy data entry, and customize table appearance
- Create tables in Sheets (Google)
- Create accessible tables in Excel (Microsoft)
Add Headers
- Use table headers to clearly label your data. Use the first row or first column as your header.
- Create headers by freezing rows or columns in Sheets (Google)
- Use headers in Excel (Microsoft)
Fill Cell A1
- Put information in cell A1 so it is not blank. Use this cell for information about the table or as a header
Use Color
- Use font colors with enough contrast to be readable
- Use a table template with alternating colors to make data rows easier to read
- In charts or visualizations, use text, pattern, weight, or other features in combination with color to convey information
Describe Visualizations
- Include a descriptive title for all charts, graphs, and other data visualizations included in your spreadsheet
- Add alt text to data visualizations or other images summarizing key trends or information
- Learn more about writing description for complex charts and graphs with the Diagram Center’s Image Description Guidelines
Check Accessibility
- Use an accessibility checker to find and fix issues