OrgChart Now Help Guide

Table of Contents

Excel Connector Setup

Audience

Audience: Administrators

Overview

This article provides step-by-step instructions on how to configure an Excel Connector as a Main Data Source.

Important

Important: Your file must be properly formatted to load into OCN. Read the Flat File Prep article for details on preparing for file before loading into OrgChart Now.

Note

Note: Excel is also available as an Append and Merge Connector. Reference the Append Data Connector and Merge Data Connector articles for more information.

Setting Up an Excel Connector

  1. Log in to OrgChart.

  2. Click More > Chart Settings.The Source panel will be displayed.

  3. Click on the Connector icon under the Main Data Source heading, and then select Excel from the panel.

  4. Click on the Browse button (under Main Data Source heading). The File Manager is displayed.

    Screen_Shot_2020-10-17_at_8_50_15_PM.png
  5. Click on the folder which houses the excel file you'd like to open (i.e. Samples).

  6. Optionally, upload your own Excel file by clicking on the Screen_Shot_2020-10-17_at_8_53_37_PM.png button. Find and select the file located on your local computer, and then click on OK.

  7. Click to highlight your file, and then click Select to import the file to OrgChart.

  8. Click the Configure Mapping button.

  9. Click the Load button (at the bottom of the mapped fields). If your source file contains the required fields, OrgChart will automate the field mapping. Reference the Excel Connector article for more information on required fields.

  10. Click Save, and then Refresh.