How do I download, install, and use the Mac version?

This article describes how to install and use Exponam.Connect on a Mac with Excel installed as an application on the Mac.  If you use Excel within a web browser, please see this article instead.

Mac Exponam.Connect

The macOS version of Exponam.Connect isdesigned to work within the capability set available on the macOS version of Excel.  The macOS version is a great tool for accessing smaller data sets; however, power users who routinely work with large amounts of data are encouraged to use Exponam.Connect Pro on a PC.  Data import speeds are much faster on the PC platform – a 1.1 million row file is imported on a PC in 12 seconds, whereas it takes 8 minutes on a Mac.

Mac Exponam.Connect Utility Product Installation

1. Download the Mac installer for Exponam.Connect Utility by clicking this link.

2. Double click the installer.pkg file that is downloaded to your machine.

3. Step through the installation screens.  When asked, allow the installer to proceed.  Close the installer and move the installation file to the trash. 

4. Start the Exponam.Connect Utility.  From Launchpad or Finder->Applications start ExponamConnectUtility.  The Utility application will need to be running for Exponam.Connect to work inside Excel.

5. Set the Utility application to start up on login.  Right-click the Utility icon in the mac dock.  Select Options -> Open at Login. 

Alternately, you can manually add it to login items via system settings as shown.

Exponam.Connect Configuration on Mac

1. Start Excel on your Mac.  From the Home toolstrip, you will see an Add-ins Icon.  Click the icon.  

2. The "Exponam" menu will appear in the toolstrip.  

3. If the "Exponam" item ever does not show in the toolstrip (when restarting Excel), repeat this step of selecting the Add-in.

Using Exponam.Connect on Mac (or in Browser)

1. Click the Exponam menu in the toolstrip and then select "Import Data" from the toolstrip options.  

2. Excel's task pane will appear from the right side of the screen.  Resize the task pane by dragging the pane divider to the left.

3. Click "Add Sample Data" to add Databricks' sample data set.  To add your datasets, click the (+) button.  Select your .share files, provided by your Databricks administrator.

4. Ongoing Use:

- A:  Click the share in the Connections pane to expand the navigation tree.  Click a table to generate a preview of the data. 

- B:  VIEWS & FILTERS:  Click the three lines on a column header to enter a filter for the column.  Save a filter view by clicking the three triangular lines in the grid heading.  Access a saved view by selecting it in the dropdown list in the header.  Remove a saved view using the crossed-out triangular line control.  Move columns to different positions by dragging the column headers.

- C: Click the license object to enter or check your Exponam.Connect license.  For more detail, see this license key article.

- Use the controls at the bottom of the pane to choose import location and characteristics and to Import to Excel.