Skip to main content
California Department of Education Logo

Special Instructions for Excel & Access Users

Instructions on how to download and use student, school, and staff data files in excel and access.

Instructions for opening a text file in Access

  1. Save file as TXT type (with Western European (Windows) encoding if applicable).
  2. Open Access.
  3. Click on the File menu and select the option to Open.
  4. Change the files of type to text.
  5. Navigate to where you saved the file and select the file and click on the Open button.
  6. When the Link Text Wizard window opens, do the following:
    1. Choose the Delimited option and click Next.
    2. Select Tab delimiter type.
    3. Check the box indicating the First row contains field names, then click on Next.
    4. Set field options per corresponding file structure (available online where you downloaded the file) and click Next.
    5. Name the table and click Finish.

Instructions on how to create an Access database and import a DBF file

  1. Save the file to your computer.
  2. Close the "Download Complete" Window after the file is finished downloading.
  3. Open Access: Click on the Start button, select Programs, Microsoft Office, then click on Microsoft Access.
  4. Once in Access, select File, New.
  5. Select blank database. The "File New Database" window will appear.
  6. Select Desktop (or directory where you saved the .dbf file) in the "Save in" box at the top of the window.
  7. Type Public Schools (or whatever name you want) in the "File name" box at the bottom of the window and select Create.
  8. Select File, Get External Data, Import.
  9. Select Desktop in the "Look in" box at the top of the Import window and in the "Files of Type" box, select dbase IV (*.dbf).
  10. Select the file you want and click on Import.
  11. You should see the Microsoft Office Access message, "Successfully Imported."
  12. Select OK, and then Close the Import Window.
  13. In the Access Window, double click on the table to open it.

Instructions on how to open a DBF file in Excel

  1. Save the file to your computer.
  2. Close the "Download Complete" Window after the file is finished downloading.
  3. Open Excel.
  4. Select File, Open.
  5. In the "Look In" drop down box, select the desktop or directory in which you saved the file and in the Files of Type drop down box, select: All Files (*.*).
  6. Double click on the file name.
  7. The .dbf file will now open in Excel.

Questions: Data Reporting Office | | 916-327-0219 
Last Reviewed: Monday, September 24, 2018
Recently Posted in Demographics
  • Transitional Kindergarten Data (updated 17-May-2019)
    Downloadable data files for school-level transitional kindergarten program participation data racial/ethnic designation and subgroup (i.e., gender, English learner, migrant, and socio-economically disadvantaged status).