ESG data-Datastream

Answered By: IESE Library

Last Updated: Feb 24, 2026 Views: 3327

Datastream provides access to ESG company-level data on more than 10,000 public companies worldwide. For an overview of the content look here

How to access ESG data via the Datastream Excel Add-in:

Open Excel. Open the Datastream tab on the Workspace add-in menu and select Datastream Formula.

In the Formula Builder search window, select Find Series

The Datastream Navigator window will appear. Search in the search box or choose Advanced Search, then input your search criteria (such as the name of a company). You can also use the Refine Search Options.

In the results screen, check the box beside the companies you wish to select, then click the Use link.

You will be returned to the Formula Builder search window. Notice that the mnemonic codes for the companies you selected now appear.

Now, select the Search Datatypes icon.

The Datatype Search window will appear. Select Data Category= Equities. Select the icon “Explorer Tree View”, to see all the ESG datatypes available within the different categories.

Then choose from the ESG categories (Corporate Governance, Social, Environmental, Economic etc.). Check the box beside the variables you wish to select, and then click the Use link.

You will be returned to the Formula Builder search window. Notice that the mnemonic codes for the variables you selected now appear. Select the dates and frequency of your data. Select Options for displaying your data. Then click the Insert button.

Your data will now appear in the Excel spreadsheet. Note that coverage varies depending on the companies and variables you have selected. Some variables are not available for all years for all companies.

- Search example: Find companies with ESG Data.

If you want to localize the companies with ESG data, use the constituent lists.
Select Find Series. The Datastream Navigator window will appear.

At the top of the left column, next to Refine Search click Clear All.
Under Categories, click Constituent Lists.
In the search box, enter LSEG SFI and press Search.

Click on the hyperlinked Symbol to add it to the Series/List field.

Then, choose the datatypes you wish, the dates and frequency and Submit.

In this example:
Find Series: LA4CTYES (Spanish listed companies with ESG data)
Datatypes: ENERDP018 (Emission Reduction Target Year); ENERDP091 (Environmental Expenditures)
Date: remember to define the date range and choose Yearly as Frequency.

Then click the Insert button. Your data will now appear in the Excel spreadsheet.

- Support resources: Go to the help (?) icon in the top right corner and see the options.

LSEG offers a series of training videos and material to take you from the basics of Datastream up to advanced projects. Go to Get Training to access them.