SharePoint List Filtered View Export to Excel - Geo Location Is unreadable

Frequent Contributor

Hi All I am trying to export a filtered view from Sharepoint List but the geo location comes out really funky.  Is there a way to clean this up?

 

Any advice you can offer would be great.

 

{"EntityType":"PostalAddress","LocationUri":"https://www.bingapis.com/api/v6/geoentities?streetaddress=4000+Wellness+Dr&locality=Midland&region=M...","DisplayName":"4000 Wellness Dr","Address":{"Street":"40ess Dr","City":"Midd","State":"Michigan","CountryOrRegion":"United States","PostalCode":"48670"},"Coordinates":{"Latitude":null,"Longitude":null}}

 

Also, is there a way to create a button to PDF a particular sharepoint list view.  This SharePoiint list filtered view export is being consumed by the c-suite and the way it comes out is not as clean as I would like it to be and I can see them not being liking this.  

 

0 Replies