Create an CSV or ICS File

[RRaively1]

Hello,

New to the board hoping you can help me.

I want to type up my fishing tournament schedule in Excel and then import them to Google Calendar.

Do I put the dates in 1 column then location in next column and then times in next column.

Then save as CSV file or ICS file?

Thanks for the help

Bob

 

[John_w]

See Import events to Google Calendar - Computer - Google Calendar Help

Set up your sheet like this:

Excel Google Calendar.xlsx
	A	B	C	D
1	Subject	Start Date	Start Time	Location
2	Test	11/26/2024	9:00 AM	Room 123
3	Final exam	11/27/2024	1:30 PM	Room 9
Excel Google Calendar

Put the column headers in row 1 (see above link for the correct header names); the order of the columns doesn't matter because the Google Calendar import is clever enough to match the header names to the correct calendar fields. Dates are in mm/dd/yyyy format. Save the workbook as CSV (Comma delimited).

 

[RRaively1]

See Import events to Google Calendar - Computer - Google Calendar Help

Set up your sheet like this:

Excel Google Calendar.xlsx
	A	B	C	D
1	Subject	Start Date	Start Time	Location
2	Test	11/26/2024	9:00 AM	Room 123
3	Final exam	11/27/2024	1:30 PM	Room 9
Excel Google Calendar

Put the column headers in row 1 (see above link for the correct header names); the order of the columns doesn't matter because the Google Calendar import is clever enough to match the header names to the correct calendar fields. Dates are in mm/dd/yyyy format. Save the workbook as CSV (Comma delimited).

Thank Yoi