Extended producer responsibility for packaging: generate a packaging data file
If you need to submit packaging data under extended producer responsibility for packaging, this spreadsheet can help you generate a valid packaging data file
Documents
Details
If you바카라 사이트檙e an organisation that supplies packaging to consumers and businesses in the UK, you may have to take action to comply with extended producer responsibility (EPR) for packaging.
You may need to collect and submit data about packaging you바카라 사이트檝e supplied through the UK market, or any filled packaging you have imported and discarded in the UK.
Find out if you need to collect and report your packaging data.
If you do have to report packaging data you can use this tool to either:
- generate a valid packaging data file
- check how your file should be structured before creating one yourself
It will open as a spreadsheet with three tabs in most spreadsheet software.
Using the generator
1. Prepare your data
There is guidance that explains:
This tool will generate the codes and enforce the rules explained in the guidance about creating your file.
2. Enter your data
Go to the 바카라 사이트楨nter your data바카라 사이트� tab in the spreadsheet.
Enter your first record on the row under the headers. Start with column B, 바카라 사이트極rganisation ID바카라 사이트�.
The spreadsheet is converting your entries as you go. To avoid errors, work from left to right across a row. If you need to make changes, clear the entire row and start again.
Select from the drop-down list in any field where one is available. For fields without a dropdown list, check the guidance explaining how to create your file for extended producer responsibility to find the correct format.
If you need to submit more than one record:
- use a new row for each record
- enter data one row at a time
- do not leave blank rows between records
If you save the file while you바카라 사이트檙e working on it, keep the original format - it should be an ODS (open document spreadsheet) file.
3. Generate a file
When you바카라 사이트檝e entered all your records, check the number under 바카라 사이트楳issing Rows in your output바카라 사이트� (cell A2). It will be one less than the number of records you바카라 사이트檝e entered - for example, if you바카라 사이트檝e got 5 rows of records, it should be 4.
This tells you how many rows you바카라 사이트檒l have to add in the following steps.
Skip these steps if 바카라 사이트楳issing Rows in your output바카라 사이트� is zero - that is, you have only entered 1 row.
- Switch to the 바카라 사이트榊our output바카라 사이트� tab of the spreadsheet.
- Click row 2 - first row under the header row - to select the whole row and then copy it.
- Select exactly the number of rows you need to add - for example, if 바카라 사이트楳issing Rows in your output바카라 사이트� was 바카라 사이트�4바카라 사이트�, select rows 3 to 6.
- Paste the formula from your copied row 2 into these rows - 바카라 사이트榩aste formula바카라 사이트� is usually available in the 바카라 사이트榚dit바카라 사이트� menu of spreadsheet software, under 바카라 사이트榩aste special바카라 사이트�
Now:
- 바카라 사이트楳issing rows in your output바카라 사이트� on the 바카라 사이트楨nter your data바카라 사이트� tab should be zero
- the 바카라 사이트楨nter your data바카라 사이트� and 바카라 사이트榊our output바카라 사이트� tabs should have the same number of active rows, ignoring the header row in 바카라 사이트楨nter your data바카라 사이트�
If the number is still greater than zero, check that you have copied the formula from the second row of 바카라 사이트榊our output바카라 사이트� to enough additional rows.
4. Check your data
If you바카라 사이트檝e made any errors, they will be highlighted in the 바카라 사이트榊our output바카라 사이트� tab.
Errors include things like:
- missing information
- codes that cannot be used together - for example, if your organisation size is 바카라 사이트楲arge (L)바카라 사이트�, you cannot select 바카라 사이트榮mall organisation packaging (SP)바카라 사이트� for packaging type
- you바카라 사이트檝e completed fields that should be empty - for example, giving a number for 바카라 사이트楺uantity (units)바카라 사이트� for anything other than drinks containers
Correct these errors before exporting your file. Check the guidance on how to create your file for extended producer responsibility if you need help understanding the error.
5. Export the file
You should only export your data once you have completely finished and will not need to edit it again.
Make sure you are on the 바카라 사이트榊our output바카라 사이트� tab.
Save the file using 바카라 사이트楽ave as바카라 사이트�. You must save it in the CSV (comma separated values) format.
Your spreadsheet program may warn you that you cannot save a workbook as CSV. It will ask you if you want to save the active tab. If you are on 바카라 사이트榊our output바카라 사이트�, confirm that you do want to save the active tab.
You can submit this CSV file to the 바카라 사이트榬eport packaging data바카라 사이트� service.
Updates to this page
-
There was an incorrect formula in cell M2 of the tab 'Your_output'. This may have affected some calculations around drinks containers (household and non-household)
-
A new version of the tool that supports dual reporting has been published.
-
A new version of the packaging data generator has been uploaded, with updated reporting period dates.
-
The previous update to this page published a new version of the packaging data tool (2024 v1) prematurely. Using this version may lead to some data issues. This update reverts the tool to the previous version (2023 v2.3) - use this version for your packaging data for now.
-
A new version of the packaging data generator has been uploaded, with updated reporting period dates.
-
A new version of the packaging data generator has been uploaded. This fixes unexpected error messages when entering data.
-
Updated packaging data file generator template - the column headers match up more clearly with the service.
-
Updated the file template to the latest version.
-
First published.