Importing FFT Benchmarks and Estimates

Benchmarks and estimates from FFT Aspire can be imported into Insight. The following steps outline the process.

  1. Log in to
  2. Hover over the cog icon on the top-right of the menu bar.
  3. Under the Export data heading, click Benchmark estimates & pupil targets.
  4. Now select the Key Stage and Year you want to export.
  5. Select whether you want FFT5, FFT20 or FFT50 benchmarks
  6. Tick the box to Include target grades and information.
  7. Click Export.
  8. Once the export is successful, click Continue to download or Export another, if needed.
    (You can also hover over the cog icon again, and click Ready to download.)
  9. The Ready to download page will list your exported files. Click the required files to download to your computer.
    (The downloaded files will have names ending with ".tsv". )
  10. Log in to Insight Tracking
  11. Click Enter Data > Import FFT Benchmarks.
  12. Choose the file to be imported (select the downloaded ".tsv" files).
  13. Optionally, select which type of benchmark you have (FFT50, FFT20 or FFT5).
  14. Optionally, select if you want the data imported into Insight in the current year group, or at the end of the key stage.
  15. Click Import.
  16. Wait while Insight imports the data.

The data is imported into Insight with the names "FFT Benchmark" and "FFT Scaled Score Estimate".

Because they are end of key stage targets, Insight always stores them under either Y2 or Y6, with term Summer 2.

How did we do?