Downloading

Download data, tables, and maps to your computer. American FactFinder offers many download file types depending on the type of information requested, and the location of the request. Click a link below to learn how to:

 

Download Data Product(s) from the Search Results

Download a Single Table from the Table View

Download Multiple Tables from the Table View

Download Prepackaged Products

Download a Reference Map

Download a Thematic Map

Choose a File Type

 

See the Bookmark and Download tutorial for more information

 

Note: In order to download a product you must have already performed a search. To learn how to search for data products, see Searching for Data.

 

 

Download Data Product(s) from the Search Results

Tables downloaded from the search results page are formatted as database-compatible comma-delimited (.csv) files and packaged together in a single zip file.

 

1.    On the Search Results page, select one or more data products using the checkboxes next to the search results. You can download up to 10 products from the search results page.

2.    Click the Download button. images\ebx_1027725012.gif

A pop-up window displays indicating the number of products selected for download.
images\ebx_-606671052.gif

3.    Click OK.

A pop-up window displays the progress as the system builds a zip file containing the products that were selected for download.

images\ebx_571473500.gif

4.    When the system displays “Your file is complete”, click Download images\ebx_-1175223489.gif

images\ebx_-1724336773.gif

5.    The browser then displays a dialog box allowing you to open or save the zip file. This dialog box will vary depending on the Internet browser being used.

images\ebx_1784751837.gif

 


Download a Single Table from the Table View

1.    From the Table View, click the Download button images\ebx_1027725012.gifon the Actions toolbar.

images\ebx_756530682.gif

2.    In the pop-up window, select a format to save the file:

 

Database-compatible formats (data rows only):

 

 Comma delimited (.csv) – Data and annotations in a single file

 Comma delimited (.csv) – Data and annotations in separate files

 

Click the ‘include data element names’ checkbox images\ebx_-645485451.gif to include a header row for descriptive data element labels within the database compatible file. See ‘Preparing Database Compatible Files ’ below for more details.

Annotations are cell-level notes or substitute values that represent some special meaning for a table cell.

If a database-compatible format is chosen, all manipulations made to the table will not be represented in the downloaded file.

 

Presentation-ready formats:

 PDF (PDF is only available for tables with fewer than 5,000 rows.)

 Microsoft Excel (.xls)

 Rich Text Format (.rtf)

 

3.    If a presentation-ready format is selected, select the orientation for the download (portrait or landscape), and a paper size (8½” x 11” (letter) or 8½” x 14” (legal)).

4.    Click OK.


Download Multiple Tables from the Table View

You can create a PDF version containing one to three of your selected tables and maps. To unselect data products, click back to search results and unselect the respective checkboxes.

1.    Click the View All as PDF button. images\ebx_1531296278.gif

2.    A single PDF version of the selected products displays. Print the PDF or save the PDF to your computer.

 

Downloading Prepackaged Products

1.    From the Product View page, click the Product hyperlink at the bottom of Results page

images\ebx_-2016769212.gif

 

2.    Follow the instructions provided by your Internet browser to open or save the file.

 

Download a Reference Map

1.    Click the Download icon on the Reference Map toolbar.

images\ebx_1349482444.gif
A dialog box displays.

2.    Select a format to save the file:

images\ebx_-1552415743.gif

 

Presentation-ready formats:

 PDF

 JPEG image (.jpg)

Spatial Data:

 Shapefiles (.zip) – Geospatial data for the geographies listed in the “Selection Results” section of the Map tab. For more information and help working with shapefiles, visit the Geography Division’s website at http://www.census.gov/geo/www/tiger/wwtl/wwtl.html .

3.    For PDF format, select a paper orientation and paper size.

4.    Add an optional title using the Map Title box. A map title can be up to 50 characters long.

5.    Click OK.

 

 

Download a Thematic Map

1.    Click the Download button on the Actions Toolbar of the Thematic Map view.

images\ebx_-549978481.gif

The download dialog box displays.

images\ebx_18942787.gif

2.    Select a download format.

 

Database-compatible formats for the tabular data used to create the thematic map:

 Comma delimited (.csv) – Data and annotations in a single file

 Comma delimited (.csv) – Data and annotations in separate files

Click the ‘include data element names’ checkbox images\ebx_-645485451.gif to include a header row for descriptive data element labels within the database compatible file. See ‘Preparing Database Compatible Files ’ below for more details.

 

Presentation-ready:

 PDF

 JPEG image (.jpg)

 Rich Text Format (.rtf))

 

Spatial Data:

 Shapefiles (.zip) – Spatial data for the geographies being thematically mapped

 

3.    For PDF format, select a paper orientation and paper size.

4.    Add an optional title using the Map Title box. A map title can be up to 50 characters long.

5.    Click OK.

 

 

 

Choose a File Type

 

CSV - Database Compatible

The CSV file type is a file format that stores tabular data. In American FactFinder, CSV is available in two different styles. The first style, “data and annotations in a single file,” displays a single .csv file containing both data cells and annotations. This CSV style is better for viewing and manipulating the data in Excel. This file can be opened using Excel, or another database tool once the header lines have been compressed into a single row.

The second style, “data and annotations in separate files,” displays two .csv files, one containing only data cells, and the other containing only annotations. This CSV style is better for input into database programs such as SAS. This file can be opened using Excel, or another database tool once the header lines have been compressed into a single row.

 

PDF - Presentation

The PDF file type is a file format that provides an electronic image of text or text and graphics that looks like a printed document and can be viewed, printed, and electronically transmitted. In American FactFinder, the download limit is up to 5,000 rows in PDF.

 

JPEG - Presentation

The JPEG file type is a format for compressing images. In American FactFinder, download images of tables and maps in JPEG to place an image in a document or other applications.

 

XLS - Presentation

The XLS file type is the common file format associated with Microsoft Excel. In American FactFinder, download a print-friendly view of a table or map to maintain the visual formatting of the data product in XLS.

 

Shapefiles - Mapping Files

The ESRI shapefile or simply a shapefile is a popular geospatial vector data format for geographic information systems software. It is developed and regulated by ESRI. In American FactFinder, download shapefiles to import into external mapping programs.

 

 

Preparing Database Compatible Files

American FactFinder allows users to input database compatible files into database programs (i.e. ArcGIS, SaS) easier.

 

Include descriptive data element names

The ‘include descriptive data element names’ checkbox allows the user to toggle between one or two header rows at the top of database compatible files. By default, the ‘include descriptive data element names’ is unchecked, and your data product will download with a single header row for identifiers (ids). If the ‘include descriptive data element names is checked, then the system will download two header rows; one with identifiers and the other with descriptive data element names.

 

Metadata auxiliary file

The downloaded zip file includes a separate metadata file with identifiers and descriptive data element names in a two-column transposed format.

 

 

See Also

Bookmark and Save Query

Loading a Saved Query

Working with Search Results

Refine Search Results

Navigating Results

Printing

Viewing Data