Logmend / Tools

Time and date converter for the ITA CSV

Paste a column from your log. Each line is rewritten in the format the 300/301 CSV specification gives, and anything unreadable is pointed out.

Convert a column

These lines are

One value on each lineCopy a column in your spreadsheet and paste it here.

Runs in your browser. Nothing you type here is sent anywhere.

The seven date and time columns

CSV col	Header name	Holds	Format	Required
E	`date_of_incident`	Date of injury or onset of illness	mm-dd-yyyy or mm/dd/yyyy	Yes
L	`date_of_birth`	Date of birth	mm-dd-yyyy or mm/dd/yyyy	Yes
M	`date_of_hire`	Date hired	mm-dd-yyyy or mm/dd/yyyy	Yes
Q	`time_started_work`	Time employee began work	Time (hh:mm)	No
R	`time_of_incident`	Time of event	Time (hh:mm)	No
S	`time_unknown`	Time of event unknown	Integer	Yes, if the time of incident is unknown
X	`date_of_death`	Date of death	mm-dd-yyyy or mm/dd/yyyy	Yes, if death is recorded

How a line is read

As typed	Written as	Why
7:30 AM	07:30	24-hour clock, two digits for the hour.
2:15:00 PM	14:15	Seconds removed. The User Guide checklist says Excel adds them.
1430	14:30	Read as hhmm.
0.25	06:00	A spreadsheet stores a time as a fraction of a day.
8.30	08:30	Read as a time and flagged, because it could mean 8.3 hours.
March 4, 2025	03/04/2025	Text month rewritten.
13/02/2025	02/13/2025	Day and month swapped, because there is no month 13.

OSHA's documents do not fully agree on times. The details are on date and time format.

This does one column. The converter does the whole log: every date, time and code, in both ITA files.

Open the converter

Short answers

What time format does the OSHA ITA 300/301 CSV use?

The CSV specification gives the time fields as hh:mm on a 24-hour clock, five characters long. Seconds are not part of the format.

What date format does the OSHA ITA CSV use?

mm-dd-yyyy or mm/dd/yyyy, ten characters, for the date of incident, date of birth, date hired and date of death.

What if the time of the incident is not known?

Leave time_of_incident blank and put 1 in time_unknown. The specification requires time_unknown when the time of incident is unknown.

Sources

Read on 2026-11-10. OSHA can change these documents; the link is the authority. Logmend is an independent information tool. It is not affiliated with or endorsed by OSHA or the U.S. Department of Labor, and it is not tax, legal or professional advice.