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.
-
Select the "Bulk upload" button on a given collection page
-
Download the Excel template, then open the file and start adding your assets
-
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
-
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.
-
Select the relevant country code (see the reference table below).
-
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
-
-
Upload the file
-
Add assets
-
If any error occurs, please use the downloadable report to resolve any conflict.
-
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 |