🏗️Bulk Asset Creation

To import and create multiple new assets in Brightest via a .csv file upload, visit the "Assets" tab in the Sustainability section of your Brightest dashboard, and navigate to Import → Upload Assets.

Asset Upload

There, you can download our Asset Import CSV Template.

1. Fill out your asset data correctly in the file.

2. In the csv importer, use the "Choose File" button to select the file you want to upload, and then click the green "Upload File" button to complete your upload.

3. If your upload is successful, you'll see a green notification and your assets will be visible in the "Assets" tab in the Sustainability section of your Brightest dashboard. If there's an error, you'll receive a notification your upload needs to be corrected.

The import template includes the following fields by default:

• name: the name of your asset (ex: Brightest NYC HQ Office) (required)

• uuid: a unique ID for your asset that can be made of any unique combination of numbers, letters, or characters (optional)

• description: a description of your asset (optional)

• asset_type: a number that represents the type of asset you are importing (required)

• asset_type options (by asset_type id):

  • 1 = Office

  • 2 = Site, Factory, or Facility

  • 3 = Vehicle or Transportation Asset

  • 4 = Equipment

  • 5 = Raw Materials

  • 6 = Energy Asset

  • 7 = Agricultural or Food Asset

  • 8 = Investment

  • 9 = Miscellaneous Asset

  • 10 = Purchased Goods and Services

  • 11 = Capital Goods

  • 12 = Fuel and Energy-Related Activities

  • 13 = Upstream Transportation and Distribution

  • 14 = Waste Generated in Operations

  • 15 = Business Travel

  • 16 = Employee Commuting

  • 17 = Upstream Leased Asset

  • 18 = Downstream Transportation and Distribution

  • 19 = Processing of Sold Products

  • 20 = Use of Sold Products

  • 21 = End of Lifecycle Products

  • 22 = Downstream Leased Asset

  • 23 = Franchise

  • 24 = Carbon Offset

• owned: enter "True" if the asset is owned by your organization of "False" if the asset is leased or under third party control. Note: In Excel and Google Sheets, "True" may be auto-converted to "TRUE" and "False" may be auto-converted to "FALSE." To prevent this, insert a " ' " single quote character in front of the word, like "'True" or "'False" to prevent the auto-conversion (required)

• real_estate_status: an optional number field if your asset is an office, building, or other type of real estate asset (optional)

• real_estate_status options:

  • 1 = Your organization built and owns the asset

  • 2 = Your organization built the asset, then sold it

  • 3 = Another organization or entity built the asset, then your organization purchased it at some point in its lifecycle

  • 4 = Your organization leases the asset

  • 5 = Your organization used to lease the asset, but the lease is now terminated

• acquired_date: the date your organization acquired or started leasing the asset. Please format like: 2023-01-20 (for January 20, 2023)

• workers: the number of employees or workers who work at or with the asset (optional)

• space: the gross floor area of the asset. The unit for this value will be based on your organization's default measurement system, typically square feet if you use the imperial system, or square meters if you use the metric system (optional)

• location_type: a number representing where the asset is located if it has a specific geographic boundary (optional)

• location_type options:

  • 1 = Remote

  • 2 = Rural or Agricultural Region

  • 3 = Suburb

  • 4 = Urban

  • 5 = Downtown / City Center

• clean_power_electricity: enter "True" if the asset is has on-site clean or renewable electricity (ex: solar PV, wind, water, etc.) of "False" if the asset does not. Note: In Excel and Google Sheets, "True" may be auto-converted to "TRUE" and "False" may be auto-converted to "FALSE." To prevent this, insert a " ' " single quote character in front of the word, like "'True" or "'False" to prevent the auto-conversion (optional)

• clean_power_heating: enter "True" if the asset is has on-site clean or renewable heating (ex: solar hot water heater, geothermal, etc.) of "False" if the asset does not (optional)

• clean_power_water: enter "True" if the asset is has on-site, natural water consumption (without a municipal or other water source) or closed-loop or circular water re-use, of "False" if the asset does not (optional)

• clean_power: enter a number between 0 - 100 to represent the percentage of clean or renewable energy powering your asset relative to its overall energy use. For example, if you have a solar PV installation that generates 50% of your asset's annual electricity, enter "50" in this field. Ignore any net metering arrangements (optional)

• remote_percentage: a number value to represent the percentage of employees at this asset who work remotely. For example, if 15% of your employees work remotely and the other 85% work on-site, enter "15" (optional)

• office_days_per_week: enter a number between 1 - 5 to represent the number of days in your work week. For example, if your office uses a four day work week, enter "4", or "5" for a five day work week (optional)

• location_street: the street address of your asset (optional)

• location_city: the city where your asset is located (optional)

• location_state: the state, region, province, or territory your asset is located in (optional)

• location_country: the country your asset is located in (optional)

• location_zip: the zip code or postal code of your asset (optional)

If you're familiar with GHG Protocol, you'll notice several of the asset types map or correspond to a specific Scope 3 emissions carbon accounting category. This is designed for cases where you need to represent an emissions value in a specific carbon accounting category, such as historical Scope 3 emissions data or other environmental data that falls outside of an operational boundary. In most cases, it's more efficient to use the Brightest "Transit" asset to represent Scope 3 areas like transportation and travel without necessarily creating an asset for it, however we want to give you the flexibility to account for carbon and other sustainability data in the way that makes the most sense for your organization.

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.

If you see an error like "varchar is too long," that means the character count in the field you're uploading exceeds the limits of our database, and you should try to find particularly long fields or names and try to shorten them if possible. However, just because you see a red error message doesn't always mean your upload wasn't successful. Always be sure to first check your assets table to see if your new assets uploaded correctly. If they did, you can likely ignore the error. Above all, make sure you don't import the same assets twice and duplicate your data.

Finally, take care to manage the size of your file. We typically recommend bulk uploading assets 100 or less at a time. Trying to create hundreds or thousands of assets at the same time may run into performance issues. If you need to upload a lot of assets and you're on an Impact, Transform, or Enterprise plan, it's best to speak with your account manager.

If you have any additional issues or questions, please contact Brightest support ([e-mail]) for assistance.