About the Cube Spreadsheet Add-On

Work with your Cube data directly in Microsoft Excel or Google Sheets using the Cube Spreadsheet Add-on. Fetch the latest data and Publish new data to analyze later or share with others. If you haven’t already, install the Cube Add-On.

The Add-On has several features that allow you to act efficiently, confidently, and consistently. Let's take a look at each in greater detail:

• Build ranges to collect and publish data with quickness
• Analyze your data to ensure your data pulls properly
• Publish your data back to your single source system, aka your Cube
• Settings customize your Add-On configuration to look and behave how you'd like

Build

Use the Build area to configure a Cube data range that defines what data is Fetched or Published with Cube. 

• Select: If the columns and rows for your data are already laid out in your spreadsheet, use Select to configure a new Range easily. 
• New: Starting from a blank spreadsheet, use New to configure a new Range using the drag-and-drop Range builder. 
• Open: To access a Template or Report already saved in Cube, use Open to select it from your Cube Library.

Analyze

Use the Analyze area to learn more about your data. 

• Drilldown: See the transactions for the data cross-section (cell) selected in the spreadsheet
• Validate: Identify column or row names that do not match Cube Dimensions and may cause Fetch errors

Publish

Use the Publish area to add new data, update existing data, or share data in Cube using the data in your spreadsheet.

• Publish Data: Update your scenario(s) by publishing new data to Cube
• Publish Templates: Save your range to Cube and share it with other users
• Set attributes: Add additional context to the data you’re publishing by including attributes, non-Cube Dimension data

Cube Settings

From your Cube top bar, you can manage and view the following:

• Settings: open the portal, visit our help center, submit feedback, customize your settings, and see what's going on in the backend of Cube.
• Mini Audit Trail: See the most recent changes and Fetches in Cube and access the full Audit Trail.
• Change Cubes: If you have multiple Cubes, change from one to another.
• Currency: Change the currency you're working in and manage rates(only available for select plans).

Additional Resources:

• Update the Add-On
• Add Multiple Ranges to One Sheet
• Fetch to Multiple Ranges
• Customize the Add-On
• Import Data to Cube

Have ideas for making the Add-On work even better for you? Tell our Product team!