There are many ways to 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. After reviewing the information below, you can expect to learn about:
Choosing a Download File Type
Download from the Advanced Search page
Download up to 10 tables from the search results page in a comma-delimited format (.csv). This format can be imported into Microsoft Excel, as well as other spreadsheet and database programs.
Download when viewing a table
Download a table from the table view in comma-delimited (.csv), PDF, Microsoft Excel (.xls), or Rich Text Format (.rtf) formats. Downloads can be for either a single table or multiple tables.
Download when viewing a Thematic Map
Download a single map from the map view in PDF, JPEG image (jpg), or Shapefile formats.
Download when using a Reference Map
Download a single map from the Map Tab of the Geography Overlay in PDF, JPEG image (.jpg), or Shapefile formats.
Download prepackaged Census Bureau files that are searchable from within American FactFinder.
Download when using FTP
Download large volumes of data from the Census Bureau's FTP site.
There are limits to the size of tables that can be downloaded in American FactFinder. If American FactFinder's download limits prevent you from downloading the data you need, you may be able to download the complete dataset from the Census Bureau's FTP Site. Visit the Census Bureau's FTP site at https://www2.census.gov/ for a complete list of available files.
Download limits from Advanced Search (without viewing a table)
Download limits from Table Viewer
Tables can be downloaded in:
Note: Your geographies will be on the "Y" axis (i.e. the left side of the table) when downloading in csv format
Limits for .pdf and .rtf
Limits for .xls
Using the "View All as PDF" option, you can download up to 3 tables at one time in a pdf format. The row and column limits are the same as above.
Using the Download button, you can only download the table you are viewing. If the table is too large to download in a presentation-ready format, you will be prompted to download in a database-compatible (.csv) format
Download options are divided into the following categories:
Database Compatible Format (Use the data): Use this download format to download data that can be loaded into a spreadsheet or database for further analysis.
Presentation Ready Formats (View the data): Use these formats to display tables and maps in a format that is easy to read and insert into documents or presentations.
Spatial Data Formats: This advanced download format is used to capture the geographic boundaries associated with the selections made on either a Reference Map or Thematic Map. These files can be loaded into mapping software such as ArcGIS for analysis.
Annotations are cell-level notes or substitute values that represent some special meaning for a table cell. These notes are used to show revised counts to data, provide information on why data is unavailable, etc.
The 'include descriptive data element names' checkbox allows you to toggle between one or two header rows at the top of database compatible files. By default, the 'include descriptive data element names' is checked, and your table will download with two header rows, one with identifiers and the other with descriptive data element names. If the 'include descriptive data element names is unchecked, then the system will download one header row with column identifiers.
The following Table Manipulations will not be represented in database compatible downloads: Rearranging Rows & Columns, Transposing Rows & Columns, and Sorting Columns.
A separate Metadata Auxiliary File is included in each download. It contains identifiers and descriptive data element names in a two-column transposed format. This file is used when analyzing data in specialized tools such as SAS and SPSS to give descriptive titles to columns in the csv data file.
Presentation Ready Formats:
PDF: 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: The JPEG file type is a format for compressing images. In American FactFinder, download images of maps in JPEG to place an image in a document or other applications.
RTF: The RTF file type is a document file format that can be read by any word processing program (i.e. Microsoft Word). These files can be viewed, printed, and electronically transmitted. In American FactFinder, the download limit is up to 5,000 rows in RTF.
XLS: 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.
Spatial Data Formats:
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. For more information and help working with shapefiles, visit the Geography Division's website at https://www.census.gov/geo/maps-data/data/tiger-line.html
Downloading from the Search Results
Downloading from the Table Viewer
Downloading using FTP
Bookmark and Save Query
Loading a Saved Query
Working with Search Results
Refine Search Results
Viewing Data Search Results