-1

I was trying to collect the birthdays of my friends in a csv file and trying to create events that repeat yearly so that I could wish them. But when I tried to import that CSV file into Google calendar, I was getting Imported 0 out of 0 events. Unable to process your iCal/CSV file.

I followed this post for naming the columns in the csv file. Any help is appreciated.
My Google Sheets file: SheetsLink

2

1 Answer 1

1

Your approach has several flaws:

Fix these and you will be able to import direct into Google Calendar BUT

  • Because every event has an "End Date" of "31/1/2100", every event is shown on EVERY day between the "Start Date" and the "End Date". (refer screenshot).
  • Since you are by-passing Google Contacts, you should set an "End Date" equal to the "Start Date", or a day or two after the the "Start Date".

screenshot

6
  • is there anyway to create an yearly recurring event from the csv file ? Dec 24, 2021 at 19:14
  • No (I mentioned this in the first line of the answer). A workaround would be to use Sheets to copy the entries, advance the year (I.e their birthday next year, the year after, etc), and then import multiple annual entries for each person.
    – Tedinoz
    Dec 24, 2021 at 23:33
  • If this answer was helpful, you might consider “accepting” it.
    – Tedinoz
    Dec 24, 2021 at 23:34
  • P.S. have you considered setting up your friends in Google Contacts, and then syncing to Google Calendar?
    – Tedinoz
    Dec 24, 2021 at 23:39
  • I thought of sharing this calendar to my friends too so that they could also be reminded. Hence I thought of creating as a Calendar rather than a Contact as everyone in the list is saved differently in other's contacts. Dec 25, 2021 at 14:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.