Location data when exporting from MS Lists to Excel

Copper Contributor

Hi Everyone

 

I am just working with Lists and I need some advice on formatting the location information so it looks more presentable.

 

This is an example of what is exporting:

 

{"EntityType":"LocalBusiness","LocationSource":"Bing","LocationUri":"https://www.bingapis.com/api/v6/localbusinesses/YN1029x7555097221641136189","UniqueId":"https://www.bingapis.com/api/v6/localbusinesses/YN1029x7555097221641136189","IsPreviouslyUsed":fal

 

Does anyone have any advice or a solution to this? 

 

Thanks in advance !

 

0 Replies