Ex­port­ing from Num­bers to Cal­en­dar

Mac Format - - APPLETALK -

I or­gan­ise the timetable for cour­ses at a univer­sity in a spread­sheet. I’d like to im­port the fi­nalised data into my Mac Cal­en­dar. I know I can ex­port the spread­sheet data to a CSV file, but there doesn't seem to be an easy way to then im­port into Cal­en­dar or con­vert into an ICS file. Any sug­ges­tions? Mick Jones You can con­vert CSV files to ICS, but there are some very strict for­mat­ting rules. The first row of the spread­sheet must have the fol­low­ing head­ers: Sub­ject, Start Date, Start Time, End Date, End Time, All Day Event, De­scrip­tion, Lo­ca­tion, Pri­vate. You have to use th­ese la­bels ex­actly, in­clud­ing the cor­rect cap­i­tal­i­sa­tion and you have to in­clude all of them. Start and end dates must be for­mat­ted as MM/ DD/YYYY and times have to be for­mat­ted as ei­ther 18:31 or 06:31 PM. ‘All Day Event’ and ‘Pri­vate’ must be ei­ther ‘True’ or ‘False’. Pri­vate doesn’t seem to do any­thing but you still need to in­clude it.

Put each event on a sep­a­rate row and ex­port it as a CSV file. To turn it into an ICS, you can ei­ther up­load it to Google Cal­en­dar and then down­load it again as an ICS, or use the con­ver­sion tool at n8hen­rie.com/wp-con­tent/up­loads/2014/01.

Newspapers in English

Newspapers from Australia

© PressReader. All rights reserved.