Skip to main content

Creating Accessible Data

Web Content Accessibility Guidelines (WCAG) were designed for a wide range of web content but may not always clearly align with complex research data. Please refer to the following guidelines and resources for common file formats as you prepare to deposit your data. The following information is not exhaustive, and no single checklist will apply to every deposit or fully address accessibility needs for every file type. 

XLSX  

Excel (XLSX) files allow custom formatting to support accessibility. Use to following guidelines to create accessible XLSX files:

  • Structure & Formatting
    • Start table in cell A1. 
    • Include only one table per tab. 
    • Set headings using "cell styles" in the Excel Home tab.

  • Cell Content
    • Avoid blank rows, columns, and merged cells.
    • Avoid using numeric values or blank cells to indicate null values. Select one value to consistently represent null values, such as “N/A” or “NONE.” 
    • If color is used, do not rely solely on color to convey information and ensure colors have sufficient contrast with text. 

  • Naming Conventions
    • Use descriptive file names and tab names.
    • Use descriptive names for column and row headings. 
  • Charts & Graphs
    • Provide alternative text using the guidelines for data visualizations below.

More information about how to make XLSX files accessible and use the Accessibility Checker is available from the University of Arizona Disability Resource Center Excel Help Page 

CSV 

Comma-Separated Values (CSV) files store tabular data in plain text format. Formatting, text styles, and color are not retained in CSV. To make CSV files more accessible, use the following best practices:   

  • Cell Content
    • Avoid blank rows, columns, and merged cells.
    • Avoid using numeric values or blank cells to indicate null values. Select one value to consistently represent null values, such as “N/A” or “NONE.” 
  • Naming Conventions
    • Use descriptive file names for each CSV file included in your deposit. 
    • Use descriptive names for column and row headings. 
    • Apply consistent naming conventions to headings, such as camelCase or PascalCase. 

PDFs & Word Documents 

Accessible source documents are the most effective way to create accessible PDFs and reduce time needed for remediation. Microsoft Word can be used to create accessible documents and review accessibility barriers before exporting to a PDF. To create accessible Word documents, use the following guidelines: 

  • Structure & Formatting
    • Set heading styles using "Styles" in the Home tab. 
    • Use built-in styles in the Home tab to format lists.
    • If tables are used, set the header row under "Table Design."
  • Text
    • Use a sans-serif font, such as Arial, Helvetica, Georgia, or Lucida Sans.
    • Regular text should have a color contrast ratio of 4.5:1 with background colors.
    • Headings should have a color contrast ratio of 3:1 with background colors.
    • If hyperlinks are present, use descriptive language to describe the purpose and target location. 

  • Images & Graphics
    • Provide alternative text for non-decorative images and graphics using the guidelines for data visualizations below.

If you need to remediate a PDF directly, use the following resources to identify and address accessibility barriers: 

Plain Text Files 

Plain text documents do not allow formatting features available in other file formats. To make plain text documents accessible, use the following best practices:  

  • Structure
    • Ensure that each heading within the file is preceded by two blank lines followed by one blank line 
    • Include one blank line before each paragraph 
  • Text
    • Provide a full expansion of abbreviations used. 

PowerPoint Presentations 

Presentations can be made accessible using Microsoft PowerPoint tools. Use the following guidelines to make accessible PowerPoint files:

  • Structure & Formatting
    • Use built-in slide layouts under "New Slide" in the Home tab.
    • If tables are used, set the header row under "Table Design."
  • Text
    • Use a sans-serif font, such as Arial, Helvetica, Georgia, or Lucida Sans.
    • Regular text should have a color contrast ratio of 4.5:1 with background colors. 
    • Headings should have a color contrast ratio of 3:1 with background colors.
    • If hyperlinks are present, use descriptive language to describe the purpose and target location. 

  • Images & Graphics
    • Provide alternative text for non-decorative images and graphics using the guidelines for data visualizations below.

The University of Arizona Disability Resource Center Accessible PowerPoint Presentations help page provides additional guidance and resources for creating accessible presentations and accessing the built-in accessibility checker. 

Image Files

