English

How To: Append spatial coordinates into a CSV file containing addresses using ArcGIS Online

Summary

With only an ArcGIS Online subscription and without access to ArcGIS Desktop, coordinates of x-y data can be incorporated the into a CSV file of addresses. The instructions provided describe how to do this.

Procedure

There are two methods to append spatial coordinates into a CSV file containing addresses using ArcGIS Online. Either use the Export Data function or use the Extract Data function.

  • Using the Export Data function
  1. Log in to ArcGIS.com.
  2. Go to My Content, click Add Item to add the CSV file. For more information refer to the following link: ArcGIS Online Help: Add files from your computer
  3. Upload a CSV file containing addresses to a web map in ArcGIS Online.
  4. In the Item from my computer dialog box, ensure that the Title and Tags fields are filled out, select the desired geocoder and country, and click ADD ITEM.
    The added CSV layer appears as a hosted feature layer.
Item2
  1. In the item details page, there are two ways to export the file to a CSV file.
    1. Via the Layers section
      1. Export Data > Export to CSV file.
      2. In the Export to CSV file dialog, fill in the details and click Export.
      3. In the item details page, click Download.
User-added image
 
  1. By clicking Export Data
    1. Layers > Export To > Export to CSV file.
    2. In the Export to CSV file dialog, fill in the details and click Export.
    3. In the item details page, click Download.
    4. Open the downloaded CSV file. The X and Y fields are added.
Test1
  • Using the Extract Data function
  1. Log in to Arcgis.com.
  2. Repeat steps 2, 3, and 4 of the previous procedure to add the .CSV file to ArcGIS Online.
  3. In the item details page, hover the cursor over the thumbnail and click Open in Map Viewer.
  4. In the map viewer page, click Analysis > Manage Data > Extract Data.
  5. Select the desired file in the Layers to extract box.
  6. Ensure that the output data format and output file name are saved in the desired account, and click RUN ANALYSIS.
    The data extracted is available in My Content.
  7. Navigate to My Content, and select the desired CSV file.
  8. In the item details page, click Download.
  9. Open the downloaded CSV file. The Long and Lat fields are added.
Test2

Related Information