Page Banner

United States Department of Agriculture

Agricultural Research Service

SR27 - Download Files
headline bar

All files are compressed using PKZip, you can view the compressed file and extract the contents using Windows Explorer on your PC. 

Documentation for the database is available here as a PDF file or in each of the download files listed below. PDF files can be read using the Acrobat reader which is available free. To install a PDF viewer in your web browser read, "Steps to Downloading the Free Acrobat Reader"

Full version

  • ASCII (6.4Mb) - This file contains the SR27 data in ASCII (ISO/IEC 8859-1), delimited files. These tables are organized in a relational format, and are best used with a relational database management system (RDBMS), which will allow you to form your own queries of the database and generate custom reports.

  • ACCESS (15.6Mb) - This file contains the SR27 data imported into a Microsoft Access (2007 or later) database. It includes relationships between files and a few sample queries and reports.

  • Abbreviated - This file contains data for all food items in SR27, but not all nutrient values--starch, fluoride, betaine, vitamin D2 and D3, added vitamin E, added vitamin B12, alcohol, caffeine, theobromine, phytosterols, individual amino acids, individual fatty acids, or individual sugars are not included.  These data are presented per 100 grams, edible portion.  Up to two household measures are also provided, allowing the user to calculate the values per household measure, if desired.

    • ASCII (1.1Mb; ISO/IEC 8859-1) - delimited file suitable for importing into many programs.

    • Excel (2.9Mb) - for use with Microsoft Excel (2007 or later), but can also be used by many other spreadsheet programs. 

Update Files - Contains updates for those users who have loaded Release 26 into their own programs and wish to do their own updates. These files contain the updates between SR26 and SR27. 

  • ASCII (1.0Mb; ISO/IEC 8859-1) - delimited file suitable for import into many programs

Last Modified: 2/23/2015
Footer Content Back to Top of Page