Add additional countries to your current worksheet
This article describes how you can add more countries to your current Excel worksheet using the Excel Data Workstation.
- Navigate to the Excel Data Workstation tab on your Microsoft Excel application
- Select "Edit Script"
- You will now see the script used to grab your specified data.
- To add more counties, you need to specify the country in the highlighted below.
- For example, get @level from db.[WDMacro as Global Economics] where Location in DZA, AGO, BHR,ITA,AGO,CMR and Indicator in CPI, GC, GCSA and Year from 2019 to 2028 with Frequency = 'Annual'
Select the "Replace Current Worksheet" option and Run. This will now add the countries you have added in your script into your worksheet.
We recommend using the latest Excel Data Workstation version, found here for the best experience.