III. Import Google ICS File into Metro Publisher Enter ‘False’ (without quotes) for public events.
Open your file in a spreadsheet program, such as a Google Docs table. Not all data exports or CSVs are created equal.ġ. CSV stands for comma-separated value, so a CSV file only means that whatever data it contains is separated by commas. The first step is to take your XLS or CSV file and convert it into a properly formatted CSV file that can then be converted to ICS.
Additionally, since these third party events were entered by humans, there is no guarantee of the consistency or quality of the event data you have been given. Unfortunately, there is no standard (other than ICS) for event data. WARNING: While this method will work in many cases, it is not perfect and has limitations which are outlined below.