Importing CSV file (Georeferenced with Google Earth) into ArcMap?

Question

I had a CSV file that I just georeferenced using Google Earth's import feature. The CSV file contains information about businesses in the United States, such as the business' name, address, and description.

After georeferencing the data in Google Earth, Google Earth displays several points on the globe. When I click on each point, a pop up window appears that displays all of the information for the business in that location, such as the business' name, description, etc.

I would like to add that data into ArcMap, so that I have a shapefile that includes all of the attribute data in the CSV file. I right clicked on the folder that contains all of the point data in Google Earth, clicked "Save Place As". After doing so, Google earth created a .kmz file.

How do I import that .kmz file into ArcMap? When I tried to import the data using the conversion tools menu in ArcToolbox, the points all appeared in the correct locations, but the points weren't associated with any of the data in the CSV file (e.g. the business names and descriptions).

What am I doing wrong? I used Google Earth to georeference the data because it's free.

Answer 1

You may add csv data to arcmap as table and then join it to shapefile you created out of the kmz if getting attribute data remains the issue. You should have a common field in shp and csv to do this.

To perform table join right click your shp in table of contents and select join. Select the csv table you added and the common field in both tables.