mamaapi.blogg.se

With this, you should be able to see the dialogue box to input your login credentials. Here, you will need to press Clear Permissions. You will now be able to see a dialogue box, Data source settings. In such case, you will have to do the following to reset your Excel’s Data Source Settings.Ĭlick on Data and under Data you will need to click on Get Data. Sometimes, you may not be able to see the dialogue box to input your login credentials. Troubleshooting ¶ Reset Excel’s Data Source Settings ¶ Use your KoBoToolbox credentials and that should load your data to Excel. You should be able to see a place where you are able to input your login credentials. You should now see a new dialogue box as shown in the image below: When you get the dialogue box, paste your URL. Rather than exposing your data publicly, you can use your KoBoToolbox login credentials to authenticate your request: Pulling data in Microsoft Excel (without making data public) ¶

You should now see a dialogue box to paste your URL and start pulling data from the server. Then click on Data, and under Data, click on From Web. Pulling data in Microsoft Excel (by making data public) ¶īefore transitioning over to Excel, ensure that there is at least one record stored in your data table in KoboToolbox and that you have made your data public by checking Anyone can view submissions made to this form from SETTINGS>Sharing. To pull the data, take the form URL ( ) and replace ?format=xls with.