...
- Close both AmericanFactFinderDownload.csv and SimplyMapDownload.csv.
For ArcGIS to be able to read your table, it must be formatted appropriately.
- Select Columns A though AB in the SocialExplorerDownload. csv table by clicking on the gray area in the top-left hand corner of the table. Double-click on the line between any two columns to resize the column widths. All cell contents should be visible.
- Delete unneeded columns.
- The identifying fields repeat information that we don’t need. Delete Area Name-Legal/Statistical Area Description, Qualifying Name, Summary Level, Geographic Component, State (FIPS), County, County Size Code, County Subdivision, and Census Tract. Be sure to keep FIPS.
- Delete the copy of Total Population.
- Delete all columns after Total Population: Hispanic or Latino.
- Rename the field names with the following criteria: Remove all spaces and special characters, must begin with a letter, fewer than 64 characters. Keeps FIPS as it is. TotalPop. NonHispanic. White.etc