Copy all events from one year to next year

Question

_{Tuesday, November 5, 2019 2:29 PM}

Hi, I have lot's of events in 2019 and I'd like to copy them massively into 2020 calendar and make few changes after.

Is it possible to copy massively all the 2019 events into 2020 calendar. Same days but different year?

Thanks

Francesco

All replies (8)

_{Friday, November 8, 2019 4:53 PM ✅Answered}

Ok I found a much easier way, well for me.

1) In Outlook --> go to list view --> copy and paste all the events into excel

2) In Excel --> change dates and pay attention to the date format MM/DD or DD/MM

3) In SharePoint Calendar --> go to Current View All Events --> Click on Edit --> go to the bottom of the list --> copy and paste from excel into here

After that in Outlook you can easily modify and move events based on new weekends or anything else

Hope this can help someone else.

Ciao

_{Tuesday, November 5, 2019 4:05 PM}

I don't think that can be possible under the same list unless if you have any third party tools like sharegate.

Thanks & Regards,

sharath aluri

_{Wednesday, November 6, 2019 2:36 AM}

Hi,

There is no OOB solution to copy events of a specific year to another.

As a workaround, you can copy the events to another calendar list with PowerShell and then manually modify Start Time and End Time with Datasheet View. 

You can also create a calculated column and use formula “=YEAR([Start Time])” to sort the events based on which year.

Here’s a reference on how to copy calendar events with PowerShell for you.

SharePoint 2010 + PowerShell: Export/Import Calendar Items.

Please note: Microsoft provides third-party contact information to help you find technical support. This contact information may change without notice. Microsoft does not guarantee the accuracy of this third-party contact information.

Best regards,

Chelsea Wu

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click here to download it.
Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

_{Wednesday, November 6, 2019 2:53 PM}

Thanks Chelsea Wu, is it required to create a new calendar or I can keep the same one. The one I have already is working, lot's of people have been authorized to it and it has been connected into all local outlook... so I'd prefer to keep the same calendar and duplicate all the events

thanks

Francesco

_{Thursday, November 7, 2019 1:16 AM}

Hi,

The same calendar list would do as well. 

Just use the same list name after the parameters “$sourceListName” and “$destListName”.

Best regards,

Chelsea Wu

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click here to download it.
Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

_{Friday, November 8, 2019 7:27 AM}

Hi,

I'm checking how it is going on with this issue.

Please remember to update this thread if you have any progress.

Thank you for your understanding.

Best regards,

Chelsea Wu

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click here to download it.
Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

_{Monday, November 11, 2019 1:10 AM}

Hi,

Thanks for sharing your solution.

You can mark your latest reply as the answer if you would like.

It will do great help to those who meet the similar question in this forum.

Thanks again for your contribution.

Best regards,

Chelsea Wu

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click here to download it.
Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.

_{Thursday, November 28, 2019 1:50 AM}

Hi, 

Here I will provide a summary of this post for your information.

[Copy all events from one year to next year - Summary]

Expectation/Request

Copy 2019 events massively into 2020 calendar

Environment

SharePoint 2010

Solution

Refer to CescoIT’s reply, the solution is:

1. Open Outlook and go to list view. Copy and paste all the events into Excel.

2. Change dates in Excel workbook and pay attention to the date format MM/DD or DD/MM.

3. Navigate to SharePoint Calendar list and switch to Current View All Events. Click Edit and then paste all the new events from Excel.

Best regards,

Chelsea Wu

Please remember to mark the replies as answers if they helped. If you have feedback for TechNet Subscriber Support, contact [email protected].

SharePoint Server 2019 has been released, you can click here to download it.
Click here to learn new features. Visit the dedicated forum to share, explore and talk to experts about SharePoint Server 2019.