Working with Downloaded Data
The download files are generated using the delimiter you have chosen and double quotes for text qualifiers.
When importing into a spreadsheet or database application, numerical data such as ZIP Codes and
CDS Codes may be converted to numbers causing leading zeros to be dropped and changing the
way the information is displayed. To preserve the actual data, manually control the import of the data
into the application instead of relying on the automated processes.
For example, to control the import of data into Microsoft Excel:
Rename the downloaded file using a .TXT extension.
Start Excel and open the file.
Select "Delimited" as the data type then select the delimiter you chose.
Mark the column data type as "Text" for each column except the columns containing counts such as
the number of students.
Looking for other Commission data?
Visit Where to Find Data
for quick links sorted by the type of data.
Want to reproduce a pre-configured data report?
Visit Reproduce Pre-Configured Report
for available instructions.
How to Cite this Information
page for some suggestions.
See something weird?
Known problems and notes about the data are documented on the Caveats
page. Please let us know if you notice something that is not included. Send an e-mail to Data_Quality@cpec.ca.gov
or fill out the Comments