How to Use a Single Excel Spreadsheet with Multiple Competitions

In Spinify, while you can create a new spreadsheet for each competition, you can also use a single Excel Workbook as a data source for multiple competitions. 

If you would like to set up multiple competitions with the same spreadsheet, please follow the instructions below.

1. Make sure Excel is Integrated.

Make sure you've integrated Excel with Spinify. The easiest way to check this is to go to the Integrations page and make sure it says "Actions".

mceclip0.png

If the tile says "Connect", please see: How to integrate Spinify with Excel for instructions. 

2. Create an Excel spreadsheet in your Microsoft OneDrive account

If you haven't already created at least one Excel Spreadsheet, see: How To Configure Excel Spreadsheets for Spinify Competitions.

On the spreadsheet, you'll need to add an additional column to use for the relevant scores for each competition. For example, you may want to track the number of sales made and the total value of the sales. In that case, the spreadsheet would look like this:

image.png

Note: You cannot create multiple competitions using separate spreadsheets within the same Excel Workbook, you must either use separate columns in a single sheet or create a new sheet for each competition. 

3. Create Competitions using Different Excel spreadsheet columns

When creating a competition on an Excel Spreadsheet choose “Excel Data” under the goal option.

excel_select_app.gif

Choose a different score column for each competition.

GS_choose_column.gif

For additional help with this, see: How To Configure Excel Spreadsheets for Spinify Competitions.

Otherwise, you can reach out to us on chat by clicking the “💬 Help” icon on the bottom right of this page.

Note: If you have not created MySpinify users yet, see: How To Add Users.

 

 
Was this article helpful?
0 out of 0 found this helpful