Building an Audit-Defensible SDS Library from a Spreadsheet

A spreadsheet can start an SDS library, but rows alone are not defensible. Each product must connect to a workplace container, matching Safety Data Sheet, location, and working access method. The library also needs owners, exception records, and change history.

Quick Answer

Start with a physical chemical inventory, not the old spreadsheet. Create one stable product record, match its identifier to the label and SDS, and assign every location. Test access from each work area and shift. Record missing sheets, duplicates, retired products, revisions, owners, and completed corrections.

Table of Contents

• What makes an SDS library audit-defensible?
• What fields belong in the spreadsheet?
• How do you build the library from the spreadsheet?
• How do you find gaps, duplicates, and stale records?
• How do you prove that employees can get the correct SDS?
• How do you keep the library defensible after cleanup?
• How Helios Comply Helps
• Frequently Asked Questions
• Sources

What Makes an SDS Library Audit-Defensible?

A reviewer must be able to trace each record to the workplace. The library must identify the product, supplier, location, matching SDS, and employee access path. Under 29 CFR 1910.1200(e)(1)(i), the written program includes a hazardous-chemical list that uses a product identifier tied to the label and SDS. Section 1910.1200(g)(1) requires an SDS for each hazardous chemical used.

The spreadsheet is an index and control log, not the SDS. A supplier homepage or vague file name does not prove a match. Record open gaps honestly. “Requested from supplier on August 18” is more defensible than an unsupported complete status.

What Fields Belong in the Spreadsheet?

Use one row for each product and formulation. Use one stable product record with multiple location assignments when several sites use the same product.

Field	What to record
Identity	Stable record ID, exact product identifier, manufacturer, and product code
Workplace use	Each site, work area, vehicle, cabinet, or process
SDS control	Document location, issue or revision date, and date examined
Access	Tested binder, workstation, QR, mobile, or offline method
Exception	Missing sheet, mismatch, duplicate, supplier request, or retired status
Accountability	Owner, next action, due date, and closure evidence

Do not confuse your examination date with the manufacturer’s revision date. If the SDS shows no revision date, record “not shown.” See how to organize SDS documents for work-area indexes and filing structures.

How Do You Build the Library from the Spreadsheet?

Treat the old spreadsheet as a lead list. A workplace walk establishes what is present now.

1. Freeze a working copy. Keep the old file unchanged and record who started the cleanup.
2. Walk each work area. Record every labeled chemical that employees can encounter.
3. Normalize names. Use the label and SDS identifier. Keep shop names as aliases.
4. Match one SDS. Compare the identifier, manufacturer, product code, and revision details.
5. Record exceptions. Assign missing, unreadable, conflicting, or duplicate records to an owner.
6. Test access. Ask an employee to retrieve the sheet through the normal process.
7. Approve the record. Add the examiner and date after the product, sheet, location, and access path agree.

Helios Comply can import cleaned CSV records and existing SDS PDFs. AI-assisted parsing turns PDFs into structured records, but a person must examine uncertain matches. If a sheet is missing, record the supplier request. Do not substitute a similarly named product. See how to find, download, and request an SDS.

How Do You Find Gaps, Duplicates, and Stale Records?

Filter for records with no SDS, location, owner, examination date, or next action. Also find sheets with no active product assignment and links that employees cannot open. Helios Comply can retrieve SDS documents and show active-versus-expiring SDS status. The team records and resolves other exceptions through its documented process.

Check duplicates before merging

Similar names can identify different formulations. Compare product codes, manufacturers, and revision details. Keep conflicting sheets open until the supplier resolves the mismatch.

Handle retired products carefully

Under 29 CFR 1910.1020(d)(1)(ii)(B), an employer can keep a superseded SDS. The employer can instead keep a record identifying the substance, where it was used, and when it was used for at least 30 years. OSHA’s October 1, 1987 interpretation explains this option. Do not claim that every old SDS itself must remain for 30 years.

How Do You Prove That Employees Can Get the Correct SDS?

Section 1910.1200(g)(8) requires readily accessible SDSs during each work shift. Electronic access is acceptable only when it creates no barrier to immediate access. Test from the employee’s work area, not only a manager’s computer.

• Include night shifts, field crews, temporary sites, and weak-service areas.
• Test credentials, locked rooms, shared devices, dead links, power loss, and network loss.
• Record the date, location, shift, product, method, result, and correction.

Helios Comply supports QR, mobile, and offline SDS access. Test each method under actual conditions. A QR code is not proof unless its destination matches the product and remains available. OSHA’s July 15, 1996 interpretation addresses backup access for electronic systems. The guide to OSHA SDS access rules covers practical access tests.

This article states the federal OSHA baseline. OSHA-approved State Plans can use different standards and procedures. Examine each state’s rules.

How Do You Keep the Library Defensible After Cleanup?

Connect library changes to daily work. Federal OSHA does not set a blanket annual SDS replacement deadline.

• Do not release a new hazardous chemical until its record and access path exist.
• Assign a location owner and a system owner.
• Keep prior documents when recording supplier revisions.
• Examine inventory after product, supplier, formulation, location, or process changes.
• Repeat access tests after device, password, network, binder, or QR changes.
• Keep an exception queue with owners, dates, supplier contacts, and closure evidence.

A periodic review is good practice, not a federal annual replacement rule. The SDS preparer’s duty under 1910.1200(g)(5) starts after significant new hazard or protection information becomes known. It is not an employer grace period or universal expiration date. Before an audit, sample records from the floor and compare the container, row, SDS, access path, and written program. Use the OSHA HazCom inspection checklist for a wider review.

How Helios Comply Helps

Spreadsheets leave small teams to maintain links, versions, locations, and corrections by hand. Helios Comply places chemical and SDS records in one library.

Teams can import records, upload PDFs, parse SDS files, retrieve documents, and use barcode or label-photo intake. Location controls connect products to sites. QR, mobile, and offline access support retrieval. Reports and CSV exports organize evidence for review. People must still examine uncertain matches and maintain accurate inventory.

Helios Comply does not replace the employer’s written HazCom program, labels, training, inventory, or access duty.

Start a free trial, or call (855) 920-5202 for hands-on help with a spreadsheet or binder.

Frequently Asked Questions

Can a spreadsheet satisfy OSHA SDS requirements?

A spreadsheet can support the chemical list and SDS index. It does not replace the documents or access process. Each hazardous chemical needs a matching sheet available during the work shift.

What makes an SDS record defensible?

The record connects the exact product to its supplier, location, matching SDS, access method, owner, and examination date. It also shows open corrections.

Does OSHA require employers to update every SDS each year?

No. Federal OSHA sets no blanket annual replacement date. A recurring review is an internal control, not an OSHA deadline.

Do employers need to keep every old SDS for 30 years?

Not always. An employer can keep the sheet or the alternative substance, location, and use-date record described above for at least 30 years.

Can an electronic SDS library replace paper binders?

Electronic access can work when employees have immediate, barrier-free access during each shift. The employer also needs a practical backup for expected failures.

Sources

• OSHA, 29 CFR 1910.1200, Hazard Communication
• OSHA, 29 CFR 1910.1020, Access to Employee Exposure and Medical Records
• OSHA, Hazard Communication Standard Interpretation, July 15, 1996
• OSHA, Retention Requirements for Superseded MSDSs, October 1, 1987
• OSHA, State Plans

This article gives general information about the federal OSHA baseline. It is not legal advice. State-plan rules and industry-specific standards can add or change duties.