Import CSV into Google Calendar: 7 Troubleshooting Tips
Posted on: 09/16/2021
I've covered how to import a CSV file into your Google Calendar in detail before, but as students have gone back to university, I'm getting a lot of questions and emails saying that their import to Google Calendar isn't working. So I've thought I would cover a few troubleshooting tips to make sure your CSV file is formatted correctly and help your import succeed.
Tip 1: Make sure required fields are filled in
There are two required fields in that header row. One is the header row, it has Subject and Start Date. you must have something in there so you can't leave the Subject blank. In real life though, you usually fill in most of these fields, I really see it with just two fields filled in. So troubleshooting tip number one is make sure Subject is filled in.
Tip 2: Correct date formatting
This is probably the biggest one I see. That Start Date, and the End Date, they have got to be set up, if you noticed here, these dates are correct, when I select them in Excel, they say Date, which is actually Short Date.
When the dates are not formatted correctly, I get down to these dates, and even though they're correct in the formula bar, in the number group, they say Custom. So that is going to be an issue.
To properly format them, highlight the dates in your range and tell Excel to force these to Short Date. The format must be M/D/Y. That is what you want. To do the exact same thing with the End Date, that is going to be Short Date as well. So that is troubleshooting tip number two: Make sure your Start Date and End Date are Short Dates.
Tip 3: Correct time formatting
Troubleshooting tip number three, your times. Make sure your columns for time are formatted correctly as Time. Again, they may look correct but when you select them, some may be Custom. Make sure time fields are in fact, Time.
Tip 4: All-day events should have no times
If you have events you're trying to import and they are all-day events, you have this column All day event. Normally, your events have times and this field is set to FALSE, which is correct. I have seen this set as an all-day event set to true. If All Day Event is true, there should be no Start and End time in those rows.
Your description is a text field, you can use it, whatever you want to. Private means it's only for you, this is either true or false. And you can use the Location field, which is also a text field.
Tip 5: Start and End Dates should be chronological
One more tip I've got for you is, I have seen one student sent me their file and it pulled in approximately 120 of 160 events. They were wondering why the other 40 didn't come in. So I ran a quick formula because the dates looked a little weird, even though they were formatted correctly. If you get any date difference less than zero between Stard and End date, that's not going to work because it has to be zero or greater. Because the end date's got to be at least the Start Date or in the future. So make sure if you see any negatives, you go fix that.
Tip 6: No blank rows in data
Make sure there's no blank rows in your data. That will cause your import to fail or miss those events after the blank rows.
So to quickly fix this and remove the blank rows:
-
Go to the end of the data
-
Click on the last one
-
Press Control + Shift + Home key to highlight them all
-
Just go do a sort, I don't even care what you sort by, indicate whether your data has headers, sort by subject for example
-
Click OK to get rid of the blanks real quick
Tip 7: Stick with the allowed fields
One other tip about the header row, if you add a column in here - I've seen students adding columns in here with other data - it's not going to pick it up on the import, just to be clear about that. Those fields that you see are the only fields that Google Calendar allows and to prevent any problems or errors, keep to the fields that are allowed.
Import the file into a new calendar
I wanted to test my file because I always like to check and make sure the file I want to import to Google Calendar is formatted correctly. I had a file with 117 events as an example:
And here's an important tip for you:
Whenever I import data into the calendar, I first create a separate 'testing' calendar, to prevent from importing wrong data into my main calendar. Google Calendar does not have a function to mass-delete events so if anything goes wrong or events are imported in the wrong dates, etc., I will litter my calendar with a lot of wrong events.
So what I do is, I've got my Google Calendar running. It may be my personal Chris Menard calendar. Even if I wasn't testing, I'd still recommend you import many related events into a separate calendar, such as 'College Calendar' or 'University Calendar', whatever you want to call it.
How to add a new calendar in Google Calendar
-
In Google Calendar, go to Settings and Sharing > Add calendar > Create a new calendar.
-
Give your calendar a name, I'm going to call it "College 2022 dates".
-
Click on Create.
-
Import. In the dialog, go and change it first, so I don't accidentally pull it onto my calendar. Select "College 2022 dates."
-
Locate the file you want to import from, click on Import.
-
There should be my 117 events
Deleting a calendar
On the Google Calendar sidebar, you have all the calendars, including the one you've just added. You can turn them on and off.
If you want to delete the calendar, maybe you don't want to keep the one you used as a test, it's easy to just to pull up. So now if I wanted to get rid of that calendar, since my tests worked, you click on it and you go all the way to the bottom and there's Delete.
Make sure you got the right calendar before you hit Permanently delete.
More Google Calendar articles and videos
Google Calendar - The Best Keyboard Shortcuts to Navigate and Move around
Google Calendar has been around since 2009 for general release. In this short video, I'll show keyboard shortcuts for navigating the Google calendar with different views, and quickly getting around. We will look at various views: day view, week view, month view, schedule view, and year view.
Chris Menard
Chris Menard is a Microsoft Trainer (MCT) and works as a full-time Trainer at BakerHostetler - one of the largest law firms in the US. Chris runs a YouTube channel with 900+ technology videos that cover various tools such as Excel, Word, Zoom, Teams, Gmail, Copilot, Google Calendar, and Outlook. To date, the channel has helped over 20 million viewers.
Menard also does 2 to 3 public speaking events yearly, presenting at the Administrative Professional Conference (APC), the EA Ignite Conference, the University of Georgia, and CPA conferences. You can connect with him on LinkedIn at https://chrismenardtraining.com/linkedin or watch his videos on YouTube at https://chrismenardtraining.com/youtube.
Categories