The Datarails add-in brings your Datarails data into Excel, so you can build reports with live numbers, analyze what is behind them, and share the result. This article shows where everything is and links to the guide for each feature. With the add-in you can:
- Build reports that update themselves. Pull live data into your own layouts with formulas, ready-made reports and data tables.
- Understand any number. Drill from a total down to the transactions behind it without leaving the sheet.
- Share with confidence. Send a clean copy to people outside Datarails, or publish a range to a dashboard that stays current.
- Spend less time on upkeep. Let reports add new accounts and roll forecasts forward for you.
Open the add-in
- Install the add-in. See the installation guide.
- Open a workbook in Excel.
- On the Home tab of the Excel ribbon, click Datarails Add-in.
The add-in opens in a task pane on the right side of the Excel window. You can leave it open beside your sheet as you work, or close and reopen it whenever you like.
How the task pane is organized
The task pane follows the way you work: stay in sync, build and analyze, then share and maintain. The home screen has two tabs:
- Build & analyze: Your daily work: getting data into the sheet and drilling into it.
- Management: Sharing what you have built, and advanced setup such as dynamic ranges and planning.
Top bar: stay in sync with Datarails
The top bar is always visible, because these are the actions you need on every report: making sure you are looking at current data, saving your work back, and choosing which slice and period you see.
| Control | What it does | More info |
|---|---|---|
| Connect | Links a local Excel file to a Filebox in Datarails. Once the file is connected, the button becomes Submit. | Connect, submit and refresh |
| Submit | Sends your changes from Excel to Datarails. | Connect, submit and refresh |
| Refresh | Updates the workbook with the latest data from Datarails. | Connect, submit and refresh |
| Filters | Slices every Datarails object in the workbook by a field, such as department or entity. | Filters |
| Set Date | Sets the reference date (formerly Date Picker), which moves the reporting period of your reports. | Connect, submit and refresh |
| Info (the "i" icon) | Shows the Filebox name, its tags, and a banner if you are not on the latest version of the file. It appears once the file is connected. | |
| Additional options (the three dots) | Opens Account, Settings, Help and troubleshooting tools. |
Errors and notifications: know when a number needs attention
The top of the home screen tells you about problems as they happen. Click a notification to go straight to where you can fix it.
| Notification | What it means |
|---|---|
| File errors | The add-in found problems inside the file. Opens the File errors screen, which lists each one. |
| Integrations errors | One of your integrations failed to sync. |
| Unmapped items | Items in your data could not be mapped, so they are not included in your numbers. Opens a window where you can map them without leaving Excel. |
Build & analyze: create reports and understand the numbers
This tab is where most of your time goes. Get data gives you three ways to bring live data into Excel, from a single cell to a whole report, and Drill down answers "what is in this number?" when someone asks.
| Feature | What it does | More info |
|---|---|---|
| Get data > Formulas | Brings data into cells with Datarails formulas. Build formulas, edit their conditions and manage functions. | Formulas |
| Get data > Report builder | Builds a full report by dragging fields into rows and columns, then brings it into Excel as live formulas. | Report builder |
| Get data > Data tables | Adds a filtered extract of a Datarails table to your sheet. | Data tables |
| Drill down | Breaks a number down into the records behind it. | Drill down |
Management: share your work and keep it maintaining itself
Once a report is built, this tab helps you get it to the right people in the right form, and set it up so it keeps pace with your data and your planning cycle with little manual upkeep.
| Feature | What it does | More info |
|---|---|---|
| Export | Shares a report as static values, as a PDF, or as one version per filter value. | Export reports |
| Embedded ranges | Publishes a range from your workbook to a Datarails dashboard (formerly Published Ranges). | Embedded ranges |
| Advanced options > Dynamic range | Keeps a report's rows in step with your data, adding new line items and filling formulas down. | Dynamic ranges |
| Advanced options > Planning module | Sets up planning periods and the default formula applied when a forecast rolls forward. | Planning module |
The right-click menu: common actions without the task pane
The actions you repeat most, refreshing and drilling down, are on Excel's right-click menu, so you can stay in the sheet. Items are enabled or greyed out depending on what you have selected.
On Excel for the web, open the task pane once before using the right-click menu, so the menu knows which items to enable.
| Menu item | What it does | Enabled when |
|---|---|---|
| Refresh All | Refreshes every Datarails formula and table in the workbook | Always |
| Refresh Cell | Refreshes the Datarails formula in the selected cell | The cell contains a formula starting with DR., such as DR.GET
|
| Refresh Table | Refreshes the Datarails data table at your selection | Your selection is inside a Datarails data table |
| Edit Table | Opens the table editor for that data table | Your selection is inside a Datarails data table |
| Open Detailed Records | Lists the transactions behind the cell's value | The cell is a numeric Datarails value |
| Drill Down - By Field | Breaks the value down by a field you choose | The cell is a numeric Datarails value |
| Drill Down - Add to Favorites | Saves the current breakdown for reuse | The sheet contains a drill-down pivot table |
Ordinary Excel formulas such as =SUM(...), column headers, empty cells and other Excel tables do not enable the Datarails items.
Known limitation on Windows and Mac desktop: the Datarails menu does not appear when you right-click directly on a data table. Right-click a cell range that overlaps the table instead, or use the task pane. On Excel for the web the menu works on every cell.
Windows, Mac and the web
The add-in is the same on Windows desktop, Mac desktop and Excel for the web. A report built on one opens the same way on the others.
© Datarails Ltd. All rights reserved.
Updated