Csv To Ical Converter

• Csv To Ical Converter Free
• Csv To Ical Converter App
• Csv To Ical Converter Heic
• Csv To Ical Converter Freeware
• Csv To Ical Calendar Converter
• Csv To Ical Converter Online

CSV-to-ICS Converter is a free and simple tool for converting calendar data from comma-separated value (CSV) and tab-separated value (TSV) formatted files into standard iCalendar (ICS) formatted. CSV-to-ICS Converter is a free tool for converting text files (CSV or TSV) into ICS files. CSV files are formatted with comma-separated values and TSV files are formatted with tab-separated values. You can create a CSV or TSV file using any spreadsheet editor, such as Excel or OpenOffice, or by exporting from a database. 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. CSV stands for comma-separated value, so a CSV file only means that whatever data it contains is separated by commas. Not all data exports or CSVs are created equal. Convert a CSV file into an ICS calendar. Csv2ics needs to know which columns are mapped to which ICAL properties. This can not be easily specified through CSV headers, so we rely on the header map. The header map is a comma separated list of strings that specify the matching ICAL-properties for each column.

Bottom line: You can batch import events from a spreadsheet to iCal or Google Calendar by formatting the headers correctly, exporting / import as .csv, then export / import as .ics.

Update May 07, 2013: This post has been completely rewritten and updated here: http://n8henrie.com/2013/05/spreadsheet-to-calendar. Feel free to reference this post as well, but the new post is much more thorough and has a few new tools that I wrote to facilitate the process of getting spreadsheet events into your calendar app of choice.

NB: This process works for me using Numbers.app, Google Calendar, and iCal. I think it should also work with Excel or Google Docs spreadsheets, but I can’t say for sure.

I try to keep all of my appointments in a digital calendar that syncs across all my devices. It’s a big deal for me – I really like to be able to look in one place to find out where I ought to be at any given moment. Getting a syncing, mobile-accessible calendar for the lecture-based years of medical school was actually a major objective leading to the creation of our medical student group, SMRT. I previously used Google Calendar but have recently converted to iCal / iCloud (mostly due to issues deleting events from Google Calendar with my iPhone – a bug that persisted for years and drove me nuts).

Over the last year or so, I’ve been handed a new schedule every month or two on my rotations. Unfortunately, these have almost always been in some kind of spreadsheet format (or they’re printed from a spreadsheet, which I request be emailed to me). Because calendaring software doesn’t know how to interpret spreadsheet information directly, I’ve developed a workflow that is a bit circuitous but not terribly onerous and allows me to bulk convert and import my spreadsheet schedules.

This process requires a Google Calendar account to process one of the files and spit out another format. You don’t have to use it for calendaring, but you can. This whole process may take from 10 minutes to an hour depending on your skill with spreadsheets and a bit of luck.

Main Idea

1. Give the spreadsheet the appropriate headers and format it to make Google Calendar happy
2. Export as comma separated values (csv)
3. Import to Google Calendar (stop here if you’re a GCal user, continue if iCal user)
4. Use Google Calendar to export to iCalendar format (.ics, iCalendar is not the same as iCal)
5. Import the .ics to iCal

1. Headers and Spreadsheet Formatting

This is the hardest and most important step. In order for step 3 to work, you have to get the spreadsheet set up correctly. First, open up a copy of my spreadsheet template, which you can

Please note that the Numbers.app version also has some embedded instructions inrough draft format (nothing not posted here). I think these also show up in theExcel version, but not in the GDocs version.

Basically, it’s just a spreadsheet with the headers that Google Calendar willrecognize (source).These are:

You should take your spreadsheet schedule and copy and paste the information into the appropriate columns. Keep in mind that Numbers can convert date and time formats pretty well by selecting the column in question and opening up Inspector (“command option i” or view -> inspector) to “cells” (a box with “42” on my version). Makes converting a bunch of “Jan 5 2002” to “01/05/2002” a snap. Leave the columns in the order you found them. Other formatting info:

• Subject: The event title
• Dates: MM/DD/YYYY format seems to work for me.
• Times: both “7:00 PM” and “19:00” formats seem to work
• All day event: Will be true / false (checked or unchecked in Numbers)
• Description: The “notes” part, optional
• Location: Optional
• Private: Another true / false checkbox, will make events on a shared calendar private to everyone but “owners.” I think this is also optional / no response required.

