Brightest
  • 👋Welcome to Brightest
  • Overview
    • 💡Brightest 101
    • 🔅New Client Onboarding Sequence
    • ✨Key Brightest Capabilities
  • Fundamentals
    • đŸ› ī¸Getting set up
      • 👩‍đŸ’ŧGetting Started for Brightest Admins
      • 📝User Permissions
      • 📨Inviting Team Members
        • 🔑Two-Factor Authentication
      • đŸ–ŧī¸Organization Settings
        • đŸ“ļESG and Sustainability Settings
      • 🔓Single Sign-on (SSO)
        • đŸ‡Ģ🇲Microsoft SSO
        • đŸ‡Ģ🇲Okta SSO
    • 📋Navigating Brightest
  • Product Guides
    • 📊KPIs and Custom Metrics
      • â„šī¸Creating a KPI
      • â„šī¸Linking KPIs to Global licenses
      • đŸ—‚ī¸Organizing your KPIs
        • KPIs & Global licenses
      • đŸ’ģEntering KPI data
    • đŸŽ¯Goals and Targets
      • â›ŗSetting Goals
      • Uploading Data to Goals
      • 📉Setting Environmental or Climate Related Targets
      • 📊Materiality (single)
    • âš–ī¸Double Materiality
      • 🌐Double Materiality in Brightest
    • 🌎CSR & Impact
    • ⚡Actions
    • đŸ“ĨSurveys
      • 📑How to make a survey
        • Survey form features
    • đŸ‘ĨPartners
    • đŸĸAssets
      • đŸ—ī¸Bulk Asset Creation
    • â˜ī¸Carbon Accounting
      • đŸŒĨī¸How Carbon Accounting Works in Brightest
      • ➗Emissions Factors
      • 👩‍đŸ”ŦConfiguring and Customizing Emissions Factors
      • 1ī¸âƒŖScope 1 GHG
      • 2ī¸âƒŖScope 2 GHG
      • 3ī¸âƒŖScope 3 GHG
    • đŸŒŋCollecting and Importing Sustainability Data
      • đŸ‘ŖUploading Asset Footprint Data
        • Using the Add Tool
          • Adding Water Data
          • Adding Fuel Data
          • Adding Waste Data
        • Uploading CSV Files
        • Uploading Utility Invoices
      • 🚛Uploading Transit Data
      • 💱Financial Transaction (Spend) Data
        • 💸Spend Capabilities
      • đŸ›ī¸Product and Materials Data
    • 🚩Tags
    • 📝ESG & Sustainability Reporting
      • ESG Reporting Standards & Frameworks in Brightest
  • Use Cases
    • 🏭GHG Emissions Measurement
    • đŸ–Ĩī¸Brightest for IT Teams
  • Roadmap
    • 🔆Our Product Roadmap
  • FAQs and Support
    • ❓FAQs
    • 📧Contact Us
Powered by GitBook
On this page
  • CSV Importer
  • CSV template for uploading data for multiple assets
  • Metric Units
  • Uploading Waste Data
  • Uploading Water Data
  • Uploading Fuel Data
  • Uploading Refrigerant Data
  • Possible issues and troubleshooting
  1. Product Guides
  2. Collecting and Importing Sustainability Data
  3. Uploading Asset Footprint Data

Uploading CSV Files

Asset Footprint Data Upload

PreviousAdding Waste DataNextUploading Utility Invoices

Last updated 1 month ago

Within Brightest, you have three options for uploading sustainability data via spreadsheet (.csv) file:

  • You can upload data to create one or multiple assets (example: uploading a list of real estate leases, fleet vehicles, or investments)

  • You can upload footprint data for multiple assets in bulk

  • You can upload footprint data for a single asset

CSV Importer

To import bulk sustainability data for multiple assets in Brightest, use the csv file importer.

  1. First, navigate to your Sustainability Module and Assets tab.

  2. Click on the gray "CSV import" button at the top right side of your asset library.

  3. Select "Upload Asset Footprint Data". This will open the csv importer.

  4. Download the csv file template and fill it out with your data.

Similar to other Brightest upload imports, you can access an upload template of the fields that should be included in your .csv, as well as guidance on which metrics are accepted. If you're uploading waste data, we also provide a downloadable reference on accepted waste types.

