How to merge separate date and time columns into a datetime column
- Step 1Export the CSV with separate Date and Time columns — Download from your event system, log tool, or booking platform.
- Step 2Drop into CSV Column Merger — Select the Date column, then the Time column.
- Step 3Set the separator — Use 'T' for ISO 8601 (2025-01-15T14:30:00) or space for SQL (2025-01-15 14:30:00).
- Step 4Download and import — Use the merged datetime column in your database or BI tool.
Frequently asked questions
What format should the Date column be in?+
The merger concatenates raw values. Ensure the Date column is already in the format your destination expects (e.g. YYYY-MM-DD).
Does this add a timezone offset?+
No. The merge concatenates values as-is. Add the timezone suffix manually in a find-and-replace step if needed.
Can I merge three columns — Date, Time, and Timezone?+
Yes. Select all three columns in order and set a separator.
Privacy first
Processing runs locally in your browser with PapaParse. No file is uploaded — only metadata counters are saved for signed-in dashboard stats.