Skip to main content
Skip table of contents

Refreshing Data in Excel Reports

Excel workbooks can download data from DataSelf data warehouse databases.
ETL+ also extracts data from Excel files. Thus, with this framework, data can be both uploaded from and downloaded to, or refresh, Excel files and workbooks.

There are several ways to refresh (download) data into Excel reports within the DataSelf framework:

  1. DataSelf API – new service in beta. Securely bridges your data in DataSelf’s data warehouse and Tableau extracts (Tableau data sources) into Excel workbooks.

  2. Seamless, secure, and centrally managed: Users just press the Refresh icon in Excel desktop reports to see their latest data. Excel reports will pull data directly from the SQL data warehouse or Power BI datasets. SQL or Power BI security controls what data each user has access to. Every user will need their own SQL or Power BI user license. Their secure access to the data might require additional IT setups.
    ⚒️ Work in progress: Click here to learn more.

  3. Seamless, easy, and inexpensive: Users just press the Refresh icon in Excel desktop reports to see their latest data. ETL+ can download report data into CSV files on a schedule, and these files can be used for Excel reporting. This usually requires users access to CSV files on shared network folders. Security can be built around Windows shared folders.

  4. Manual data download: Users can manually download their data from MS SQL data warehouse, Tableau, Power BI, or other reporting tools connected to DataSelf into their Excel Desktop files. For more on this see Excel Reports with Data from Tableau or DataSelf Data Warehouse

  5. DataSelf Automatic Distribution Module: Excel AD is an add-on that can automatically refresh and email Excel reports on a schedule. This approach can also be used to refresh Excel Online reports on a schedule. Excel AD


Excel Desktop and Online: With some additional setup, options 1 to 3 above might support Excel Online reports as well.

Security concerns using Excel: Once the data is loaded into an Excel file, there’s no way to control what a user can do with that Excel file (for instance, accidentally sharing it with the wrong people). Please consider Tableau and Power BI to have a more centralized way to distribute your private data.

Related Pages

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.