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
See Citing Information on the
Terms of Use 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 form.
