---
title: 86. How do I formant an assessment framework in Excel so that it can be uploaded onto TrackAble?
description: How to create an assessment framework in Excel for TrackAble, including required spreadsheet format, column structure, and best practices to avoid data errors.
---
[Skip to content](https://www.trackablehelp.com/trackable-knowledge-base/57.-how-do-i-view-/-edit-school-information-1-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0-0#main-content)
English - United Kingdom
Show submenu for translations
%20(1).png?width=1200&height=360&name=Solar%20is%20now%20TrackAble%20(600%20x%20180%20px)%20(1).png)
- Home
- Products
- Pricing
- Blog
- Company
Open main navigation
Close main navigation
- Home
- Products
- Pricing
- Blog
- Company
- English - United Kingdom
Show submenu for translations
- [Contact us](mailto:support@trackable.org.uk)
[Contact us](mailto:support@trackable.org.uk)
How can we help you?
- There are no suggestions because the search field is empty.
1. [TrackAble](https://www.trackablehelp.com/trackable-knowledge-base?hsLang=en-gb)
2. [FAQs](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb)
3. [Assessment Framework](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#assessment-framework)
# 86. How do I formant an assessment framework in Excel so that it can be uploaded onto TrackAble?
## TrackAble allows schools to create their own assessment frameworks using an Excel spreadsheet. Once completed, the TrackAble support team will upload the framework to your system. Assessment frameworks are uploaded free of charge, provided the spreadsheet is formatted correctly.
### Important Information Before You Start
✔️ Framework uploads are **free of charge**
⚠️ If a framework is uploaded and the data provided is **incorrect**, there **may be a charge** to remove the incorrect framework and upload a corrected version
It is the **school’s responsibility** to ensure:
- The spreadsheet format is correct
- All spelling is accurate and consistent
- There are no extra spaces or variations in naming
### Why Accuracy Matters
TrackAble treats **capital letters and spaces as characters**.
For example:
- `English` and `english` will create **two separate subjects**
- `L1` and `L 1` will create **two separate levels**
This can cause:
- Duplicate subjects or levels
- Reporting issues
- Data inconsistencies
Always **spell check** and check for **extra spaces** before sending the file.
### Spreadsheet Format Requirements
Your spreadsheet **must follow this exact structure**:
- Each **assessment framework must be on a separate spreadsheet**
- **All subjects must be on Sheet 1**
- Do **not** use multiple tabs for different subjects
- The spreadsheet must contain **only the 5 columns listed below**
### Required Column Headings
Your spreadsheet must include **only** these columns, in this order:
- **Column A:** Assessment Framework
- **Column B:** Subject
- **Column C:** Level
- **Column D:** Statements
- **Column E:** Details
No additional columns should be added.
### What Goes in Each Column
**Column A – Assessment Framework**
- The name of the framework
- Must be **exactly the same** on every row
**Column B – Subject**
- Subject names within the framework
- Must be spelled consistently throughout
**Column C – Level**
- The level name (for example: P4, L1, Step 3)
- Ensure there are **no extra spaces**
**Column D – Statements**
- The assessment statement
**Column E – Details**
- Optional supporting information
- Can include guidance to help staff understand what a pupil needs to do to meet the statement
### Using an Existing Framework as a Template
If you download an existing assessment framework from TrackAble into Excel:
- It will already be in the **correct format**
- This can be used as a **template** for creating new frameworks
### Final Checks Before Sending
Before sending your spreadsheet to TrackAble, check that:
- ✔️ All spelling is consistent
- ✔️ There are no extra spaces
- ✔️ All data is on **Sheet 1 only**
- ✔️ Only the **five required columns** are included
### Submitting Your Framework
Once your spreadsheet is complete and checked, send it to:
**support@trackable.org.uk**
The support team will upload the framework and contact you if any issues are identified.
- [Getting started](https://www.trackablehelp.com/trackable-knowledge-base/getting-started?hsLang=en-gb#main-content)
- [Terms](https://www.trackablehelp.com/trackable-knowledge-base/getting-started?hsLang=en-gb#terms)
- [Logging in](https://www.trackablehelp.com/trackable-knowledge-base/getting-started?hsLang=en-gb#logging-in)
- [Settings](https://www.trackablehelp.com/trackable-knowledge-base/settings?hsLang=en-gb#main-content)
- [Custom Fields](https://www.trackablehelp.com/trackable-knowledge-base/settings?hsLang=en-gb#custom-fields)
- [Stars](https://www.trackablehelp.com/trackable-knowledge-base/settings?hsLang=en-gb#stars)
- [Assessment Frameworks](https://www.trackablehelp.com/trackable-knowledge-base/settings?hsLang=en-gb#assessment-frameworks)
- [Behaviour](https://www.trackablehelp.com/trackable-knowledge-base/settings?hsLang=en-gb#behaviour)
- [Targets](https://www.trackablehelp.com/trackable-knowledge-base/settings?hsLang=en-gb#targets)
- [Forms](https://www.trackablehelp.com/trackable-knowledge-base/settings?hsLang=en-gb#forms)
- [Classes](https://www.trackablehelp.com/trackable-knowledge-base/settings?hsLang=en-gb#classes)
- [Streaming](https://www.trackablehelp.com/trackable-knowledge-base/settings?hsLang=en-gb#streaming)
- [Support](https://www.trackablehelp.com/trackable-knowledge-base/support?hsLang=en-gb#main-content)
- [Multi School Hub](https://www.trackablehelp.com/trackable-knowledge-base/support?hsLang=en-gb#multi-school-hub)
- [Reports](https://www.trackablehelp.com/trackable-knowledge-base/reports?hsLang=en-gb)
- [FAQs](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#main-content)
- [Pupils](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#pupils)
- [Targets](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#targets)
- [Assessment Framework](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#assessment-framework)
- [Users](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#users)
- [Baselining](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#baselining)
- [Security](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#security)
- [Settings](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#settings)
- [Admin](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#admin)
- [Reporting](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#reporting)
- [Behaviour/Incidents](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#behaviour-incidents)
- [Classes](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#classes)
- [Stars](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#stars)
- [Key Stages](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#key-stages)
- [IEP](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#iep)
- [Routes for Learning](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#routes-for-learning)
- [Levels](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#levels)
- [Interventions](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#interventions)
- [Moderate](https://www.trackablehelp.com/trackable-knowledge-base/faqs?hsLang=en-gb#moderate)
- Home
- Products
- Pricing
- Blog
- Company
[](http://learningdna.org.uk)
[mailto:support@trackable.org.uk](mailto:support@trackable.org.uk)
Copyright © 2025, Learning DNA