All Collections
Assignr Help
Working with Games
How to Batch Update Games with a Spreadsheet
How to Batch Update Games with a Spreadsheet

Have a lot of changes to make? If you have a spreadsheet with a Game ID, you can update your games by uploading a spreadsheet of changes.

Jeff Wigal avatar
Written by Jeff Wigal
Updated over a week ago

If you want to make batch updates to your games, you can do so in two different ways:

  1. Via our Batch Update feature, which you can learn how to use here. Recommended for most scenarios.

  2. Via spreadsheet import, which you can learn how to do below. πŸ‘‡ Recommended if you prefer to work in a spreadsheet.

The Basic Process.

The general process for updating via spreadsheet looks like this:

  1. Download a spreadsheet of your games from the Games β†’ All Games page.

  2. Delete any rows of games that will not be changed.

  3. Edit your game data in the spreadsheet, then save it.

  4. Upload the updated spreadsheet into Games β†’ All Games.

Step-By-Step Instructions.

1. Download your existing games.

To do this, follow these steps:

1. Navigate to Games β†’ All Games.

2. At the bottom of the page, select Download β†’ Games as CSV.

2. Update your exported spreadsheet of Games.

To do this, follow these steps:

1. Open your downloaded spreadsheet in Excel, or the spreadsheet program of your choice.

2. Remove any games (rows) from the spreadsheet that you are not changing.

3. Make whatever changes you need to, to the games in the spreadsheet.

🚨 NOTE : be sure the Assignr Database ID column remains in the spreadsheet, and is not changed, as this column will be used by the platform to successfully make your updates.

4. Optional : Remove any columns that you are not changing. For example, if you are only changing date, time, and venue, you can remove columns such as age group, game type, league, etc. Again, just be sure to leave that Assignr Database ID column. πŸ‘

Minimally, your spreadsheet might look something like this, assuming that you are only changing dates, times, venues, or age groups:

5. Once you have made the changes in the spreadsheet, save it to your computer.

3. Import your Updated Spreadsheet.

To do this, you'll want to follow these steps:

1. Navigate to the Games β†’ All Games page.

2. Select Import a Spreadsheet.

3. Select Choose File.

4. Select the updated spreadsheet you just saved.

5. Select Open.

6. Select Update File.

7. Map your spreadsheet's column headers with the Assignr field names.

A few things to note about this step:

  1. Double-Check Mapping. The platform will attempt to match your fields itself, but it's always a good idea to double-check for any errors.

  2. Skip This Column. For columns that will not be changed in your site, choose the (skip this column) option. This will ensure that this particular field is not updated for any of your games.

  3. Assignr Database ID. Last but not least, locate the Assignr Database ID column, and ensure that you choose Assignr Database ID (for update) in the corresponding dropdown. This tells the platform that your spreadsheet is an update of existing games, rather than an import of new games.

8. Select a Default Pattern.

9. At the bottom of the screen, select Update Existing Games from Assignr Database ID. (If you prefer, you may also opt to update existing games using your internal Game ID).

10. Select Submit.

Your game updates will now be reflected in the Games β†’ All Games page. πŸ‘

Frequently Asked Questions β€” Batch Updating Games with a Spreadsheet

1. Can I import assigned officials from a spreadsheet, when doing a batch update of games?

Yes! This can be done by following the steps in this article (above). The main difference is you'll want to make sure you have one column in your spreadsheet for each expected position (e.g. position 1, position 2, or whatever you want to call them). Then, you'll type the name of the official to be assigned to each position, in the corresponding cell for each game.

Two things to note:

  1. Name Format. The officials' names must match their names in your site in order for this to work. Their names can be either first last or last, first (e.g. 'Ted Lasso' or 'Lasso, Ted').

  2. Field Mapping. When you import the games, you will need to indicate that these columns represent the assigned officials. On the review screen, when Assignr prompts you to review the columns of your spreadsheet, you will need to switch these columns to their respective Assigned Official 1, Assigned Official 2, and Assigned Official 3 fields.

2. Can I batch update the People in my site using this import process, as well?

Yes! Just follow the same steps as above, but from the People β†’ All People page, instead of the Games page.

Step-by-step instructions can be found in this article: How to Batch Update People with a Spreadsheet.

Have a question on how this process works? Contact us, and we'd be happy to help you out!

Did this answer your question?