• After more than 15 years covering everything Apple, it’s with a heavy heart we announce that we will no longer be publishing new content on iMore and the iMore forums will be closing as of November 1st, 2024.

can anyone help me set up a Numbers file to upload into iCal

aapierre

Well-known member
Aug 24, 2011
49
1
8
Visit site
I want to be able to upload a seasons worth of fixtures for a team into an iCal file so it loads into the calendar.

Can this be done from Numbers ?
 

doogald

Trusted Member
Oct 23, 2012
2,803
153
63
Visit site
If you are a programmer you could do it. I wrote a spreadsheet (excel, but same idea) that put calendar info into the appropriate iCal format, manually save a sheet of that spreadsheet in CSV (comma separated values), then a Perl script that reads through the CSV file and creates a .ics file that can be imported into iCal.

But if it is a professional team, you may be able to find an online calendar that you can subscribe to in iCal. I do that for Liverpool myself, and the great thing about this is that the entries are adjusted as fixtures are rescheduled. For Premier League teams, go here: https://www.premierleague.com/fixtures and click on the control "Sync schedules". If it is another team/league, you should be able to search for the team name and "sync schedule" or "sync fixtures". This will be a lot easier.
 

aapierre

Well-known member
Aug 24, 2011
49
1
8
Visit site
thanks

do you not find it odd that there isn't a csv style format file which can be used in numbers to upload multiple fixtures to a iCal
 

doogald

Trusted Member
Oct 23, 2012
2,803
153
63
Visit site
thanks

do you not find it odd that there isn't a csv style format file which can be used in numbers to upload multiple fixtures to a iCal

Not really. The number of people who need to do this is probably very small.

Incidentally, this is quite possible with Google Calendar. You can import CSV files in a particular format, and Google Calendars can be subscribed to in Apple Calendar on iOS and MacOS.
 

Latest posts

Trending Posts

Members online

Forum statistics

Threads
262,069
Messages
1,773,544
Members
441,382
Latest member
Mohammadreza