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.
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.
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