2. Export as .csv

File -> export in Numbers, unicode seems to work fine. AFAIK, the equivalent functions in Excel and Google Docs should work just as well. If you have multiple sheets in Numbers, it will export to a folder with multiple .csv files. Figure out which one has the data you need with Quick Look or a text editor, you can delete the other .csv files.

3. Import to Google Calendar

Head over to Google Calendar. If this is home base for you, you can import the events directly to your calendar. If this is just an intermediary step, I recommend creating a new temporary / junk calendar for this purpose.

Optional: How to create a temporary calendar: Click the down arrow to the right of “My Calendars” in the left hand column to create a new calendar. Name it “junk,” or “osdifj,” or whatever you want, you can delete it later.

Next, head to your main calendar settings by clicking the same right arrow mentioned above. Towards the middle of the screen, look for the import calendar button. Click it, make sure you have the right calendar selected in the bottom box, then navigate to the file and click “import.”

You will now either get an error message, which probably means you need to go back to Step 1 and make sure everything is formatted correctly (can you tell this has happened to me a few times?), or you will have imported your schedule. Look through GCal to make sure everything looks right. If so, congrats! Google Calendar users can end their journey here, thanks for reading. If you want to import to iCal, you’re getting close.

4. Export to iCalendar Format

A couple of options here. Either

• Click the “export calendars” button immediately to the right of the “import calendar” button from above, downloading a .zip of all your Google Calendars in .ics format (haven’t tried this but appears to work), or
• Still in Google Calendar settings, click the name of the calendar, then click the private “ICAL” button on the next screen, then click the link one more time to download the .ics file. If you have trouble, try option + click, which tries to download a link as a file (on a Mac).

Once you have the .ics file, you can…

5. Import the .ics to iCal

Easy as can be. In iCal’s menu, File -> Import -> Import, and select the .ics file. Choose to import to whichever calendar you please. Should sync to iCloud just fine, assuming that you import to an iCloud synced calendar. Also, I recommend you go back to Google Calendar’s settings and delete the temporary calendar you created in Step 3. Keeps everything cleaned up.

Phew.

Seems like a lot of work, but goes quickly once you’ve done it a few times. It’s especially worthwhile when you have lots of events or lots of “description” info in your spreadsheet that you don’t want to retype. On the other hand, if you don’t have that many events, I highly recommend QuickCal for inputting events to iCal on the Mac. Not only is it a solid, user-friendly, lightweight app, but the devs just seem like good people. They have directly incorporated my feedback into their updates a few times now; their customer support is top notch.

Let me know in the comments if this works out, if you run into issues, or most importantly if you find an easier way to get your spreadsheet schedule into iCal.

Use this tool to convert a calendar from the CSV format (commonly used by Yahoo Calendar and Microsoft Outlook) to the iCalendar format (used by Google Calendar, iPhone, and iCal).

How to make your own CSV file

If you have existing data that you’d like to use with this tool, you cancreate a CSV file using any spreadsheet editor. CSV stands for comma-separatedvalue, so a CSV file only means that whatever data it contains is separated bycommas. In order for this conversion to succeed, the file must contain certainspecific data fields, in a certain order, with data in a certain format. Notall CSVs are created equal: to be compatible, the CSV must have the followingfields, in order.

Csv To Ical Converter Free

Use at your own premises

Csv To Ical Converter App

This time-tested CSV to iCal Convertor is now available for use at your own premises. You canpurchase a license to install it on multiple servers for multiple users, as long as they are allaffiliated with your organization.

Disclaimer and Known Issues

This service is provided as-is and with no warranties, and this conversion maynot work for all calendars.

Csv To Ical Converter Heic

Because of the limited information that is available in the exported file,conversions will not be perfect. For example, repeated events are notcorrectly included in Yahoo’s CSV file. Hence, for an event that repeats, sayevery year, you will see one entry for each such year, up to the year 2038.The convertor does not automatically detect such erroneous duplicates at thispoint, though this may change in the future.

Csv To Ical Converter Freeware

If it fails to convert your calendar, please feel free to reach out to me. Mycontact information is available in the sidebar.

Csv To Ical Calendar Converter

Privacy Policy

Csv To Ical Converter Online

Files that you submit for conversion via this tool may be retained andanalyzed to improve the tool.