1.1 Import Data into Excel

Step-by-step guide.

• Excel 2016 or newer
• Network access to Gateway server

1. Data → Get Data → From Other Sources → From OData Feed
2. Enter URL: http://server:5000/odata/demo
3. Click OK
4. Select table (e.g., Customers)
5. Click Load

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

• Right-click on table → Refresh
• Or: Data → Refresh All