Skip to main content

Excel file structure

The import file (.xlsx) has one sheet per data type. This page lists the columns of each sheet, their format and, above all, how the sheets link together, which is where most errors occur.

Always use a recently exported file
The exported file is marked with the current version of the structure. When the structure evolves, the version changes and a file from an earlier version is no longer accepted on import. Do not reuse old files: always export the file from the platform before each update.

The certificate sheet is for information only
The first sheet (Certificados (Certificates)) serves only to identify the certificate being worked on. The information on that sheet is not imported and has no effect on the system, but it is required for the import process. To change the details of the certificate itself, use the platform.

Each column has a format that must be respected. Whenever a column refers to another sheet (for example, the NIF/NIPC tax number or the site name), the text must match the source sheet exactly. See How the sheets link together.

SFM (Sustainable Forest Management)

The sheets are, in order: Membros (Members), Propriedades (Properties), Produtos (Products) and Espécies (Species).

Membros sheet

The members of the certificate.

ColumnDescription and format
Nome (Name)Name of the member's entity. If it is changed, the entity is renamed. The Propriedades, Produtos and Espécies sheets must use this name exactly as written.
NIF/NIPCTax number. Only the number, without spaces or punctuation; foreign numbers with the country prefix (e.g. GB749933773). Identifies the member and must be unique in the system.
Entrada no certificado (Entry into the certificate)Required. Date in the format DD/MM/AAAA.
Estado (Status)Required. One of the values: Válido (Valid), Expirado (Expired), Cancelado (Cancelled), Suspenso (Suspended), Retirado (Withdrawn), Cancelamento voluntário (Voluntary cancellation).
Morada (Descrição) (Address description)Required. Name/label of the address.
Morada (linha 1) (Address line 1)Required. First line of the address.
Morada (linha 2) (Address line 2)Optional. Second line of the address.
Código Postal (Postcode)Required. Format XXXX-XXX.
Localidade (Locality)Required.
Freguesia (Parish)Optional. If filled in, it must exist and belong to the specified municipality.
Concelho (Municipality)Optional. If filled in, it must exist and belong to the specified district.
Distrito (District)Optional. If filled in, it must exist.
País (Country)Required. Must exist in the system.
Sub-Certificado (Sub-certificate)Optional. Sub-certificate identifier.
Saída do certificado (Exit from the certificate)Optional. Date in the format DD/MM/AAAA. If filled in, state the reason.
Motivo da saída (Reason for exit)Required if the exit date is filled in. Free text.

Propriedades sheet

The parcels of each member. The Nome do proprietário (Owner name) + NIF/NIPC columns link each property to the member.

ColumnDescription and format
Nome do proprietárioMust match the Membros sheet (validated against the NIF/NIPC).
NIF/NIPCMust exist in the Membros sheet.
Nome da propriedade (Property name)Required. Cannot be repeated within the same owner. The Produtos and Espécies sheets refer to it by this name.
Entrada no certificadoRequired. Date in the format DD/MM/AAAA.
Área total (ha) (Total area, ha)Required. Number greater than 0 (minimum 0.01 ha).
Número de parcelas (Number of parcels)Required. Integer, minimum 1.
Propriedade fundiária (Land ownership)Required. One of the values: Privado (Private), Público (Public), Comunitária (Community).
Alto valor ecológico (%) (High ecological value, %)Required. Integer between 0 and 100.
Área certificada FSC (%) (FSC certified area, %)Required. Integer between 0 and 100.
Funcionalidade(s): Produção (%), Proteção (%), Conservação (%) (Function(s): Production, Protection, Conservation, %)Required. Integers. The sum of the three must be exactly 100.
GFS/TOF (SFM/TOF)Required. GFS or TOF. If it is TOF, the TOF type becomes required.
Tipo TOF (TOF type)Required if the previous column is TOF. One of the values: Urbano (Urban), Agricola (Agricultural).
FreguesiaOptional. If filled in, it must exist and belong to the specified municipality.
ConcelhoOptional. If filled in, it must exist and belong to the specified district.
DistritoOptional. If filled in, it must exist.
Unidade de gestão (Management unit)Optional. Free text.
ID Propriedade (Property ID)Informational: internal identifier. Do not fill in; it is ignored on import.

Produtos sheet

The products of each property. The Nome da propriedade + Nome do proprietário + NIF/NIPC columns link to the Propriedades sheet.

ColumnDescription and format
Categoria de produto (Product category)Required. 6-character code (e.g. 010000). Must exist in the system; shorter codes are padded with leading zeros.
Descrição (Description)Informational: description of the category. Ignored on import.
Nome da propriedadeMust match the Propriedades sheet.
Nome do proprietárioMust match the Propriedades sheet.
NIF/NIPCMust match the Propriedades sheet.

Espécies sheet

The species of each product. Links to the Produtos sheet by Categoria de produto + Nome da propriedade + Nome do proprietário + NIF/NIPC.

ColumnDescription and format
Espécie (Species)Exact scientific name; it must exist in the species catalogue.
Categoria de produtoMust match the Produtos sheet.
DescriçãoInformational: description of the category. Ignored on import.
Nome da propriedadeMust match the Produtos sheet.
Nome do proprietárioMust match the Produtos sheet.
NIF/NIPCMust match the Produtos sheet.

