U.S. Census Bureau
Tutorials

Learn more about the features and functions of American FactFinder

Skip left-hand navigation

Tutorial 9: Bookmark and Download

You must have the Adobe Flash Player plug-in offsite link icon installed to play this video.

Video transcript »

Skip video and media player

The Camtasia Studio video content presented here requires JavaScript to be enabled and the latest version of the Adobe Flash Player. If you are using a browser with JavaScript disabled please enable it now. Otherwise, please update your version of the free Adobe Flash Player by downloading here.

Video Transcript:

  • Welcome to the American FactFinder Bookmark and Download Tutorial.
  • In this tutorial, we will demonstrate how to bookmark and download a table in American FactFinder. After viewing this tutorial, you will be able to:
    • Bookmark a Table,
    • Download a Table,
    • Save a Query and
    • Restore a Query.
  • Let's begin with the Sex by Age Detailed Table, T06, from the 2008 Population Estimates.
  • Notice the two functions on the Actions bar: Bookmark and Download. We will use these functions to bookmark, download, and save your table.
  • First, let's look at Bookmarking. Bookmarking allows you to save a website address within your web browser so it can be retrieved for future use.
  • For this demonstration, click Bookmark.
  • A message displays with the following options:
    • Create a Bookmark or
    • Save Query.
  • Click Create Bookmark.
  • A dialog box displays requesting the name of your bookmark and folder location.
  • Note that the dialog box may vary depending on the web browser you are using.
  • Next, click Add.
  • The bookmark is added to your browser's bookmark list.
  • Now, let's learn about American FactFinder's download capability.
  • This feature enables you to download your table in Database-compatible format or in Presentation-ready format.
  • Database-compatible files (CSV or XLS) contain data rows only and can be manipulated with most database or spreadsheet software.
  • Presentation-ready files (XLS or PDF) include titles, head notes and footnotes which can be easily incorporated into reports and presentations.
  • In this tutorial, we will download the table in a Database-compatible format.
  • Click Download.
  • Next, select the Comma delimited radio button and click OK.
  • A Save File dialog box displays allowing you to open or save the file. Note this may vary depending on the web browser you are using.
  • Click Open, then click OK.
  • A compressed file opens containing a:
    • Readme file,
    • CSV data file,
    • Text file containing the table title, head notes, and footnotes and
    • An annotation file with cell notes and substituted values (when applicable).
  • Now, let's look at American FactFinder's Save and Restore Query functions.
  • Save Query allows you to save your table or map and also saves table and map modifications for future use on American FactFinder.
  • The Save Query option will be the only option available if the table is too complex to be bookmarked or if the table has been modified.
  • Click Bookmark then click Save Query.
  • A Save File dialog box displays allowing you to save the file.
  • Select the Save File radio button and click OK.
  • The query is saved to your computer.
  • To retrieve a saved query from the American FactFinder Main Page, click Main on the navigation bar.
  • Next, click the Load Query button.
  • A Pop-up window displays allowing you to restore the saved table.
  • Click Browse to search for the saved file.
  • Once the file is located, click OK.
  • The restored table displays.
  • This concludes the Bookmark and Download Tutorial.
  • In this tutorial, you learned how to:
    • Bookmark a Table,
    • Download a Table,
    • Save a Query and
    • Restore a Query.
  • For more information, visit American FactFinder at factfinder2.census.gov.