Skip to main content

How to update a forecast with an Excel template

Marie-Helene Sheeran avatar
Written by Marie-Helene Sheeran
Updated this week

You can create a new forecast from an Excel template, but you can also use Excel to add more predictions to an existing forecast.

Whether youโ€™re editing any existing predictions, or adding new predictions to a forecast, follow these steps:


Step 1 - Locate the Excel template

  1. Open the forecast you want to add predictions to.

  2. Click the button New prediction.

  3. Select the Excel upload option.


Step 2 - Download the template

If you already have added predictions via Excel, the last uploads will be available to download again from the list. Any new upload will override the previous upload, so make sure not to override any predictions that need to remain.

If there are no previous Excel predictions on this forecast, you can download the blank template.


Step 3 - Update the predictions

Next, fill the template with your predictions making sure to follow the guidelines.

You can:

  • Keep, change or remove any existing prediction values in the file.

  • Add any new predictions.

๐Ÿ“ŽNOTE: The uploaded file will overwrite all the values in the forecast.


Step 4 - Upload the template

  1. After you fill in the template, download a copy of it.

  2. Open the forecast, click New prediction, and select the Excel upload option.

  3. In the Update Excel predictions window, drop the file and click Finish.

Did this answer your question?