|SR27 - Download Files|
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"
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.
Since the release of SR27 in August 2014, we have identified a number of foods and nutrient values which were either in need of updating or not calculated properly.
A file containing the update files (sr27_upd052915.zip) is available for the ASCII version of the database. It contains: CHG_FOOD.txt, ADD_NUTR.txt, CHG_NUTR.txt, DEL_NUTR.txt, and CHG_ABBR.txt.
Users who have updated or plan to import the database into their applications will need use this update file to update the appropriate files. The changes included in the May 2015 update for SR27 will be included in the update files disseminated with SR28.
ASCII (1.1Mb; ISO/IEC 8859-1) - delimited file suitable for importing into many programs. To update the file for the May 2015 revisions, you will need to download the update file described above.
Excel (2.9Mb) - for use with Microsoft Excel (2007 or later), but can also be used by many other spreadsheet programs. This file has been updated with the May 2015 revisions.