Exporting from Numbers to Calendar
I organise the timetable for courses at a university in a spreadsheet. I’d like to import the finalised data into my Mac Calendar. I know I can export the spreadsheet data to a CSV file, but there doesn't seem to be an easy way to then import into Calendar or convert into an ICS file. Any suggestions? Mick Jones You can convert CSV files to ICS, but there are some very strict formatting rules. The first row of the spreadsheet must have the following headers: Subject, Start Date, Start Time, End Date, End Time, All Day Event, Description, Location, Private. You have to use these labels exactly, including the correct capitalisation and you have to include all of them. Start and end dates must be formatted as MM/ DD/YYYY and times have to be formatted as either 18:31 or 06:31 PM. ‘All Day Event’ and ‘Private’ must be either ‘True’ or ‘False’. Private doesn’t seem to do anything but you still need to include it.
Put each event on a separate row and export it as a CSV file. To turn it into an ICS, you can either upload it to Google Calendar and then download it again as an ICS, or use the conversion tool at n8henrie.com/wp-content/uploads/2014/01.