Organization Tree Reports

Two types of organization tree reports are available for download.

  1. Manually-Produced Excel Reports

    Manually-produced Excel files are available for download, one showing the entire Organization Tree for Business Unit 10000 and the other for Business Unit J0000. These files are updated monthly. They are not separated by Control Units. To find a specific department or unit within the file, type Ctrl+F and search by keywords.

    Note: Because these Excel files are manually produced, the Excel data may not match information in the production database due to possible data entry errors. Please report any discrepancies to chartfield@berkeley.edu.

  2. Production-Based Tree Reports

    Tree reports are generated weekly from the production database and are available by selecting one of the links below. Reports are based on data which is current as of the run date. A report can be run for the entire Organization tree with links to the individual units. Separate tree reports are also available for each Control Unit. To find a specific department within any of the reports, type Ctrl+F and search by keywords.

    Report HTML Page Text File
    (semicolon-delimited for download to Excel)
    Master Organization Tree HTML Text
    Chancellor's Office HTML Text
    VC Administration & Finance HTML Text
    VC Equity & Inclusion HTML Text
    VC Facilities Services HTML Text
    VC University Relations HTML Text
    VC Research HTML Text
    VC Student Affairs HTML Text
    Executive VC and Provost HTML Text
    College of Letters & Science HTML Text
    Associate VC Information Systems & Technology HTML Text
    Central Campus Operations HTML Text
    UC Office of the President HTML Text

    To Convert Text Files to Excel Format

    1. Open Excel. From the Excel File menu, select Open…
    2. In the Open dialogue box, click on the drop-down list for Files of type and select Text Files. Navigate to the text file and open it. The Text Import Wizard will open.
    3. Choose Delimited instead of Fixed Width. Click Next.
    4. Uncheck the Tab delimiter. Check Semicolon as the Delimiter. Click Next.
    5. Choose Text as the Column Data Format. Click Finish.
    6. Choose Save As from the File menu. Select Save as type from the drop-down menu and choose Excel Workbook.

Back to Chart of Accounts Structure