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 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. image\ebx_1027725012.gif

    A pop-up window displays indicating the number of products selected for download.
    image\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.


  4. When the system displays "Your file is complete", click Download image\ebx_-1175223489.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.

    image\ebx_1784751837.gif

 


Download a Single Table from the Table View

  1. From the Table Viewer, click the Download button on the Actions toolbar.

image\ebx_780621946.gif

The Download Dialog Window displays.

  1. In the Download Dialog Window, select a format for the downloaded file:

    1. Select Use the data (e.g., in a spreadsheet or database) to download a comma-delimited file (CSV) that can be opened and manipulated in a spreadsheet programs (e.g., Excel), or in most database programs.



      • Check the "Merge data and annotations in a single file" option for a single .csv file containing both data cells and annotations. Annotations are cell-level notes or substitute values that represent some special meaning for a table cell.
      • Check the "Include descriptive element names" option to include an additional row in the CSV file describing the meaning of the data in each column.
    2. Select View the data (e.g., as a presentable document) to download a presentation-ready format (PDF, XLS, or RTF). (Note that the XLS format has table titles, headers, and footers, and is meant for presentation. It is not as easy to manipulate in Excel as the comma-delimited format.)



      If the "View the data" option is selected, choose the orientation for the download (portrait or landscape), and a paper size (8½" x 11" (letter) or 8½" x 14" (legal)).

Note: For more information about file types and formats, See 'Choosing a File Type ' in 'Downloading Overview '

 

  1. Click OK.

    A dialog window displays the progress as American FactFinder builds a file containing the products you selected for download.

    image\ebx_571473500.gif

  2. When American FactFinder displays "Your file is complete", click Download image\ebx_-1175223489.gif

    image\ebx_-1724336773.gif

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

    image\ebx_1784751837.gif

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


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. image\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

    image\ebx_-2016769212.gif

 

  1. 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.


    A dialog box displays.

  2. Select a format to save the file:

 

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
https://www.census.gov/geo/maps-data/data/tiger-cart-boundary.html .

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

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

  3. Click OK.

 

 

Download a Thematic Map

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



    The download dialog box displays.


  2. Select a download format.

 

Presentation-ready:

-- PDF

-- JPEG image (.jpg)

 

Spatial Data:

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

 

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

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

  3. 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