In the Save as type list, select Excel TemplateĪfter saving the template, you should double-check the accessibility of the document by using the “ Accessibility Checker ” to review your document against a set of possible issues that users with disabilities may experience. Also, filling in the text box labeled Tags with the term “accessibility” will improve its searchability as an accessible file. Using a descriptive file name (e.g., “Accessible Inventory Template”) will increase the prominence of the accessibility status.

In the File name box, type a name for the template. Remember to save your new or modified template with a name easily recognizable.Ĭreate a new document by going to File > New > Blank Workbook

You can also edit and modify the existing prepackaged templates to ensure that they are accessible. It is possible to create your own accessible template from scratch in Excel 2010 and later. How to Create an Accessible Excel Template A separate data definition document must accompany all CSV files.Īn Excel data set that would be presented as a CSV has to have the following characteristics:Ī single row of headings in the first row. If you provide a link to the CSV file, you must clearly state that the CSV is a raw data set. If the purpose of the Excel worksheet is to present a data set, the Excel file should be presented on the web as a Comma Separated Value (CSV) file and not as an xls file. Remember to add a Comma Separated Value CSV file in addition to the excel file. ExemptionsĮxcel files may be granted an accommodations waiver when files contain program modules and macros developed to perform automated analysis or to draw in data sets from external or legacy databases.Ĭreating Accessible Excel Spreadsheets (3 minute video summary) XLS- only must include a link to the Excel Mobile or some other viewer.

Charts/graphs must include axis information.

Column and row headings must be labeled.

Each worksheet must have an appropriate name in the tab at the bottom on the workbook.

Decorative images must not have alternative text added.

All images in the worksheets with informational value must include alternative text.

Workbook properties for title, subject, keywords author, and language must be included.

The following are Excel general guidelines for producing accessible documents: Excel is a frequently-used spreadsheet especially by faculty in the fields of finance, accounting and economics.

Excel accessibility screen reader