How to format a text file to be capable of being converted into an ICS file
CSV-to-ICS Converter can process text files that are formatted with comma-separated values (CSV) or tab-separated values (TSV). These files can be created in any spreadsheet editor, such as Excel or OpenOffice. The first row can be a header, defining the field names for data in the following rows. If a header row isn't specified, you'll need to first specify how the column indexes map to data fields. The Free Edition can convert files that contain 50 or fewer events (rows). The Pro and Ultimate Editions have no limitation on how many events can be in a converted file.
Total CSV Converter is a reliable tool for converting CSV and TSV files to PDF, XLS, XLSX, DBF, XML, JSON, HTML, TXT, DOC and a variety of OpenOffice formats. The program was designed to be convenient and user-friendly.
Csv Converter Mac
- This tool changes the column separator in Comma Separated Values (CSV) files to another symbol. You can customize the delimiter used in the input CSV file and the output CSV file. This delimiter changer also supports custom quote characters and can skip empty lines.
- ⭐ AnyConv is a five-star DOC to CSV converter tool ⭐ ️Convert doc files to csv online in seconds No software installation required Absolutely free Completely safe. Changing doc to csv is now easy!
An example CSV file is shown below:
The table below defines the default field names supported by CSV-to-ICS Converter, along with the possible field name variations. The fields can be defined in any order and the only mandatory fields are Title and Start (or Start Date and Start Time). All other fields are optional. If your fields have different names or if your file does not include a header row, the column mappings can be customized when using the Ultimate Edition.
| Field Name | Variations | Description |
|---|---|---|
| Title | Subject, Summary, Event | The event title text. |
| Location | Address, Room | The event location. |
| Category | Categories | The event category. If there are multiple categories, separate them with semicolons. Example: 'Work; Important; Follow-up' |
| Classification | Class | The event classification. Example values are PUBLIC, PRIVATE, CONFIDENTIAL, UNCLASS, CLASSIFIED, SECRET/NOFORN, TOP SECRET, etc. This field is only supported in the Ultimate Edition. |
| Priority | Priority Level, Importance | The event priority ('High', 'Medium', 'Low', or blank). |
| Description | Body, Message, Detail, Details, Notes, Memo | The event description. |
| URL | Webpage, Website, Web Page, Web Site, Related Page, Related URL | The URL of a webpage that is associated with the event. Some calendar programs don't import the URL field, so if you don't see the URL after importing the generated ICS file in your calendar program, try putting the URL in the Description field instead. |
| Start | Start Date/Time, Starting Date/Time, Begin | The event starting date and time. For an all-day event, just the date is needed. The format should match the date/time format used by Windows, as specified in the Control Panel, under 'Clock, Language, and Region > Change date, time, or number formats'. Use this field when you want to combine the starting date and time into a single field. If you want to separate the date and time fields, use the Start Date and Start Time fields instead. |
| Start Date | Starting Date, Begin Date | The event starting date. |
| Start Time | Starting Time, Begin Time | The event starting time. Leave blank for all-day events. |
| End | End Date/Time, Ending Date/Time, Finish, Due | The event ending date and time. For an all-day event, just the date is needed. The format should match the date/time format used by Windows, as specified in the Control Panel, under 'Clock, Language, and Region > Change date, time, or number formats'. Use this field when you want to combine the ending date and time into a single field. If you want to separate the date and time fields, use the End Date and End Time fields instead. If none of these fields are included, the Duration field will be used to calculate the ending date/time. |
| End Date | Ending Date, Finish Date, Due Date | The event ending date. |
| End Time | Ending Time, Finish Time, Due Time | The event ending time. Leave blank for all-day events. |
| Duration | Length | The event duration. The value should be formatted as 'N span', where N is a number of span is 'minutes', 'hours', 'days', 'weeks', or 'months'. Example: '30 minutes'. This field can be used as an alternative to the End, End Date, and End Time fields. The ending date/time will be calculated when this field is present. |
| Time Zone | Timezone, Time-Zone, Timezone Name, Timezone ID, TZ, TZID | The event time zone. The value should be one of the time zone names supported by Windows, such as 'Central Standard Time'. Each event can have a time zone specified. A mix of multiple time zones is supported. If not specified, the default time zone specified in the Options will be used. Unless you've changed the default time zone option, it will be the same as the local time zone used by Windows. NOTE: If the Export time zone Option is unchecked, this field will be ignored. |
| All Day | All Day Event, Entire Day, All-Day, All-Day Event | An all-day flag used for events that occur over the span of an entire day, such as birthdays and holidays. Values that are blank, 'No', or 'False' will be treated as non all-day events, while values of 'X', 'Yes', or 'True' will be treated as all-day. This format is also used by the Reminder, Recurs Daily, Recurs Weekly, Recurs Monthly, and Recurs Yearly fields. |
| Free/Busy | Busy, Busy Status | The busy status of an event. This status will be generated to both TRANSP and X-MICROSOFT-CDO-BUSYSTATUS properties in the output. Compatible software, such as Outlook and Google Calendar, will show the event status accordingly. Supported values are 'free', 'tentative', 'busy', and 'OOF' (out of office). Only 'free' and 'busy' are used for generating TRANSP values that are used by calendar programs other than Outlook. |
| Transparency | Transp | This field is similar to the Free/Busy field, but potentially supported in other calendar programs besides Outlook. Supported values are OPAQUE or TRANSPARENT. A value of OPAQUE means the event is considered busy and will block scheduling of other events at that time. A value of TRANSPARENT means the event is considered free and will not block scheduling of other events at the same time. This field is only supported in the Ultimate Edition. |
| Reminder | Popup, Popup Reminder, Popup Reminder Time, Reminder Time, Alert, Alert Time, Notification, Notification Time | The time before the event starts when a reminder should appear. If blank, there will be no reminder. Otherwise, specify the length of time as either a time of day or 'N span', similar to the Duration field's format. If a time of day is specified and a date is specified in the Reminder Date field, the reminder will appear at the specified time on that date. If only a time of day is specified, the reminder will appear at the specified time on the start date of the event. |
| Reminder Date | Popup Reminder Date, Alert Date, Notification Date | The date when a reminder should appear. The Reminder Time field can be used to also specify the time of day the reminder should appear on the reminder date. Leave blank if no reminder or if the Reminder Time field is an offset (such as '15 minutes') from the event start time. |
| Required Attendees | Attendee, Attendees, Recipients, Required, To | Required attendees for a meeting request. Multiple attendees can be separated with semicolons. Attendees can be specified with a name followed by an email address (example: 'John Doe <johndoe@gmail.com>') or just an email address. Note: CSV-to-ICS Converter won't automatically send a meeting notice. This will be up to the software used to import the resulting ICS file. For example, if importing into Outlook, each imported meeting will need to be opened and the Send button clicked in order to send the converted meeting notices. |
| Optional Attendees | Optional, CC | Optional attendees for a meeting request, formatted the same as Required Attendees. These attendees will be on the CC line when a meeting notice is sent. |
| Organizer | Meeting Organizer, From | The meeting organizer, formatted the same as Required Attendees. If left blank, the account or profile used in the software that imports the meeting notices from the ICS file will be the meeting organizer. If importing into Outlook, do not include an Organizer column. If the Organizer column is specified, the required and optional meeting attendees won't import. |
| Recurrence | Recurrence Summary, Recurs, Repeat, Repeats | This field specifies a basic recurrence pattern for the event. The first occurrence of the series is specified by the Start field. Supported values are 'Daily', 'Weekly', 'Monthly', and 'Yearly'. This field should be blank for events that don't recur. This field can be used as an alternative to the separate Recurs Daily, Recurs Weekly, Recurs Monthly, and Recurs Yearly fields. |
| Recurs Daily | Daily, Recur Daily | A flag indicating an event that recurs daily. The first occurrence and day-of-week are determined by the Start field. |
| Recurs Weekly | Weekly, Recur Weekly | A flag indicating an event that recurs weekly. The first occurrence and day-of-week are determined by the Start field. |
| Recurs Monthly | Monthly, Recur Monthly | A flag indicating an event that recurs monthly. The first occurrence and day-of-month are determined by the Start field. |
| Recurs Yearly | Yearly, Recur Yearly | A flag indicating an event that recurs yearly. The first occurrence and day-of-year are determined by the Start field. |
| Recurrence End Date | Recurrence End, Recurrence Stop Date, Recurrence Stop | The date when the specified recurrence pattern should end. No additional events will occur after the specified date. Leave blank if the event isn't recurring, doesn't have a known ending date, or if a value has been specified in the Number of Occurrences field. |
| Number of Occurrences | Max Occurrences, Maximum Occurrences, Occurrence Count, Recurrence Count, Occurrences | The maximum number of occurrences of the specified recurring series. Leave blank if the event isn't recurring, doesn't have a known number of occurrences, or if a value has been specified in the Recurrence End Date field. |
| Recurrence Interval | Recur Interval, Repeat Interval, Interval | A number indicating the interval between occurrences of the specified recurrence pattern. For example, if the recurrence pattern is daily and recurrence interval is set to 4, the recurring event will repeat every 4 days. Leave this number blank if the event isn't recurring or should repeat without an interval. |
| ID | UID, Unique ID, Key | A unique identifier for the event. Specifying unique identifiers will help ensure events are not duplicated when importing updated ICS files into other calendar programs. |
| X-label | Software-specific extension properties can be specified. These fill map directly to corresponding extension properties in the generated ICS file. Any column that begins with a X- prefix will be treated as an extension property. Example: ICS X-MOZ-GENERATION. Note, this feature requires the Ultimate Edition. Extension properties will be ignored when using the Pro or Free Edition. |
File To Csv Converter
Additional custom fields can also be present. The values in those fields will be processed when using the Ultimate Edition, or ignored when using the Free or Pro Editions. Custom field labels and values will appear in the event descriptions of the generated ICS file.
Csv To Qif Converter Freeware
Software-specific extension properties, such as X-MOZ-GENERATION, can also be present. Any field name that has an X- prefix will be treated as an extension property. If a value is specified, the extension property will be included within the corresponding VEVENT of the generated ICS file. This is an advanced feature and is only supported in the Ultimate Edition.