...

1. 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.
2. Delete unneeded columns:
   1. 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.
   2. Delete the copy of Total Population.
   3. Delete all columns after Total Population: Hispanic or Latino.
   4. 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
3. Delete Delete Row 2 with “SE_T055_001”
   
   
   
4. Click File > Save As. Select the BringingCensusData folder.
5. Under ‘Save as type:’ select the top option, ‘Excel Workbook (*.xlsx)’. Click Save.
   

Geographic Features

A Shapefile is a digital vector storage format for storing geometric location and associated attribute information.

...