The 2017 Calendar of MotoGP™ is published on the web. Is there any way to import MotoGP 2017 events to my Google Calendar?
Google Calendar – Import MotoGP 2017 Events
google-calendarimport
Related Solutions
You can get an iCal link for your Upcoming Events (or Birthdays) that you can import into Google Calendar which will automatically stay up to date.
In Facebook:
- Go to your Events.
- On the left sidebar, click Calendar
Go to the lower right portion of the page, where you'll see a message with two links:
Save the URL for the Upcoming Events link. (This will vary by browser/OS, but is generally something like right-click and Copy link address)
The URL should be similar to:
webcal://www.facebook.com/ical/u.php?uid=999999999&key=AbCDEf12345AAcd-f
(Your actual uid and key values will be different, of course.)
In Google Calendar:
Scroll down and open the Other calendars menu (on the left)
Choose Add by URL
Paste the webcal URL in the URL space then Add Calendar
You should now have a calendar {Your Name}'s Facebook Events listed under Other Calendars and can change the color, details, etc. as needed.
See also: Facebook Help - How do I export my events or friends' birthdays?
Yes.
From the Google Calendar site go to settings and then to the "Calendars" tab. About half way down the page under your list of current calendars is an "import calendar" link. You can pull in calendar data in iCal or CSV formats.
See Google's help page for more details.
Related Topic
- Google-calendar – Shift events in Google Calendar
- Google-calendar – Google Calendar changing primary calendar events’ time
- Google Calendar – Duplicating Events with Different Dates/Times
- Facebook Events – How to Synchronize ‘Attending’ Events with Google Calendar
- Google-calendar – New Google Calendar (2017) Quick Add
- Google Calendar – How to Copy All Events from One Calendar to Another
Best Answer
Yes, such a calendar (displayed as a table on a webpage) can be imported in Google Calendar, though not without a little headache. My strategy is to use
importhtmlto import it in a spreadsheet, then save as CSV file, and import it into calendar.Step 1: Make sure the Locale setting of your Google spreadsheet is consistent with the date format used on the webpage you are importing. For example, I normally have United States as the locale (with date format mm/dd) but the MotoGP calendar uses dd/mm, so I changed my locale to Germany for this experiment.
Step 2: import the calendar with
Let's say this formula is in A1 of Sheet1. The semicolons are used as separators because of European locale. The dates should be recognized as dates except since they don't have a year, the year will be assumed to be the current one. If you are doing this in 2016 for 2017 calendar... this will be need to be fixed on the next step.
Step 3: Create another sheet, with the top row headers "Subject" and "Start Date" as Google instructs. Under the first header, put
={Sheet1!C2:C19}to get the event names. Under the second, put=arrayformula(text(Sheet1!B2:B19+365; "yyyy-mm-dd"))which adds 365 to each event date*, moving it from 2016 to 2017, and then formats it in the internationally accepted way.Step 4: Save the sheet with these two columns as a CSV file. Then follow the instructions om importing events: "Settings > Calendars > Import Calendar".
(*) Why 365, when 2016 is a leap year? Because all of the events happen in March or later... bullet dodged. Dates are fun.