...

1. Click BringingCensusData.zip above to download the tutorial data.
2. Open the Downloads folder.
3. Right-click BringingCensusData.zip and select Extract All....
4. In the 'Extract Compressed (Zipped) Folders' window, accept the default location into the Downloads folder and click Extract.
5. Drag the unzipped BringingCensusData folder onto your Desktop.
6. Close all windows.

...

Tabular Data

Explore Data

The folder you downloaded contains an unprocessed data table that appear as it would if you downloaded it directly from the web site.

1. Open the Excel document titled AmericanFactFinderDownload.csv.

This data would require a lot of reformatting. The many layers of headers must be condensed because ArcGIS can only read one header row containing field names. There are several identifying columns containing duplicate information, but only the second column presents the ID in a way we want to use.

1. Open SimplyMapDownload.csv.

This data is nearly ready to use. A few of the field names need updating to include only alphanumeric characters and underscores (# and spaces, for example, are not allowed). The column widths also need to be resized to display all the cell contents.

1. Open SocialExplorerDownload.csv.

This data is not ready to use, but it does not require extensive reformatting. We will use this table as an example.

1. Close both AmericanFactFinderDownload.csv and SimplyMapDownload.csv.