--- title: "Web Portal 2.0: How to run a Macro" description: "Note: This guide explains how to import data into your Macro from your reports. As every Macro relates to a specific GoReport template, ensure you have the correct Master Macro available on your deskt" --- [Skip to content](https://knowledge.goreport.com/knowledge/how-to-run-a-macro#main-content) - New Customer Onboarding Show submenu for New Customer Onboarding - RICS Customers Training - Smart Library Training - Knowledge base - Support Open main navigation Close main navigation - New Customer Onboarding Show submenu for New Customer Onboarding - RICS Customers Training - Smart Library Training - Knowledge base - Support Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Knowledge Base](https://knowledge.goreport.com/knowledge?hsLang=en) 2. [GoReport How To](https://knowledge.goreport.com/knowledge/goreport-how-to?hsLang=en) 3. [Web Portal 2.0](https://knowledge.goreport.com/knowledge/goreport-how-to?hsLang=en#web-portal-2-0) # Web Portal 2.0: How to run a Macro **Note:** This guide explains how to import data into your Macro from your reports. As every Macro relates to a specific GoReport template, ensure you have the correct Master Macro available on your desktop/laptop  computer before you begin the process. #### **Step 1: Create a New Folder and Copy Your Macro** - **Create a new folder** on your computer. Example: *New Folder for Macro*. ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Nov-04-2025-03-42-31-1896-PM.png?width=158&height=164&name=image-png-Nov-04-2025-03-42-31-1896-PM.png) - **Copy your Master Macro** (this should be stored in a separate location on your computer) and paste a copy into the new blank folder you’ve created. 💡 **Tip:** Always work from a *copy* of your Master Macro. Keep the original file unchanged. ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Nov-04-2025-04-47-46-7307-PM.png?width=688&height=219&name=image-png-Nov-04-2025-04-47-46-7307-PM.png) #### **Step 2: Export Data from the GoReport Web Portal** - **Log in** to the GoReport Web Portal and find the report you want to export. Select the report and click the **Publish** button in the side bar. ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Nov-04-2025-04-46-11-6208-PM.png?width=688&height=273&name=image-png-Nov-04-2025-04-46-11-6208-PM.png) - From the Publish screen select **Grouped Excel.** **![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-08-2026-11-20-08-8645-AM.png?width=688&height=384&name=image-png-Jan-08-2026-11-20-08-8645-AM.png)** **Note:** If your Macro is designed to include links to photographs, you can choose which size of photos are included on the export. ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-08-2026-11-21-10-4051-AM.png?width=688&height=384&name=image-png-Jan-08-2026-11-21-10-4051-AM.png) - Click **Export.** **![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-08-2026-11-23-38-7156-AM.png?width=688&height=384&name=image-png-Jan-08-2026-11-23-38-7156-AM.png)** - When the export is ready, click the **Download** button. ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-07-2026-03-05-07-0202-PM.png?width=688&height=379&name=image-png-Jan-07-2026-03-05-07-0202-PM.png) - You can also download the file from the **Recent Activity Tab.** ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-08-2026-09-19-52-9833-AM.png?width=688&height=354&name=image-png-Jan-08-2026-09-19-52-9833-AM.png) ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-08-2026-09-19-38-0114-AM.png?width=688&height=352&name=image-png-Jan-08-2026-09-19-38-0114-AM.png) - Once downloaded, **move a copy of the GoReport exported file or folder** into the same folder you created earlier (the one containing your copied Master Macro). **Important:** The exported data and the copy of your Master Macro must be stored in the **same folder** for the Macro to work correctly. ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-08-2026-10-28-14-6873-AM.png?width=688&height=209&name=image-png-Jan-08-2026-10-28-14-6873-AM.png) **Note:** If your export includes photographs, they will download together in a zipped folder. Unzip the contents and place them into **the new folder created in Step 1**, which contains the copy of your Master Macro. - Both files will be 'blocked' and need to be unblocked before you can use them. **Important:** If you don't unblock the files the macro won't work. - Right click on the file and select **Properties.** ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-13-2026-11-33-10-1463-AM.png?width=1185&height=823&name=image-png-Jan-13-2026-11-33-10-1463-AM.png) - Tick the **Unblock** box as shown below, and click **OK.** **![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-13-2026-11-57-41-2309-AM.png?width=373&height=430&name=image-png-Jan-13-2026-11-57-41-2309-AM.png)** - Repeat this step for both documents in the folder. **![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-13-2026-11-58-10-6830-AM.png?width=982&height=253&name=image-png-Jan-13-2026-11-58-10-6830-AM.png)** **Step 3: Importing Data into the Macro** - Open the copy of the Master Macro you placed into the new folder you created at the start of the process. You might see the following ‘Security Warning’ along the top of the Excel document. Select **Enable Content.** ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-08-2026-10-33-33-0157-AM.png?width=688&height=212&name=image-png-Jan-08-2026-10-33-33-0157-AM.png) -  Select the **GoReport** tab located along the top of the screen. ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-08-2026-10-38-18-4048-AM.png?width=688&height=132&name=image-png-Jan-08-2026-10-38-18-4048-AM.png) - Click **External Data** as shown below. ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-08-2026-10-38-41-6803-AM.png?width=688&height=181&name=image-png-Jan-08-2026-10-38-41-6803-AM.png) - A dialogue box will open for you to select a file. Locate the folder you have created that contains the  copy of your Master Macro and the exported Excel from the GoReport Web Portal. Click the exported Excel and select **‘Open’.** ![](https://knowledge.goreport.com/hs-fs/hubfs/image-png-Jan-08-2026-10-40-10-8969-AM.png?width=688&height=291&name=image-png-Jan-08-2026-10-40-10-8969-AM.png) The excel data will then import into the Macro, causing the Macro to ‘run’. You will then see the data displayed as expected within the Macro. **Tip:** Repeat the above process, if you want to import a new export from the Web Portal **Key Points** 1\. Always copy your Master Macro, so the original remains unchanged. 2\. Make sure you are using the correct Macro for your template. Macros are only designed for individual templates.   **Future Template Changes:** If your Macro is designed for a bespoke template and the bespoke template undergoes structural changes, the Macro might need updated too.    - [Digital Transformation](https://knowledge.goreport.com/knowledge/digital-transformation?hsLang=en) - [Getting Started with GoReport](https://knowledge.goreport.com/knowledge/getting-started-with-goreport?hsLang=en) - [GoReport How To](https://knowledge.goreport.com/knowledge/goreport-how-to?hsLang=en#main-content) - [iOS App](https://knowledge.goreport.com/knowledge/goreport-how-to?hsLang=en#ios-app) - [Web Portal](https://knowledge.goreport.com/knowledge/goreport-how-to?hsLang=en#web-portal) - [Web Portal 2.0](https://knowledge.goreport.com/knowledge/goreport-how-to?hsLang=en#web-portal-2-0) - [Android App](https://knowledge.goreport.com/knowledge/goreport-how-to?hsLang=en#android-app) - [Sava Partnership](https://knowledge.goreport.com/knowledge/sava-partnership?hsLang=en) - [The Future of Surveying](https://knowledge.goreport.com/knowledge/the-future-of-surveying?hsLang=en#main-content) - [RICS Young of Surveyor of the Year](https://knowledge.goreport.com/knowledge/the-future-of-surveying?hsLang=en#rics-young-of-surveyor-of-the-year) - [Digital as part of your Surveying career](https://knowledge.goreport.com/knowledge/the-future-of-surveying?hsLang=en#digital-as-part-of-your-surveying-career) - [Industry support in growing your career](https://knowledge.goreport.com/knowledge/the-future-of-surveying?hsLang=en#industry-support-in-growing-your-career) - [Creator](https://knowledge.goreport.com/knowledge/creator?hsLang=en#main-content) - [GoReport Creator Overview](https://knowledge.goreport.com/knowledge/creator?hsLang=en#goreport-creator-overview) - [GoReport Creator - How To](https://knowledge.goreport.com/knowledge/creator?hsLang=en#goreport-creator-how-to) - [GoReport Creator Examples](https://knowledge.goreport.com/knowledge/creator?hsLang=en#goreport-creator-examples) - [GoReport in Action](https://knowledge.goreport.com/knowledge/goreport-in-action?hsLang=en) - [Contact Us](https://knowledge.goreport.com/knowledge/contact-us?hsLang=en) - [Web Portal 2.0](https://knowledge.goreport.com/knowledge/web-portal-2-0?hsLang=en) - New Customer Onboarding - Knowledge base - Support Copyright © 2026, GoReport