CoC (Chain of Custody)

The sheets are, in order: Sites, Volume de negócios (Turnover), Produtos and Espécies.

Sites sheet

The locations or operations of the certificate.

ColumnDescription and format
NomeName of the site's entity. If it is changed, the entity is renamed. The Volume de negócios, Produtos and Espécies sheets must use this name exactly as written.
NIF/NIPCTax number. Only the number, without spaces or punctuation; foreign numbers with the country prefix (e.g. GB749933773). It is the key the import uses to identify the site.
Entrada no certificadoRequired. Date in the format DD/MM/AAAA.
EstadoOne of the values: Válido, Expirado, Cancelado, Suspenso, Retirado, Cancelamento voluntário.
Morada (Descrição)Name/label of the address. In Multi-site certificates, together with the NIF/NIPC, it distinguishes sites of the same entity. The Volume de negócios, Produtos and Espécies sheets use this label.
Morada (linha 1)Optional. First line of the address.
Morada (linha 2)Optional. Second line of the address.
Código PostalOptional. Format XXXX-XXX.
LocalidadeOptional.
FreguesiaOptional. Must correspond to an existing parish.
ConcelhoOptional. Must correspond to an existing municipality.
DistritoOptional. Must correspond to an existing district.
PaísOptional. Must correspond to an existing country.
Tem actividade? (Has activity?)Sim (Yes) or Não (No).
Razão ausência de actividade? (Reason for absence of activity?)Required if «Tem actividade?» is Não. Free text.
Sub-CertificadoOptional. Sub-certificate identifier.
Sub-Licença (Sub-licence)Informational. Exported for reference, not read by the import.
Entrada (licença) (Licence entry)Informational. Not read by the import.
Saída (licença) (Licence exit)Informational. Not read by the import.
Estado (licença) (Licence status)Informational. Not read by the import.
Saída do certificadoOptional. Date in the format DD/MM/AAAA. Fill in only if the site has left the certificate.
Motivo da saídaOptional. Free text with the reason for leaving.

If a site has no activity in the chain, fill in «Tem actividade?» with Não and state the «Razão ausência de actividade?». Do not use a turnover of zero to represent the absence of activity: on import, the turnover must be greater than 0. This information must be consistent with what is described in the Notification procedure.

Volume de negócios sheet

The turnover per site and year. Links to the site by Nome + NIF/NIPC + Morada (Descrição).

ColumnDescription and format
Ano (Year)Required. Year (AAAA). Only the current year and the two previous years are accepted.
Volume de negóciosRequired. Numeric value with up to 2 decimal places. If the site has activity, it must be greater than 0.
NomeName of the site. Must match the Sites sheet.
NIF/NIPCMust match the Sites sheet.
Morada (Descrição)Must match the Sites sheet.

Produtos sheet

The products of each site. Links to the site by Site + NIF/NIPC + Morada (Descrição).

ColumnDescription and format
Categoria de produtoRequired. 6-character code (e.g. 010000). Must exist in the system; shorter codes are padded with leading zeros.
DescriçãoInformational: description of the category. Ignored on import.
Nome do produto (Product name)Required. Name/designation of the product.
Data de entrada (Entry date)Required. Date in the format DD/MM/AAAA.
Métodos: Separação física, Percentagem, Crédito (Methods: Physical separation, Percentage, Credit)Each column accepts Sim or Não. An empty cell counts as Não.
Alegações: X% Certificado PEFC, Fontes controladas PEFC, 100% de Origem PEFC (Claims: X% PEFC Certified, PEFC Controlled Sources, 100% PEFC Origin)Each column accepts Sim or Não. An empty cell counts as Não.
Reciclado (Recycled)Sim or Não.
SiteName of the site. Must match the Sites sheet.
NIF/NIPCMust match the Sites sheet.
Morada (Descrição)Must match the Sites sheet.

Espécies sheet

The species of each product. Links to the site and the product by Site + NIF/NIPC + Morada (Descrição) + Categoria de produto.

ColumnDescription and format
EspécieExact scientific name; it must exist in the species catalogue.
Categoria de produtoMust match the Produtos sheet.
DescriçãoInformational: description of the category. Ignored on import.
SiteName of the site. Must match the Sites and Produtos sheets.
NIF/NIPCMust match the Sites and Produtos sheets.
Morada (Descrição)Must match the Sites and Produtos sheets.

Informational columns (not imported)

Some columns exist for reading only and have no effect on import:

  • The Certificados sheet, in its entirety.
  • The Descrição column (of the product category), in the Produtos and Espécies sheets.
  • The ID Propriedade column, in the Propriedades sheet (SFM).
  • The Sub-Licença, Entrada (licença), Saída (licença) and Estado (licença) columns, in the Sites sheet (CoC).

How the sheets link together

The link is made by reference to the identifier of the previous sheet, and the text must match exactly:

  • SFM: properties refer to the member (Nome do proprietário + NIF/NIPC); products and species refer to the property (Nome da propriedade + Nome do proprietário + NIF/NIPC).
  • CoC: turnover, products and species refer to the site (Nome/Site + NIF/NIPC + Morada (Descrição)).

An extra space, a different accent or a wrong capital letter break the link and generate a validation error. For the step-by-step guide and how to read the errors, see Import data (Excel). The complete list of rules, field by field, is in Validation rules.