Common image file formats, such as PNG, JPEG, and TIFF, do not support embedded alternative text that can be reliably downloaded and accessed by users. To make images more accessible, use the following guidelines:

  • Content
    • Data associated with the visualization should always be included in the deposit. 

  • Complex Data Visualizations: provide longer descriptions or data summaries in the README or separate plain text file. 
    • Descriptions should not draw conclusions about the patters of the visualization. Conclusions should be left up to the user’s discretion.  
    • Visual attributes, such as color or gridlines, do not need to be described in the associated description.
    • Provide appropriate titles and labels, numbers (or approximates if needed), and overall data trends in the associated description.
  • Images: add alternative text to the README or separate plain text file.
    • Alt text should be short and concise. Aim for 125 characters or less. 
    • Focus on the content of the image rather than explain the appearance of the image. 
  • Text
    • Use a sans-serif font, such as Arial, Helvetica, Georgia, or Lucida Sans.
    • Regular text should have a color contrast ratio of 4.5:1 with background colors.
    • Headings should have a color contrast ratio of 3:1 with background colors.
  • Color
    • Do not rely solely on color to communicate meaning. Supplement the use of color with outlines, patterns, and/or shapes.

Additional Resources 

“Provide alternative text under 125 characters for this image.” 

“Provide a description of the contents of this image.” 

 

MP4

MP4 files are commonly used for audiovisual or visual-only content. To make audiovisual and visual-only content accessible, use the following guidelines:

  • Captions: Closed captions (CC) or open captions are required for media containing audio content. 
    • Closed Captions: can be added to your MP4 file by importing a SRT file containing the captions using Adobe Premiere.
    • Open Captions: also known as burned-in captions, can be added directly to your MP4 file using Adobe Express or Premiere
  • Video Descriptions: required for visual-only content. Descriptions can be added to the video as audio or placed in a separate plain text, Word document, or PDF file. 
    • Describe the content, background, and any subjects of the video in chronological order.
    • The description should be objective and avoid interpreting the content of the video. Allow the user to generate their own conclusion.

WAV

WAV (Waveform Audio File Format) files store audio-only content. Due to format limitations, WAV files cannot embed captions or transcripts directly. Text-based transcripts should be placed in a separate plain text, Word document, or PDF file. To make audio-only content accessible, use the following guidelines: 

  • Transcripts: required for audio content containing speech.
    • Should accurately convey speech and other audio content. Avoid making changes to any speech.
    • When relevant, identify speakers, non-speech sounds, and background audio in the the transcript.
  • Audio Descriptions: required for audio content without speech.
    • The description should objectively describe the content without drawing conclusions.

GIF

Graphic Interchange Format (GIF) may sometimes be used to show looping content or short content but should be used sparingly, when possible, due to accessibility limitations. If your deposit includes GIF files, use the following guidelines to make your media content accessible:  

  • Flashing
    • Content should not flash, whenever possible. If flashing is unavoidable, it must not flash more than three times in one second. 
    • Red flashes should be avoided entirely.  
  • Describing Content: A text-based description and/or transcription should be provided for visual and audio content using the previous guidelines.

Resources  

“Provide a detailed description of this video.” 

“Create alt text for the audio file.” 

Source Code

Accessibility of source code is limited because it is primarily intended to be machine readable. Use of the following best practices can improve readability for users and are recommended for deposits:  

  • Naming Conventions
    • Select camelCase or PascalCase and apply it consistently.  
  • Formatting
    • Separate each item on a new line. For example, put multiple case conditions on separate lines. 
    • If possible, include in-line comments to explain the purpose of specific items. Comments can improve accessibility and reproducibility for users.   

Maps  

Map accessibility is largely dependent on the complexity of the map and software used to generate the map. To make your maps in static formats (e.g., PDFs) accessible, use the following guidelines:  

  • Describing Content: Include a thorough description to ensure users can access the same information contained in the map.  
    • Organize the description in a bulleted list (used to convey importance of information based on ranking within the list).  
    • Describe relationships and distance between points on the map when applicable.  
  • Accessible Design
    • Ensure there is sufficient contrast between any text, plot points, and background colors. A helpful method to check color contrast is to test the map in black and white for readability.  
  • Content
    • Provide underlying data that used to generate the map, if possible. 

3D Models  

Three-dimensional (3D) models can help users gain new perspectives and insights. However, underlying software used to generate 3D images is not always accessible. Depending on the specific software used to render the image, it may not be possible to fully meet digital accessibility guidelines due to technological limitations. To make your 3D images more accessible:  

  • Describing Content: Include a thorough description to ensure users can access the same information contained in the 3D model.  
    • Describe meaning conveyed by color or any key features.
    • Describe the purpose of the image.
  • Content
    • Provide underlying data that used to generate the 3D model, if possible. 

 

 

Using Google Workspace? More information about making your files accessible using Google applications is available from the University of Arizona DRC Google Workspace Accessibility help page.