Drag and drop an Excel file

Contents[Hide]

1. Overview

This article shows you how to display data from a Microsoft Excel file using simple drag-and-drop operations in Dundas BI.

Related video: Using Excel as a Data Source

2. Drag an Excel file to the EXPLORE window

For this example, create a new dashboard from the main menu, and use the blank dashboard template.

Locate your Excel file in Windows Explorer.

Drag the Excel file from Windows Explorer and drop it over the EXPLORE window in Dundas BI.

Drag Excel file to EXPLORE window (Chrome browser)
Drag Excel file to EXPLORE window (Chrome browser)

The Excel file is automatically imported into Dundas BI as a data connector.

Expand the Data Connectors folder in the EXPLORE window to see the auto-generated data connector which corresponds to the Excel file. You can further expand the data connector to see the column structure of the Excel sheet.

Auto-generated data connector for Excel file
Auto-generated data connector for Excel file

Drag the Excel sheet from the EXPLORE window to the dashboard canvas. A table visualization appears which displays the contents of the Excel sheet.

Drag the Excel sheet to the dashboard canvas
Drag the Excel sheet to the dashboard canvas

3. Drag an Excel file directly to the canvas

Optionally, you can drag an Excel file from Windows Explorer and drop it directly onto the dashboard canvas (in Edit mode) instead of the EXPLORE window. The Excel file will also be added as a data connector automatically, and a corresponding table visualization will appear on the canvas.

4. Remove a column from the table

Right-click over the table visualization. From the menu, select Data Binding Panel.

In the Data Binding panel, remove the 'x' column by clicking the delete icon to its right.

Remove column
Remove column

5. Replace date column with time hierarchy level

Expand the Time Dimensions folder in the EXPLORE window.

Expand the default time dimension and also its first hierarchy.

Drag the 'Month' level of the hierarchy, hover over the table visualization, and then drop it onto the existing 'date' column in the ROWS field of the Data Binding panel.

Replace date column with Month level
Replace date column with Month level

The table visualization is updated automatically to show month names in the 'date' column.

Table showing month names
Table showing month names

6. Re-visualize as a bar chart

Finally, select the table, click Re-Visualize from the toolbar, and then click Bar. The table is now displayed as a bar chart with month names along the X axis.

Re-visualize as a bar chart
Re-visualize as a bar chart

7. Notes

Dragging and dropping a file to the application will upload the file.

  • Changes to the original file will not affect the generated data connector. To refresh the data based on the changes made in the original file, specify a UNC path in the data connector settings. See Connecting to Excel for more information on connecting to an Excel file.
  • An uploaded file will be automatically warehoused after the first use to improve performance.

8. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri