CWC 2015 - CSV for importing fixtures into Calendar

[Arthur]

I've created a CSV of the CWC 2015 fixtures, allowing easy import into your fave calendar.

It's mapped for Outlook, but you can change the mappings for other calendars.

Also, I've currently set reminders for certain games, at game start time. Edit this to suit your preferences and schedule (Set the value in Colum H "Reminder" to TRUE for reminder-on, or FALSE for no-reminder, and change the Reminder Time (Column I) if you wish. Edit the values before you import.

To import into Outlook:

1. Download the CSV here.
1. File > Open & Export > Import/Export to open the import/export wizard
2. Import from another program of file
3. Comma Separated Values
4. Browse to select the downloaded CSV file, Do not import duplicate items
5. In Select destination folder, select you Calendar, then Next.

Other CSVs with fixtures for sports fans:

Six Nations Rugby 2015

Super15 Rugby 2015

Enjoy!

 

[sand_man]

Nice one!! Thanks!!

 

[RonnieZA]

Thanks

 

[stefan9]

Thanks

 

[Drifter]

Couldnt get it to work in Outlook 2010.

It put all of the items in my "sent" items folder.

** edit ** redid it, worked now. Thanks

 

[Luke7777]

Unfortunately the csv format is dd-mm-yy, and my shortdate is yyyy-mm-dd. So I now have all these entries in 2016 2017 2017 etc
This is what Excel does with it..


Sri Lanka vs New Zealand 2014/02/15 00:01:00 2014/02/15 08:01:00
England vs Australia 2014/02/15 05:30:00 2014/02/15 13:30:00
Zimbabwe vs South Africa 2015/02/15 03:00:00 2015/02/15 11:00:00
Pakistan vs India 2015/02/15 05:30:00 2015/02/15 13:30:00
West Indies vs Ireland 2016/02/15 00:01:00 2016/02/15 08:01:00
Scotland vs New Zealand 2017/02/15 00:01:00 2017/02/15 08:01:00
Bangladesh vs Afghanistan 2018/02/15 05:30:00 2018/02/15 13:30:00
Zimbabwe vs UAR 2019/02/15 00:01:00 2019/02/15 08:01:00
England vs New Zealand 2020/02/15 03:00:00 2020/02/15 11:00:00
West Indies vs Pakistan 2021/02/15 00:01:00 2021/02/15 08:01:00
Bangladesh vs Australia 2021/02/15 05:30:00 2021/02/15 13:30:00

 

[Drifter]

Unfortunately the csv format is dd-mm-yy, and my shortdate is yyyy-mm-dd. So I now have all these entries in 2016 2017 2017 etc
This is what Excel does with it..


Sri Lanka vs New Zealand 2014/02/15 00:01:00 2014/02/15 08:01:00
England vs Australia 2014/02/15 05:30:00 2014/02/15 13:30:00
Zimbabwe vs South Africa 2015/02/15 03:00:00 2015/02/15 11:00:00
Pakistan vs India 2015/02/15 05:30:00 2015/02/15 13:30:00
West Indies vs Ireland 2016/02/15 00:01:00 2016/02/15 08:01:00
Scotland vs New Zealand 2017/02/15 00:01:00 2017/02/15 08:01:00
Bangladesh vs Afghanistan 2018/02/15 05:30:00 2018/02/15 13:30:00
Zimbabwe vs UAR 2019/02/15 00:01:00 2019/02/15 08:01:00
England vs New Zealand 2020/02/15 03:00:00 2020/02/15 11:00:00
West Indies vs Pakistan 2021/02/15 00:01:00 2021/02/15 08:01:00
Bangladesh vs Australia 2021/02/15 05:30:00 2021/02/15 13:30:00

Click on the columns and change the date formats before you import.

 

[Luke7777]

The problem is I wasn't aware of the date format *prior* to importing. Have deleted it now and will redo.

 

[Xino_sam]

Dankie!

 

[Arthur]

You can do an easy bulk delete in Outlook Calendar by changing the view to List format. Sort by Category (CWC 2015), highlight them all in the list and delete. Done.

 

[Luke7777]

You can do an easy bulk delete in Outlook Calendar by changing the view to List format. Sort by Category (CWC 2015), highlight them all in the list and delete. Done.

Did that, after I found out where all my entries went