How it works
Follow these steps to turn one pupil export into voucher order CSV files that avoid duplicate email addresses.
Nothing is uploaded
Step-by-step guide
Complete the steps in order. The homepage will show analysis and warnings after upload.
Step 1
Prepare your pupil CSV
Export pupils from your school system as-is. You do not need to curate the file first; the tool analyses the full content, reads the Yes and No eligibility values, and only exports the relevant pupils.
Step 2
Upload the CSV
Drop the file onto the upload area or select it from your device. The file is parsed in your browser only.
Step 3
Choose who to include
Keep FSM and Early Years PP selected, or switch either group off if the order should only include one eligibility type.
Step 4
Fix any blocking issues
The tool stops export if an eligible pupil is missing a name, has no email address, or has an invalid email address.
Step 5
Generate and review the ZIP
Enter the voucher value, delivery date, and URN, confirm the review acknowledgement, then download the generated order files.
Step 6
Extract the downloaded files
Open the downloaded ZIP folder and extract the CSV files to a location you can easily find, such as Downloads or a secure school folder.
Step 7
Upload each file to Edenred
Go to the Edenred ordering site, then upload each generated CSV individually using the bulk upload function in Order and send eCodes by email.
Source CSV checklist
First name
Accepted aliases include Forename and Pupil First Name.
Last name
Accepted aliases include Surname and Pupil Last Name.
Email address
Accepted aliases include Parent Email and Student email.
FSM eligibility
The tool uses this to include pupils eligible for Free School Meals.
Early Years PP eligibility
The tool uses this to include pupils eligible for Early Years Pupil Premium.
UPN
Optional, but useful for spotting duplicate pupil records.
Why multiple order files?
Voucher providers usually reject an order file when the same email address appears more than once.
This tool groups eligible pupils by normalised email address, then places pupils sharing an address into separate CSV files. Each generated order file contains unique email addresses.
What the ZIP contains
The ZIP contains one or more order CSV files named order-1.csv, order-2.csv, and so on.
Each file uses: First Name, Last Name, Email Address, Value, Delivery Date, URN and UK PRN. UK PRN is included and left blank.
When export may be blocked
Disclaimer
This tool is designed to assist with preparing FSM voucher order files. The accuracy of the generated exports depends on the uploaded source CSV and the settings selected before export.
Users should review and validate all generated files before using them or submitting them to a voucher provider. The developer accepts no liability for errors, omissions, incorrect submissions, financial losses, or outcomes resulting from misuse of the tool or failure to validate exported data.