How To: Upload 100 Events in 3 Minutes

Our Bulk Uploader is a useful, time-saving tool that allows you to upload as many events as you like in one go, rather than having to do them all individually, which can be painstaking and time-consuming.

Widgety users don’t automatically have rights to use the Bulk Uploader, so if you would like to use it please get in touch and we can grant you access.

Once granted, it will appear in the navigation bar on the left hand side of your Widgety dashboard.

If you don’t have it already, you can click on ‘Download Sample File’, which will give you the required fields for the upload. Open the file in Excel or equivalent. Alternatively you can download it here.

Filling out the Spreadsheet

The event online that we want to Bulk Upload to Widgety. Almost all the information needed is on this page, it just needs putting in the spreadsheet.

The event online that we want to Bulk Upload to Widgety. Almost all the information needed is on this page, it just needs putting in the spreadsheet.

The fields with a * next to them mean that they are mandatory. The upload will not work if you miss any of these out. The more information you have the better, so it’s best not to ignore any of the fields.

The date and time fields will only accept certain formats (you can see the full list here) but it is usually best to use DD/MM/YYYY and a 12 hour clock with AM or PM. Publish date and time are when you want the events to go live on the Widgety system.

Events Bulk Uploader 1

The times on our system go in half-hour intervals. This means that if your event starts at 1:10pm, you will need to put 1pm in the spreadsheet (it’s better to start an event early than late!). This applies to all time fields.

The Event Title, Description and Ticket Information fields can be typed in as normal text; copy and paste whatever information you have into here.

Ticketing URL is the web address where you can purchase tickets. If tickets are only available by contacting by phone or email, put that information in the other 'Ticket Information' box.

For the social media fields, it is important that you only include the slug (handle) of your Facebook or Twitter page. In this example the Facebook slug is winchestersciencecentre, and not https://www.facebook.com/winchestersciencecentre/. Don’t include any other punctuation or spaces, it has to be exact else the upload will fail.

In this instance, we have uploaded the same event that occurs every day for two weeks. Once the information is complete once, all of the fields can be duplicated apart from the start and end dates. One event can become two, fourteen or a hundred in a matter of seconds.

Download or have to hand any images you want to go with your events, and name them so that you’ll be able to find them again in the future. Use a ‘Business/Attraction Name Event Name’ format if you’re unsure (this one was Winchester Science Centre We Are Aliens).

This file would be called 'Winchester Science Centre We Are Aliens', making it easy to find and identify in the future.

This file would be called 'Winchester Science Centre We Are Aliens', making it easy to find and identify in the future.

Once you have filled out all the information, save the file as a .csv and then either; send it to us to double check and upload or have a go at uploading it yourself.