How to create .ics events from a .csv file ?
I have a spreadsheet used to plan events months ahead of the event. I want to take the data from the .csv file and use it to create several .ics event files. I was able to do this from .csv to outlook, but now I need to import them from .csv to .ics because I want to be able to send my client the .ics event files rather than making them learn and have to regularly import the data themselves. Also due to very strict company policies, I cannot download a converter.
Example File:
Subject |
Start Date |
Start Time |
End Date |
End Time |
Location |
All Day Event |
Reminder Date |
Reminder Time |
Meeting Organizer |
Required Attendees |
Optional Attendees |
Description |
Test 1 |
1/25/2016 |
7:00 AM |
1/25/2016 |
8:00 AM |
Room 101 |
No |
1/25/2016 |
6:30 AM |
[Insert your email address] |
[Insert your email address] |
This is a test |
|
Test 2 |
1/26/2016 |
Room 101 |
Yes |
|||||||||
Test 3 |
||||||||||||
Test 4 |