Accurate purchasing data is essential to measure your Scope 3 emissions under Category 1: Purchased Goods & Services.
To make the process easier, our AI-powered import tool will help clean and structure your data. Our AI will also try to understand what packaging items you are uploading and estimate the correct size based on the data you provide.
Step 1: Gather Your Purchase Data
To get started, you’ll need purchase records for all packaging items purchased throughout your full reporting year.
You can normally source this information directly from your purchase orders or supplier invoices, often accessible through your procurement or accounting systems.
Make sure data covers the entire reporting period you’ve set (e.g. 1 Jan–31 Dec).
Data can be uploaded in
.xlsx,.xls, or.csvformat. Our tool will process and convert it as needed.
Our AI tool requires columns for name and quantity, and optionally a unit column if there is one. From this data we will extract quantities and pack sizes and match each row to a standard packaging item and size in our system.
If your data has supplier names and IDs, you can also include those to help view and segment your data later on.
A standard purchase dataset may look something like this:
ID | Supplier | Name | Quantity | Unit |
FD001 | PackRight Ltd | Cardboard box (small) | 500 | EA |
FD002 | EcoWrap Supplies | Plastic film | 75 | kg |
FD003 | GreenPak Co. | Coffee cup - Case x250 | 1,200 | EA |
Step 2: Upload Your Spreadsheet(s)
Your dataset must cover the entire reporting year, but you can choose how to structure it:
You can upload all data in one file for the full year, or break it down into monthly or quarterly files. For example:
Jan.xlsx → Packaging items purchased in January.
Feb.xlsx → Packaging items purchased in February.
You can upload data multiple times, even for the same period, so there’s no need to do it all at once.
If you have a large dataset, we recommend splitting your data into smaller, manageable chunks based on time periods - monthly or quarterly.
Why?
It’s easier to review, clean, and check smaller files.
If any errors occur during an upload, you won’t lose your progress.
You will later be able to filter your data by those same time periods.
To import, upload an .xlsx, .xls, or .csv file containing your packaging purchase data. The AI tool will guide you through selecting the relevant columns.
Step 3: Map Your Data Columns
Once your file is uploaded, you’ll need to select the correct columns in the platform:
Required Columns:
Name – The packaging name or description
Quantity – The number of items or weight purchased
Unit – Select if available, otherwise, the tool can interpret it.
Optional Columns:
Supplier – Helps with filtering but is not required.
ID – Useful for tracking internal product references.
If your dataset contains additional columns such as cost, don’t worry - we don’t need these. You can simply deselect these to exclude them from the import.
Step 4: Let the AI Tool Process Your Data
Our AI-powered import tool will extract relevant data from each column, including pack sizes (e.g Kraft bowl x1000), calculating a total quantity and standardising the units. Once processing is complete, return to review the results.
Step 5: Review & Validate Your Data
Before finalising the upload, our platform will show you rows to check, to ensure that the correct quantity and item weights have been extracted or calculated for each row.
The Items purchased and Unit columns show the total quantities we will actually record on your report. Highlighted rows indicate where we believe the row is either not a packaging item or is potentially missing a pack quantity.
Check that the Items purchased and Unit columns are correct.
If there is an issue with the row, click on it to view and edit the data, or delete the row from the import.
Once you are happy with the data, click the Import data button to complete your import.
Step 6: Finalise & Import Your Data
Once you have reviewed and corrected all data, click Import Data to finalise the upload. The system will process the final import and add it to your report under Scope 3 - Packaging in your Company Carbon Report.
You can always revisit the data later to make corrections if needed.