====== 1.1 Import Data into Excel ====== Step-by-step guide. ===== Prerequisites ===== * Excel 2016 or newer * Network access to Gateway server ===== Instructions ===== - **Data** -> **Get Data** -> **From Other Sources** -> **From OData Feed** - Enter URL: ''http://server:5000/odata/demo'' - Click **OK** - Select table (e.g., ''Customers'') - 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: **Data** -> **Refresh All**