Changing completion data format in Completion reports

Learn how to remove timestamps from completion dates when exporting CSV reports from Form LMS.

When you export completion dates from Form, they include a timestamp (for example, 22/10/2025 13:29). If you only need the date, follow these steps.

Open the CSV file

1. Download the CSV file from Form LMS.
2. Open Excel (blank workbook).
3. Go to Data → Get Data → From File → From Text/CSV.
4. Select your downloaded CSV file.
5. Click Load. This keeps the dates as text.

Remove the time from completion dates

1. Select the column containing the date/time values.
2. Go to the Data tab and click Text to Columns.
3. Select Delimited, then click Next.
4. Uncheck all delimiter boxes, then check Space only.
5. Click Next.
6. In the data preview pane, click the second column (the time values).
7. Select Do not import column (skip) from the options above.
8. Click Finish.

Your column now displays dates only (for example, 22/10/2025).