CSV Materiality Import

To upload custom materiality topics and perform a bulk import of materiality assessment data, please follow the instructions below to complete the templates and proceed with the import process.

On this page:

CSV template fields for importing custom materiality topics

How to import materiality topics

CSV template fields for importing materiality assessment information

How to import materiality assessment information


CSV template fields for importing custom materiality topics

To upload custom materiality topics, include the following fields (columns) in your .csv file:

Field (Column)
Required
Description

Name

Yes

Enter the name of your custom topic.

This will appear in the "Sub Topic" column of the Materiality Table.

Description

No

Enter a description of your custom topic.

This will be visible by hovering over the icon next to the name in the "Sub Topic" column.

Theme

Yes

Enter the ESG theme that relates to your custom topic.

Enter one of the following:

  • Environmental

  • Social

  • Governance

Topic

Yes

Enter one of Brightest's available topic options.

See available options in the list below.

Brightest Materiality Topics
  • Strategy & Business Model

  • Materiality

  • Climate Change

  • Pollution

  • Water & Marine Ecosystems

  • Biodiversity & Nature

  • Sustainable Buildings & Cities

  • Sustainable Agriculture & Food Systems

  • Circular Economy & Waste

  • Employees & Own Workforce

  • Value Chain

  • Community Impact

  • Public Health & Wellness

  • Business Conduct

  • Risk Management

  • Responsible Investing & Sustainable Finance

  • Consumers, Customers & End-Users

  • Product Design & Innovation

  • Product Quality & Safety

  • Animal Welfare

  • Data Security & Privacy

Return to the top of the page


How to import materiality topics

After completing your import template as instructed above,

  1. Navigate to the Materiality Module.

  2. Click the "CSV Import" button and select the "Materiality Topics" option.

  3. In the topics importer, select or drag & drop your completed .csv file

  4. Review the column mapping for Name, Description (optional), Theme, and Topic.

It is recommended to upload topics and assessment data separately. Please ignore the other "Assessment" fields that you will see in the mapping area.

  1. Click "Next," to review a preview of your data import.

  2. Click "Save" to upload your custom topics.

Once your custom topics have been imported. You can now follow the directions outlined below to upload materiality assessment information, or click the "Evaluate" button in the platform to assess each topic individually.

When uploading topics, only the fields: Name, Description (optional), Theme, and Topic should be in the file. Please ignore the "Assessment" fields that you'll see in the mapping area.

Return to the top of the page


CSV template for importing materiality assessment information

To bulk upload materiality assessment information, include the following fields (columns) in your .csv file:

Field (Column)
Required
Description

Topic

Yes

Enter the Name or "Sub Topic" that is listed in the Materiality table.

Name

No

The Name is the same as the "Topic." You can leave this field blank.

Definition

No

Material

No (but highly recommended)

Enter "TRUE" if the topic is material. Enter "FALSE" if the topic is not material.

Scope

Yes

The geographic or operational scope or boundary of the material impact(s), risk(s) or opportunities.

Enter one of Brightest's available scope (geographic region) options.

See available options in the list below.

Time horizon

Yes

The time horizon of the material impact(s).

Enter one of the following:

  • "None or N/A"

  • "Short-term" = 0-1 years

  • "Mid-term" = 1-5 years,

  • "Long-term" = 5+ years

Impact potential

Yes

The potential status of the material impact(s).

Enter one of the following:

  • Actual = the impact has or is already occurring

  • Potential = the impact is expected or likely to occur in the future

  • None or N/A = the impact is not expected to occur or is not material

Impact scope

Yes

How widespread is the impact, risk or opportunity?

Enter one of the following:

  • Very High

  • High

  • Medium

  • Low

  • Minimal

  • None or N/A

Impact likelihood

Yes

How likely is the impact, risk or opportunity to occur?

Enter one of the following:

  • Very Likely

  • Likely

  • Possible

  • Unlikely

  • Very Unlikely

  • None or N/A

Risk level

Yes

Scale of Impact, Risk or Opportunity. How significant is the impact, risk or opportunity on people and/or the environment?

Enter one of the following:

  • Very High

  • High

  • Medium

  • Low

  • Minimal

  • None or N/A

Risk mitigation potential

Yes

Your organization's ability to address or mitigate any negative material impact(s) or risks.

Enter one of the following:

  • Very high = very easy to mitigate or achieve

  • High

  • Medium

  • Low

  • Minimal

  • None or N/A = cannot be mitigated or achieved

Materiality importance

No

The impact materiality importance or score for this topic to your organization.

Enter a number between 1 and 10 (1 = lowest, 10 = highest)

Materiality stakeholder importance

No

The importance of this topic to your organization's stakeholders, including employees, investors, suppliers, customers, etc. (1-10 scale).

Enter a number between 1 and 10 (1 = lowest, 10 = highest)

Materiality influence

No

Your organization's ability or capacity to positively influence or address this material topic (1-10 scale).

Enter a number between 1 and 10 (1 = lowest, 10 = highest)

Financial value

No

The financial value or impact of this material topic in your account's default reporting currency.

Enter the financial value (i.e. 2000000). Please only enter positive values.

Financial likelihood

Yes

How likely is this financial impact, risk or opportunity?

Enter one of the following:

  • Very Likely

  • Likely

  • Possible

  • Unlikely

  • Very Unlikely

  • None or N/A

Financial value category

No

The primary category of this topic's material financial impact(s).

Enter one of Brightest's available financial value category options.

See available options in the list below.

Financial value score method

No

Which financial value scoring method are you using?

Enter one of the following options:

  • Financial value

  • Financial value * likelihood

  • Financial value * likelihood adjusted for mitigation potential

Explanation

No (but highly recommended if the topic is considered "not material")

How and/or why you determined this topic or IRO (impact, risk or opportunity) is or is not material. It's recommended to use EFRAG's key materiality concepts and terminology for this assessment statement, such as likelihood, severity, mitigation potential, and/or time horizon (i.e., low likelihood, low severity, easy to mitigate).

Document

No

Enter a link to supporting documentation.

Scope (Geographic or Operational Boundary) Options in Brightest

Regional

Global

Local

Company or Entity-wide

Division, Brand or Business Unit

Asset or Investment

Strategic

Financial

Operational

Legal & Compliance

Brand & Reputation

Investor

Value Chain

None or N/A

Financial Value Category Options in Brightest

Asset Value

Brand or Reputation Opportunity

Brand or Reputation Risk

CAPEX

Cost Reduction Opportunity

Innovation Budget

Investment or Portfolio Appreciation

Investment or Portfolio Risk

Operating Cost Increase or Risk

Other Risk or Opportunity

Regulatory or Legal Risk

Revenue Opportunity

Revenue Risk

Supply Chain or Sourcing Opportunity

Supply Chain or Sourcing Risk

Return to the top of the page


How to import materiality assessment information

After completing your import template as instructed above,

  1. Navigate to the Materiality Module

  2. Click the "CSV Import" button and select the "Materiality Assessment Data" option.

  3. In the assessment importer, select or drag & drop your completed .csv file

  4. Review the column mapping and click "Next"

  5. Review a preview of your data import

  6. Click "Save" to upload your materiality assessment data

Return to the top of the page

Last updated