How do I create assets using the bulk upload feature?

A step-by-step guide to using our bulk upload tool

How to create assets using bulk upload

Besides adding assets one by one, you can also add multiple assets into a collection using an Excel file.

  1. Select the "Bulk upload" button on a given collection page

    bulk-upload-button
  2. Download the Excel template, then open the file and start adding your assets

    bulk-upload-excel-template

     

    1. Each tab includes an asset and financing type (e.g. Private Equity, Private Debt, CRE Equity, etc.). Learn more about asset types and how to select them

    2. Select GICS and EEIO via the dropdown. If you are unsure what to select, leave it blank, but it is required for calculation. Learn more about GICS and EEIO and how to select the correct sector.

    3. Select the relevant country code (see the reference table below).

    4. Columns include validation if the fields require a number, text or percentage. Learn more about how to achieve a PCAF data quality score for each asset type

  3. Upload the file

    bulk-upload-upload

    bulk-upload-select

  4. Add assets

    bulk-upload-add
    1. If any error occurs, please use the downloadable report to resolve any conflict.

    2. If any duplicates are found, you can merge assets or exclude them from the upload,

Once assets are uploaded, you can use them in other collections without needing to add identifying information.

 

EEIO country and region code mapping

 

Australia

AU

Austria

AT

Belgium

BE

Brazil

BR

Bulgaria

BG

Canada

CA

China

CN

Croatia

HR

Cyprus

CY

Czech Republic

CZ

Denmark

DK

Estonia

EE

Finland

FI

France

FR

Germany

DE

Greece

GR

Hungary

HU

India

IN

Indonesia

ID

Ireland

IE

Italy

IT

Japan

JP

Latvia

LV

Lithuania

LT

Luxembourg

LU

Malta

MT

Mexico

MX

Netherlands

NL

Norway

NO

Poland

PL

Portugal

PT

Romania

RO

RoW Africa

WF

RoW America

WL

RoW Asia and Pacific

WA

RoW Europe

WE

RoW Middle East

WM

Russia

RU

Slovakia

SK

Slovenia

SI

South Africa

ZA

South Korea

KR

Spain

ES

Sweden

SE

Switzerland

CH

Taiwan

TW

Turkey

TR

United Kingdom

GB

United States

US