Extract data in Excel Power Query

[Kal_Lam]

Welcome to the community, @Judinator! Maybe this post discussed previously should help you solve your issue:

API Export to Excel Drops Hyperlinks to Photos

@mark_ej, we will be updating our support document very soon. Till then, maybe you could follow the steps outlined below: Step 1: Open your survey project and then make some downloads (by specifying a name to the Save selection as ...) as shown in the image below: [image] Step 2: Now in a new tab, use the following API: https://[kpi]/api/v2/assets/{asset_uid}/export-settings/ Here, kpi refers to kobo.humanitarianresponse.info if you are using the humanitarian server else kf.kobotoolbox.o…