List of Geopoints of Countries/Capital Cities in Excel

[JulietK]

Hi I am looking to use the Calculations on Geopoints method to map my Survey123 output data on a world map. 

For this I need geopoints data of all countries (or specifically, geopoints of the capital cities to make it consistent) in a format shown in this example. 

Does ArcGIS have a excel table of all countries and the corresponding geopoint data available for download? I'm planning to use this data with the ArcGIS World Countries Generalised Shapefile layer , so looking for something created by ArcGIS for good compatibility. 

Any help would be hugely appreciated! 

[Tim_McGinnes · Accepted solution]

It's not geopoint format, but there is an ESRI World Cities layer in ArcGIS Hub, which has direct download in spreadsheet (CSV) format:

https://hub.arcgis.com/datasets/6996f03a1b364dbab4008d99380370ed_0