How to import events from Excel into Outlook or Google Calendar with a CSV file

Create one row per event with at least the event title (Subject), Start Date and End Date. For events that are not all day, add Start Time and End Time. You can add optional columns such as Description or Location.

Use clear header names. Google Calendar reads the columns by their names, so the headers must match what it expects. Outlook lets you map columns by hand if the names differ. Column order does not matter.

Save the file as CSV (File > Save As, choose the CSV file type).

In classic Outlook, open the calendar. If you want the events in their own calendar, right-click any calendar and choose New Calendar (the video names it Holidays and Events). This is optional; you can import into your main calendar.

Go to File > Open & Export > Import/Export. Choose Import from another program or file and click Next. Select Comma Separated Values and click Next. Click Browse, pick your CSV file and click Next. Select the calendar to import into and click Next.

Click Map Custom Fields. If your headers are correct, Outlook maps them automatically. If a column is mapped wrongly or not at all, drag the value from the left list onto the correct field on the right. For example, dragging Description onto Location would put descriptions in the location field, so drag it back to Description.

Click OK, then Finish. Open an event to confirm the description came through. The events also appear in Outlook on the web and the Outlook mobile app. Right-click the calendar and use Color to change its color.

In Google Calendar, optionally create a new calendar with the plus icon next to Other calendars > Create new calendar.

Click the gear icon > Settings > Import & export. Select your CSV file, choose the calendar under Add to calendar and click Import. Google shows how many events were imported (54 in the video). All-day and timed events both appear, with their descriptions.

Neither calendar can import a PDF. If your events are in a PDF, or printed (take a photo), open Google AI Studio with your Google account and create a new prompt. Click the plus icon, choose Upload file and add the PDF or photo.

Use a prompt like: Extract the holidays from the PDF and give me the data in a format so I can copy them into a CSV file to upload the events in Google Calendar. Click Run, then copy the output.

Paste the output into a new Notepad file. Click File > Save, name it something like holidays.csv (the .csv ending matters) and save.

Open the file to check it. If an event name contains a comma (for example after Durga Puja), the text after the comma shifts into the next column. Remove those commas in Notepad and save again. Delete the time columns if all events are all day. The file is now ready to import into Outlook or Google Calendar.