Prepare and check a CSV import
For SIPs using their own data system: agree the file layout and check the imported results.
Last updated 6 days ago
Use this guide if your SIP has agreed to upload output figures from another system. A monthly CSV upload is separate from uploading the three Excel reports during onboarding.
Before your first upload
- Send Brownie Points a sample export and confirm the upload route.
- Agree which columns identify the Locality, indicator, reporting period, result and evidence.
- Agree how corrected or repeated files will be handled so the same activity is not counted twice.
- Check a first upload with Brownie Points before importing the rest.
The standard Outputs uploader uses fixed column names and shows a 500-row limit. Your own export may need a separate mapping. Use the format agreed for your SIP; do not rename columns or split a file without checking that approach.
Check each import
- Use the correct reporting period, even when uploading in the following month.
- Compare the imported record count and totals with your source file.
- Check Locality and indicator links, zero values and any rejected rows.
- Open evidence links to confirm reviewers can access them.
- Check record status and follow the review process agreed for your import route.
If an upload is interrupted or its result is unclear, check what was saved before uploading it again. Send support the file name, period and error message. Keep an unchanged copy of your source file.
Previously submitted records can still be reviewed while you prepare a new file. Do not assume a new import replaces old records or their reviews.
Next: Review submissions and corrections. For manually captured figures and attachments, use Capture outputs and evidence.