Visual Crossing Blog

Installing a Microsoft Excel Add-in via Microsoft AppSource

This step-by-step guide will show you how to install a add-in for Microsoft Excel via the Microsoft Office AppSource store. In this example we will install and configure the Visual Crossing Weather add-in. However, the same steps will apply to any Excel add-in that you wish to install from the AppSource store.

Step 1

Begin with your web browser pointed to the App Source page showing the Excel add-in that you wish to install. In this case, we will install the Weather add-in by Visual Crossing.

Select the add-in you would like to install

Step 2

Next click the blue “Get It Now” button on the upper left-hand side. This will prompt you for your App Source login. If you already have a login, you may enter it now and proceed to step 5. Otherwise, click on the “Sign up for a free account” link at the bottom of the login box.

Sign in to Microsoft AppSource

Step 3

You will now need to enter your email address and click on the “Next” button. If you get an error, please see the Errors section at the bottom of this walkthrough.

Sign in to Microsoft AppSource

Step 4

Next enter the appropriate information for your account. You will need to enter your name as well as create a new password. Note that after step 3 above, Microsoft sent an email to the address that you provided. This email contains the verification code that you need to enter in the middle of the box. Note that this email may take several minutes to arrive. If you don’t see it in your inbox, check your spam folder. Finally, click on the “Finish sign up” button. Again, if you get an error, please take a look at the Errors section below.

Sign in to Microsoft AppSource

Step 5

The signup process will now return you to the Weather add-in page where you will be asked to review the various policies and click Continue.

Sign in to Microsoft AppSource

Step 6

The next page prompts you to begin using the add-in using the desktop version of Microsoft Excel. To do so, click on the green “Open in Excel” button in the middle of the page. (Note that is you don’t have the Desktop version Microsoft Excel 2016, you can also try the Office Online version by click on the “Office Online” link immediately below the green button.

Sign in to Microsoft AppSource

Step 7

Depending upon your browser and settings, you may no be prompted to allow the link to be opened in Excel. If are you so prompted, click on the “Open Excel (desktop)” or similar option as shown below.

Sign in to Microsoft AppSource

Step 8

You may yet again be prompted for permission to open the link. If so, select the “Yes” option on the dialog. Note again, the this prompt and its appearance may vary based on your browser and browser settings.

Sign in to Microsoft AppSource

Step 9

Excel should now open and show you the initial add-in instruction prompt. In order to begin using the add-in you may need to click on the “Enable Editing” option in the yellow bar near the top. Note that this prompt may not appear in all cases depending upon your Excel settings.

Sign in to Microsoft AppSource

Step 10

Now the Weather add-in should open on the right-side wide of your Excel workbook. You will want to grab the separator between the worksheet and the add-in panel to make it larger so that you can see it better. Simple grab the separator and drag it to the left.

Sign in to Microsoft AppSource

Step 11

Assuming that you don’t already have a Visual Crossing account to use the Weather add-in, you will want to sign up for a free trial now. To do so, click on the “Free Trial” button in the add-in panel on the right-hand side. If you already have a Visual Crossing Weather login, you may enter it here instead and skip to step 19. Note that this login and password is not your Microsoft App Source login that you created above. Although you can use the same email and other details, you must sign up separately for a Visual Crossing Weather account.

Sign in to Microsoft AppSource

Step 12

You will now be prompted for your email address. You may use the same email as you used for the Microsoft App Source account or you may use a different one depending upon your needs. Once you have entered you email address click the “Verify email” button.

Sign in to Microsoft AppSource

Step 13

Once you have submitted your email, you will get a text box asking for the verification code that was sent to your email. Note that this verification code is different from the one that you received from Microsoft and entered in step 4 above. Again, this email may take a few minutes to arrive. If you can’t find it, check your spam folder.

Sign in to Microsoft AppSource

Step 14

You will next be prompted for a password for this new account. You may use the same password as you did for the Microsoft account above, but that is not recommended for security purposes.

Sign in to Microsoft AppSource

Step 15

Once you enter a password, you will be prompted to enter it a second time to verify. Once you enter it again, you will automatically forwarded to the next page if both passwords match.

Sign in to Microsoft AppSource

Step 16

You will now be asked for the type of account that you wish to create along with the standard verifications. For an individual user account, you will want to accept the default option of “Personal.” You will also need to review the terms and conditions and check the box to indicate your acceptance. It is also recommended that you check the box to receive notifications from Visual Crossing

Sign in to Microsoft AppSource

Step 17

Finally, you will be prompted for your login credentials so that you can begin using the Weather add-in. The first step is to enter your email address. This must be the same address that you entered in step 12 above.

Sign in to Microsoft AppSource

Step 18

You will now be prompted for your password also. Enter the password that you selected in step 14 above. Then click the “Sign in” button.

Sign in to Microsoft AppSource

Step 19

We are now ready to use the Visual Crossing Weather add-in. Let’s begin by doing a quick test to make sure that it is working properly. First, we will delete the help aid on the left side of the worksheet. Simply click anywhere on the edge of it, and hit the delete key on your keyboard.

Sign in to Microsoft AppSource

Step 20

Now we have our blank worksheet ready for data and the Weather panel opened on the right.

Sign in to Microsoft AppSource

Step 21

In order to test the Weather add-in, we will enter an address and a date and then request the historical weather records for that location at that date. First enter “Address” and “Date” in the first row of the sheet as your headers. Then enter a location (such as “Herndon, VA”) and a date within the past 10 years (such as “1/1/2019”). Note that dates in the very recent past, such as the last week or two, may not have historical weather data available yet.

Sign in to Microsoft AppSource

Step 22

Next drag select the first two columns on the worksheet. The will select all of the data in those two columns.

Sign in to Microsoft AppSource

Step 23

Clicking the range selection button on the Weather add-in panel will cause the Weather add-in to process the data that you selected on the sheet.

Sign in to Microsoft AppSource

Step 24

Since we named the column appropriately, the Weather add-in properly detected the data and populated the default option appropriately. You can now click on the “Populate” button near the bottom of the Weather panel to populate the historical weather information for the data and place the at you entered on your sheet.

Sign in to Microsoft AppSource

Step 25

The end result will be a sheet similar to the one shown below with the historical weather data populated to the right of your input data. (Note that this location and various other options can be changed in the setting of the Weather add-in panel on the right.)

Congratulations! You have successfully installed, configured, and used the Weather add-in for Microsoft Excel!

Errors

There are various errors that you may encounter during the process. Below are a few and their possible remedies.

Error 1

This error screen typically means that you entered an email address that is part of a corporate Microsoft Office program. In order to continue, you must either contact your Microsoft Office account administrator or use a different email address to complete the sign up process.

Sign in to Microsoft AppSource

Error 2

This error means that you entered an email that Microsoft considers to be for home use such as a Gmail address. Since certain email providers are allowed and certain other are not, you may be able to proceed by entering a email address from a different provider.

Sign in to Microsoft AppSource