1.1 Import Data into Excel

Step-by-step guide.

Prerequisites

  • Excel 2016 or newer
  • Network access to Gateway server

Instructions

  1. DataGet DataFrom Other SourcesFrom OData Feed
  2. Click OK
  3. Select table (e.g., Customers)
  4. Click Load

Result

The data appears as a table in Excel and can be refreshed at any time.

Refresh Data

  • Right-click on table → Refresh
  • Or: DataRefresh All
Zuletzt geändert: on 2026/01/29 at 11:22 PM