Goal: Import an external calendar which is in CSV format into your Office 365 SharePoint Online site.
To accomplish this, you have to
- import the *.CSV into a Custom List in SharePoint via Import Spreadsheet app.
- Once that is done, create a custom ‘Calendar View’ for the list.
Steps:
- Office 365 site settings ->Add an app
- In the search box, type Import. This will list the import spreadsheet app. As shown below.
- Give Name, description and add your .CSV into the File Location:
- This will open the file in Excel. You can choose the ‘Range of Cells’ from the first cell to the last in the sheet. Excel Tip: Once you click on the Select Range, select the first cell(A1) in excel and Ctrl+Shift+End. This will select the last row. You can then select all the columns by Ctrl+Shift+Right arrow. Once all the columns and rows are selected, click the Import Depending on the number of rows your CSV has, it might take a few minutes to import all the data into a new list in SharePoint. Do NOT close Excel or SharePoint site at this time. Once all the rows are imported, the excel automatically closes and you will be taken to the SharePoint Imported List.
- On your imported list in SharePoint, click Create View
- Select ‘Calendar View’
- Give a name to the view, Make it as the default view. In the ‘Time Interval’ section, select the Begin and End time from the Start and End dates from your imported list.
- Select an appropriate title for Month View, Week View and Day View
- Choose Default Scope as Month and click OK..
- You now have successfully imported the CSV file into your SharePoint as Calendar
Discover more from QubitSage Chronicles
Subscribe to get the latest posts sent to your email.
Is there a way to do this with an existing Sharepoint Calendar
I just did this, but have discovered that I cannot add new items from clicking within the calendar. Any idea why?
Thanks!
This kind of partially works, but looks like if there is a recurring event, then that shows up as a long calendar entry spanning the whole recurrence period instead of just showing it as a recurring event. Any ideas on how to get around that?
same issue as Cindy’s, any comments? Appreciated.
When pulling an XLS or CSV file, I keep getting the displayed message “The Specified file is not a valid spreadsheet or contains no data to import”. It does not open the file in excel or get me the pop-up to pick from a range of cells for the data. This is on the Import Spreadsheet application when browsing for the specific file
Add your tenant to your intranet or trusted sites zone and then perform the action again in IE. (e.g: https://.sharepoint.com
One would assume it’s possible to edit posts. Especially if certain characters are removed. The example URL should contain your https:// (domain name) (dot) sharepoint.com. Just wanted to be clear.