CSV template for uploading data for multiple assets

To upload data to multiple assets, include the following fields (columns) in your .csv file:

Field
Required
Description

Asset Name

Yes

The name of your asset (ex: Brightest NYC HQ Office)

UUID

Yes

Universally Unique Identifier (UUID). If you don't know your asset's uuid, click the asset's name in your "Assets" table, and navigate to the bottom of the page. For simplicity, feel free to customize the Asset uuid and make it the same as your Asset Name value.

Metric

Yes

The type of data you are uploading. Enter one of the following: Electricity, Fuel, Heating, Materials, Refrigeration, Time, Waste, Waste Container, Water, Transport

Metric Unit

Yes

Amount

Yes

A number representing the amount of the metric you are uploading, without any commas for larger numbers (ex: "1000" if you're uploading a row for 1,000 kWh of electricity)

Year

Yes

The year you are uploading data for (Enter the start date of the data entry if using custom date ranges)

Yes

The month you are uploading data for (Enter the end date of the data entry if using custom date ranges)

Waste type

No, optional by default, unless importing waste data

Waste disposal type

No, optional by default, unless importing waste data

Water type

No, optional by default, unless importing water data

Water use type

No, optional by default, unless importing water data

Refrigerant Type

No, optional by default, unless importing refrigerant data

Fuel Type

No, optional by default, unless importing fuel data


Metric Units

The first important thing to confirm and enter correctly in your .csv file are the type(s) of data you're importing - specifically, which metric.

When we say "Metric", we mean environmental metrics like electricity, waste, or water.

A "Metric unit" is the unit of measurement for that metric. For example, in kWh of electricity, kWh is the metric unit, and electricity in the metric.

By default, Brightest supports uploads and measurement for the following metrics and units:

Carbon Units

Metric
Metric unit
Comment

Carbon

mtCO2e

Metric tonnes of greenhouse gas emissions (GHG) in carbon equivalents

Electricity Units

Metric
Metric unit
Comment

Electricity

kWh

kilowatt hours

Electricity

MWh

megawatt hours

Electricity

GJ

gigajoules

Electricity

Therm

Electricity

mmBtu

one million British thermal units

Heating Units

Metric
Metric unit
Description

Heating

Gallon

Heating

mmBtu

one million British thermal units

Heating

GJ

gigajoules

Heating

Liter

Heating

kWh

kilowatt hours

Heating

MWh

megawatt hours

Heating

Therm

Heating

ft^3

cubic feet

Heating

m^3

cubic meter

Heating

y^3

cubic yard

Heating

Barrel

Heating

HCF

one hundred cubic feet (CCF)

Heating

MCF

one thousand cubic feet

Water Units

Metric
Metric unit
Description

Water

Gallon

Water

Liter

Water

Barrel

Water

m^3

cubic meter

Water

y^3

cubic yard

Water

ft^3

cubic feet

Water

HCF

one hundred cubic feet (CCF)

Water

MCF

one thousand cubic feet

Waste Units

Metric
Metric unit
Comment

Waste

g

gram

Waste

kg

kilogram

Waste

lb

U.S. or imperial pound

Waste

Ton

U.S. ton

Waste

MT

metric ton

Waste

Gallon

Waste

Litre

Waste

Barrel

Waste

m^3

cubic meters

Waste

y^3

cubic yards

Waste

ft^3

cubic feet

Waste

HFC

one hundred cubic feet

Waste

MCF

one thousand cubic feet

Fuel Units

Metric
Metric unit
Description

Fuel

Gallon

Fuel

Liter

Fuel

Barrel

Fuel

m^3

cubic meter

Fuel

y^3

cubic yard

Fuel

ft^3

cubic feet

Fuel

HCF

one hundred cubic feet (CCF)

Fuel

MCF

one thousand cubic feet

Refrigeration Units

Metric
Metric unit
Description

Refrigeration

lb

U.S. or imperial pounds

Refrigeration

g

gram

Refrigeration

kg

kilogram

Refrigeration

Ton

U.S. tons

Refrigeration

MT

metric ton

Materials Unit

Metric
Metric unit
Description

Materials

unit

Please be aware metrics may be case sensitive. If you need to import data for other metrics or units not included in this list, please contact Brightest support (support@brightest.io) for assistance.

When you upload your data, please make sure the correct "Metric" value is in the "Metric" column, and the correct, corresponding "Metric unit" value is in the "Metric unit" column.

Be careful to avoid any typos, and type, enter, or paste the metric and metric unit exactly as it's documented.

For example, if you're importing water data in liters, make sure to use "liters" plural with an 's' at the end, not "liter".


Uploading Waste Data

If you're uploading waste data, you need to include the waste type in the "Waste type" field and the disposal method in the "Waste disposal type" field.

Supported Waste Types in Brightest
  • Aggregates

  • Construction (average or mixed)

  • Asbestos

  • Asphalt

  • Bricks

  • Compost

  • Concrete

  • Insulation

  • Soils

  • Mineral Oil

  • Plasterboard

  • Tires I Tyres

  • Wood

  • Books

  • Glass

  • Clothing

  • Textile

  • Household residual waste

  • Landfill

  • Food

  • Organic: food and drink waste

  • Organic: garden waste

  • Organic: mixed food and garden waste

  • Commercial and industrial waste (average or mixed)

  • Industrial materials

  • Medical

  • Metal

  • Metal: aluminium cans and foil (excl. forming)

  • Metal: mixed cans

  • Metal: scrap metal

  • Metal: steel cans

  • Recycling

  • Wastewater

  • Hazardous

  • Electronics (WEEE) - fridges and freezers

  • Electronics (WEEE) - large

  • Electronics (WEEE) - mixed

  • Electronics (WEEE) - small

  • Electronics (WEEE)

  • Batteries

  • Other

  • PMD

  • Plastics: average plastics

  • Plastics: average plastic film

  • Plastics: average plastic rigid

  • Plastics: HDPE (incl. forming)

  • Plastics: LDPE and LLDPE (incl. forming)

  • Plastics: PET (incl. forming)

  • Plastics: PP (incl. forming)

  • Plastics: PS (incl. forming)

  • Plastic (PVC)

  • Plastics: PVC (incl. forming)

  • Paper

  • Paper and board: board

  • Paper and board: mixed

  • Paper and board: paper

Supported Waste Disposal Types in Brightest
  • Reuse

  • Resale

  • Open-Loop (Recycling) - Recycling materials into other products

  • Closed-Loop (Recycling) - Recycling materials into the same products

  • Combustion

  • Waste-to-Energy

  • Composting

  • Landfill

  • Recycling (General or mixed)

  • Anaerobic Digestion


Uploading Water Data

If you're uploading water data, you need to include the water type in the "Water type" field and the water use type in the "Water use type" field.

Supported Water Types in Brightest
  • Cooling water - 3rd party wastewater

  • Cooling water - 3rd party wastewater

  • Cooling water - Evaporated

  • Cooling water - Groundwater

  • Cooling water - Municipal

  • Cooling water - Rainwater

  • Cooling water - Surface water

  • Cooling water - Water treatment

  • Hazardous waste cooling water - Other

  • Hazardous waste non-industrial - Other

  • Hazardous waste other - Other

  • Hazardous waste process water - Other

  • Leakage cooling water - Other

  • Leakage non-industrial - Other

  • Leakage other water consumption - Other

  • Leakage process water - Other

  • Non-industrial - Evaporated

  • Non-industrial - Water treatment

  • Non-industrial (kitchen, toilets, tap water) - 3rd party waste water

  • Non-industrial (kitchen, toilets, tap water) - Groundwater

  • Non-industrial (kitchen, toilets, tap water) - Municipal

  • Non-industrial (kitchen, toilets, tap water) - Rainwater

  • Non-industrial (kitchen, toilets, tap water) - Surface water

  • Other (sprinkler) - 3rd party wastewater

  • Other (sprinkler) - Evaporated

  • Other (sprinkler) - Groundwater

  • Other (sprinkler) - Municipal

  • Other (sprinkler) - Rainwater

  • Other (sprinkler) - Surface water

  • Other (sprinkler) - Water treatment

  • Process water - 3rd party wastewater

  • Process water - Evaporated

  • Process water - Groundwater

  • Process water - Municipal

  • Process water - Rainwater

  • Process water - Surface water

  • Process water - Water treatment

Supported Water Use Types in Brightest
  • Consumption

  • Effluent, treatment, and wastewater

  • Other

  • Withdrawal and use


Uploading Fuel Data

If you're uploading fuel data, you need to include the fuel type in the "Fuel Type" field. Currently, Brightest supports the following fuel types:

  • Gasoline (vehicle)

  • Diesel

  • Biodiesel

  • Biofuel (plant-based)

  • Biogas

  • Propane

  • Coal

  • Combined heat and power

  • Electricity

  • Natural Gas

  • Welding gas - Carbon Dioxide

  • Jet Fuel

  • LNG

  • LPG

  • Marine fuel

  • Oil (petroleum)

  • Solar Thermal

  • Water, water heating, or hydroelectric

  • Other


Uploading Refrigerant Data

If you're uploading refrigerant data, you need to include the refrigerant type in the "Refrigerant Type" field. Currently, Brightest supports the following refrigerant types:

  • R-516A

  • HFC-32

  • HFC-134a

  • R-404A

  • R-407A

  • R-407C

  • R-410A

  • R-454A

  • R-454B

  • R-454C

  • R-455A

  • R-457A

  • R-134A


Possible issues and troubleshooting

When you're importing data via .csv file, it's important to check that your data is clean and accurate before uploading. Because it's a .csv (comma separated value) file, make sure there aren't any extra commas in your fields that might be mistaken as a field divider.

Make sure that your metric and metric unit are entered into your file correctly, and that the units you are using are supported. If you receive an error message, be sure to double check your file. However, just because you see a red error message or don't receive the "Upload Successful" message, it doesn't always mean your upload wasn't successful.

Always be sure to first check your asset footprint pages to see if your data uploaded correctly even if you receive an error, or if for any reason you believe your data may not have been uploaded successfully. Double check whether data has been uploaded and saved to your account after you click "save" or "import" before you attempt saving again. There may be a slight delay in data upload due to internet speed or data volume. Above all, please make sure you don't import the same data twice as this can cause duplicates.

If you are uploading large amounts of data (100+ rows), upon selecting "Save" after reviewing your data in the importer, you will receive a message that your import is processing. You will then be sent an email notification when the process is complete (5-15 minutes).

If your import was uploaded, you'll receive a message indicating that your import was successful.

If your file was unable to uploaded, you'll receive a message indicating the rows of your file that have errors. You can then correct your file and upload again.

Finally, take care to manage the size of your file. Always test an upload with a small file first, before attempting to import a larger file.

If you have any additional issues or questions, please contact Brightest support (support@brightest.io) for assistance.

The unit that your data is using. For example, kWh (for electricity), Gallons (for water or fuel), Therm (for heating) etc.) .

(This will be "Start date" if using )

Month (This will be "End date" if using )

Leave this field blank unless you're importing waste data, in which case please refer to the supported waste types and include a value for the waste type(s) being imported

Leave this field blank unless you're importing waste data, in which case please refer to the supported waste disposal types and include a value for the waste disposal type(s) being imported

Leave this field blank unless you're importing water data, in which case please refer to the supported water types and include a value for the water type(s) being imported

Leave this field blank unless you're importing water data, in which case please refer to the supported water use types and include a value for the water use type(s) being imported

Leave this field blank unless you're importing refrigerant data, in which case please refer to the supported refrigerant types and include a value for the refrigerant type(s) being imported

Leave this field blank unless you're importing fuel data, in which case please refer to the supported fuel types and include a value for the fuel type(s) being imported

Back to the

đŸŒŋ
đŸ‘Ŗ
top of the page
Back to top of the page
Back to top of the page
Back to top of the page
Back to top of the page
Back to top of the page
Check the unit options for your metric below
below
below
below
below
below
below
custom date ranges
custom date ranges
To use the csv file importer click on the "csv import" import button and select "Upload Footprint Data".
If you already have your data formatted, drag and drop your file into the csv importer. Or download the csv file template to enter your data in the correct format for upload.