Importing Excel Tables into the Project Schema in VM0033 methodology

To test this feature, VM0033 schemas excel file containing multiple pages was provided as an example.

Each page in the Excel file must be converted into a CSV file, and each CSV file should be uploaded as a separate table field. T

The name of each page can be used as the corresponding table field name.

In policy VM0033, three table fields were added to the Project Description (Auto) schema. Screenshots of the 8.2ProjectEmissions Excel page and the corresponding table in the VC document are provided for reference.

5.1 Adding Table Fields to the Policy Schema

In the example of policy VM0033, three table fields were added to the Project Description (Auto) schema. Each table field retains the same name as in the original Excel file.

5.2 Importing Converted CSV Files into Table Fields

Log in as the Project Proponent, then create a new project by clicking the “New Project” button.

Within the form, import the converted CSV files into their respective table fields.

After loading the files, please review the first rows/columns.

5.3 Viewing Tables in the VC Document

The VC document displays the imported tables. To view them, click the “Open Table” button.