How to Export Csv from Calendar (2026 Guide)

Follow these steps to export your Calendar csv as a CSV file. Once exported, you can use any of our converter tools to transform the data for your target system.

Export Steps

Prepare your calendar events in a spreadsheet

Open Google Sheets, Excel, or another spreadsheet application and create a new sheet. Set up columns in the first row with the required headers: Subject, Start Date, Start Time, End Date, End Time. Only 'Subject' and 'Start Date' are strictly required, but including time and end date columns gives you more complete event data.

Tip: Google Calendar requires these header names to be in English exactly as specified. Using different column names like 'Event Name' instead of 'Subject' will cause import failures.

Format your dates correctly

Enter dates in MM/DD/YYYY format (e.g., 01/15/2025). This is the format that Google Calendar and most calendar applications expect when importing CSV files. Be consistent throughout the file and avoid mixing date formats in the same column.

Warning: Do not use formats like 'January 15, 2025' or '2025-01-15' as these may not be recognized by Google Calendar during import.

Format your times correctly

Enter times in 12-hour format with AM/PM (e.g., '09:00 AM' or '02:30 PM'). If an event is an all-day event, leave the Start Time and End Time columns blank and set the 'All Day Event' column to 'TRUE'. Times without an AM/PM indicator may be interpreted incorrectly.

Add optional event details

Fill in additional columns as needed. 'Location' specifies the event venue or address. 'Description' holds detailed notes or agenda items. 'Private' can be set to TRUE or FALSE to control event visibility. If any field contains commas (like an address), wrap the entire field value in double quotes.

Export as CSV from your spreadsheet

In Google Sheets, go to File and select 'Download as Comma-separated values (.csv)'. In Excel, go to File, then 'Save As', and choose 'CSV (Comma delimited)' from the file type dropdown. Make sure to save as standard CSV, not CSV UTF-8 or other variants, for maximum compatibility.

Verify the CSV file structure

Open the exported CSV file in a plain text editor to confirm the headers are on the first line and each event is on a separate line. Check that commas properly separate the fields and that quoted fields containing commas are handled correctly. The file should begin with 'Subject,Start Date,Start Time,...' on the first line.

Tip: Always test your CSV by importing into a temporary or test calendar first. This lets you verify that events appear with the correct dates, times, and details before importing into your primary calendar.

Required Csv Fields

Field	Type	Description	Example
Subject	Text	Event title/subject	Team Meeting
Start Date	Date	Event start date	01/15/2025

Your Calendar export must include these fields for successful conversion.

Next Step Once you have exported your csv, use one of the converter tools below to transform your file.

Frequently Asked Questions

Calendar exports csv as a CSV (Comma Separated Values) file, which can be opened in Excel or Google Sheets.

The file is usually downloaded to your browser's default Downloads folder. Check your Downloads folder or look for the download notification.