3/4/2023 0 Comments Microsoft excel for mac api![]() ![]() 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |