|SR28 - 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"
Note: The Access database and both Abbreviated (ASCII and Excel) files have been updated with the May 2016 revisions. If you are using the ASCII file for the full version you will need to download the update file for the May 2016 revision (SR28upd0516.zip)
ASCII (6.0Mb) - This file contains the SR28 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 (17.6Mb) - This file contains the SR28 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 SR28, 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.2Mb; 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 SR27 and SR28.
- ASCII (1.1Mb; ISO/IEC 8859-1) - delimited file suitable for import into many programs.