Data Files
To accommodate multi-user needs, the public school files are posted in three formats; database format, Excel format, and text (tab delimited) format. These files are updated daily, therefore, the indicated file sizes are approximates, as the files may change from day to day.
- pubschls.dbf (DBF; 36MB)
- pubschls.txt (TXT; 7MB)
- pubschls.xls (XLS; 10MB)
For details on modifications to these files and the file structure, refer to the Changes to the Public Schools File Web page.
Special Note: These files contain schools that are currently open, schools that have been closed, and school codes that have been retired. We are including all schools so you can match school names to prior year files. If you have any questions regarding this file, please call 916-327-0219. Please review the file structure for more information.
File Structure
- File Structure - Public Schools Database (Revised 22-Nov-2011)
Defines all the elements included in the downloadable public school files.
Download Instructions
- Special instructions for Excel and Access users (Revised 7-May-2010)
- Special instructions for MAC users
