...
- In the Analysis tab, select the Tools button. In the Find Tools search bar in the Geoprocessing pane, type ‘Excel to Table.’SelectExcel To Table (Conversion Tools).
- For the ‘Input Excel File’, click the Browse button and navigate to your BringingCensusData folder. Single-click on the SocialExplorerDownload.xlsx and clickOpen.
- For the ‘Output Table’, rename it ‘SocialExplorerDownload.’ Make sure your window looks like the window below and selectRun.
Fix Tables
Append data from your table to your geography.
- Right-click the Shapefile and selectAttribute Table. Take note of the field which contains the unique identifier on which your join will be based. In this case the field is GEOID10. Hover over the GEOID10column header and notice that the Type of the field is Text.
- In the Contents pane, right-clickSocialExplorerDownload and selectOpen. Notice the name of the field that matches the shapefile’s field. In this table, it is named FIPS. Hover over the FIPS title and notice that the Type of the field is Double. This is not compatible with the Text field of the shapefile.
- In the Contents pane, right-click the SocialExplorerDownload table and selectDesign > Fields.
- Scroll to the bottom of the fields list and click on the ‘Click here to add a new field.’
- For the Field Name, type in FIPS_Text. Change the Data Type to Text. In the Data tab, click the Save button.
- In the Contents pane, right-click the SocialExplorerDownload table and select Open. Scroll all the way to the right. Right-click on the FIPS_Text header and selectCalculate Field.
- In the Geoprocessing pane, under the Fields menu, double-clickFIPS. Notice that the smart code reads ‘FIPS_Text = !FIPS!’. When your window looks like the window below, select Run.
