DataboxDatabox Databox
Excel

Excel
Dashboard and Reporting Software

Connect now

Create beautiful interactive dashboards you can share with your team using your Excel data.

  • Behaviour & usage
  • Handling errors
  • Help Articles

metrics

    Show more...

    dashboard templates

      Show more...

      report templates

        Show more...

        • What is the size and cell limitation for Excel?

          For Excel files (via Google Drive) Databox does not enforce file size or number of cells limits. However, Google does have limits in place for their API. Google allows 10 MB file downloads and the files themselves have a 10 million cell limit. An Excel file exceeding either one of those limits will not work in Databox.

          For Excel files (via One Drive), Excel (via Dropbox), and Excel File Upload, Microsoft and Dropbox APIs as well as Databox don’t enforce file and cells limits, such as those mentioned above, so it is possible to use larger files. However, the bigger the file is, the more resources it will take to process all the data from it.

          Therefore, users should be aware that connecting large files can cause issues. Namely, Databox infrastructure enforces limits on how long an action can take in Metric Builder. For example, timeouts can occur if it takes too long to pull data or if too many resources (CPU/RAM) are used to load the file and calculate the metric values.

        • Vertical (columns) and Horizontal (rows) orientation in sheets

          In a spreadsheet, vertical orientation means organizing data into columns, where each column represents a specific category or attribute, and individual entries or records are placed in rows within these columns.
          In horizontal orientation, data is organized across columns, with each column representing a unique entry or category. Specific information within those entries is then arranged vertically, with different rows containing various attributes or details for each entry.

          In Databox:

          • Vertical orientation is required for the Metric Builder Wizard.
          • Horizontal orientation is supported only for manual metric setup (without the Wizard option).
        • Values for cells with #DIV/0 returned as number 7

          Databox requires that the value in a cell is defined as a number and when a cell displays #DIV/0 (divide by zero) error, the value assigned to this in Databox is number 7.

          We advise users to handle division by 0 in their sheet directly. There are multiple ways to do this, here are some examples:
          How to correct a #DIV/0! error
          How to fix the #DIV/0! error

        • Values are incorrectly associated with specific dates

          This issue may occur if dates are not correctly entered in the cells. Dates should be formatted as complete dates, including the day, month, and year, rather than just the month and year or only the month. For detailed guidelines on proper date formatting, refer to the ‘Requirements regarding date formatting’ section in the Behavior & usage tab.

        • Requirements regarding date formatting

          We strongly recommend ensuring that all dates in your spreadsheet are recognized as dates—either automatically, based on locale settings, or manually by applying custom date formats that override locale settings. This approach greatly reduces the likelihood of encountering issues later on.

          If a date string is not recognized by the document, Databox will attempt to validate it against common standards like ISO 8601 and RFC 2822.

          We recommend adopting popular date formats, such as:

          YYYY-MM-DD
          MM/DD/YYYY
          DD/MM/YYYY
          December 4, 2023
          4 December, 2023

          In this help article, you can learn how to check if a date format is properly set for the usage in Databox.

        • Long loading times in Metric Builder

          Workbook files large in size and by number of cells and using additional styles/formatting/images in worksheets can cause longer loading times in the Metric Builder. In such cases, users are advised to:

          – Remove all images from the Excel file that is connected with Databox.
          – Split large Excel files into several smaller files and connect them separately in Databox.
          – Do not include custom formatting in the workbook – this includes customized fonts, bolding, adjusting the alignment, colors, etc.
          – Aggregate values in your Excel worksheet to decrease the file size by following these instructions. You should do this in a new workbook in order to keep an original copy of your data. This can help reduce the file    size of the Excel workbook that you want to connect to Databox.

        • How often does Excel data sync with Databox?

          The frequency of the sync schedule in Databox depends on several factors, including your Databox Plan and account activity. You can find more details in this article.

          Excel custom metrics are updated only when new data is added or existing data is modified within the cells included in the custom metric. Databox checks for changes in your worksheet every hour and syncs the data when updates are detected.

          The data sync relies on the ‘Last saved’ timestamp of your Excel worksheet file. To view this information, go to Saved to OneDrive (or other cloud storage) > Save status > Last saved.
          If your Excel workbook is automatically updated using scripts or similar solutions, the ‘Last saved’ timestamp may not refresh. In such cases, Databox will not detect the new data, and the sync process will not occur. To ensure updates are recognized, make sure the file’s ‘Last saved’ status is properly refreshed.

          If your Excel Data Source is updated automatically, you can trigger a data sync in Databox using one of the following methods:

          1) Manually Update the Excel Worksheet

          • Add a value, such as ‘1,’ to a blank cell in any sheet and update it as needed to initiate a data sync.
          • Ensure that this cell is not used in any of your Excel custom metrics.
          • Making manual changes to your worksheet updates the ‘Last saved’ timestamp in Excel, prompting Databox to include the updated data during the next scheduled sync.

          2) Automate Updates Using Zapier

          • Use Zapier to regularly push data into your Excel workbook (e.g., inserting the current date/time).
          • Schedule this automation to run every hour. Each update will refresh the ‘Last saved’ timestamp, ensuring Databox searches for and syncs new data from your sheets during each scheduled sync.

          These methods help ensure your automated Excel updates are properly detected by Databox.

        • Empty file sheet/tab is displayed in Metric Builder preview

          Check if the sheet/tab contains a Pivot table. Pivot Tables are currently not supported and cannot be synced with Databox, hence they will appear empty in Metric Builder.

        • Duplicated dimensions with the same name appear on datablock

          Sometimes, spreadsheet entries contain extra spaces, which can create duplicates. For example, you might have two dimensions: ‘Closed Won’ (without a space after the ‘n’) and ‘Closed Won ‘ (with a space after the ‘n’). Although they may look identical in Databox, they will appear as two separate dimensions because the system treats spaces as characters, recognizing them as distinct entries.

          Users can use the ‘Find and Replace’ feature in their spreadsheet to correct dimension names. For example, they can replace ‘Closed Won ‘ (with a space) with ‘Closed Won’ (without the space).

        • Could not find desired Excel file in the process of connecting Excel data source to Databox

          Only .xls and .xlsx file formats are supported in the Excel integration in Databox. If your file is in any other format, such as CSV, HTML, or text file, you can save it in .xlsx Excel format (as explained in this Microsoft article) and connect it to Databox.

        • ‘Files shared with me’ section does not show any files in the process of connecting Excel files through OneDrive

          To connect an Excel file in Databox, the individual file must be shared directly with the user connecting the file. Files that were shared with a user on the Folder level (inside Folders) will not be listed in Databox in the process of connecting and cannot be connected in Databox by the shared user.

        • Excel file cannot be connected via OneDrive

          There are two possible causes preventing connection of an Excel file via OneDrive in Databox.

          1) Since the Excel integration in Databox supports OneDrive Personal (‘Basic’) and not OneDrive for Business (associated with Microsoft SharePoint), connecting Excel files that are stored in SharePoint is currently not supported in Databox. It is on Databox’s roadmap to enable connecting Excel files that are stored in SharePoint. You can upvote this improvement on Databox roadmap here.

          2) The Excel integration in Databox supports basic OneDrive available through Microsoft Account. To connect files, the individual file must be shared directly with the user connecting the file. Files that were shared with the user on the Folder level will not be listed in Databox during the connection flow and cannot be connected in Databox by the shared user.

        • ‘This is not a valid A1 notation’ error message in Metric Builder – custom metric can not be previewed and saved

          If the special characters ‘!’ or ‘:’ are used in the worksheet tab name of the Excel file, custom metric can not be saved or viewed because those are characters reserved for A1 notation.

          This can be resolved in two ways:

          1) rename the tab, so that the tab name will not use any of the two characters (!, : ), or

          2) if the data from the same tab is also used in formulas in other tabs or other Excel files, duplicate / replicate the same tab as a new worksheet tab with a different name (one that does not use any of the two characters). Replication can be done by using: =, or Move / copy worksheets or worksheet data.

        Track all of your key business metrics from one screen

        GET STARTED
        Databox app preview