Progress Tracker Spreadsheet

It’s no secret that I love a good Football Manager spreadsheet, so when I needed a way to track the progress of my Cadbury Athletic FC save it was a no-brainer to make one.

What I didn’t expect, however, was that other people would be interested in having one of their own!

It’s nothing fancy with loads of behind the scenes formulas, it’s a simple sheet that you can update as you progress along the seasons. You’ll have your own way of tracking, but I suggest just changing the cell colour of the achievement as shown in my tweet above.

I’ve left the spreadsheet unlocked so you can change the achievements you’re tracking if you desire, though I do hope I’ve covered most bases and, with the space to track 12 leagues and 12 cups, it should last the length of any long-term save. Be sure to tag me on Twitter in your creations!



Attribute Analysis Spreadsheet

I’m a self-confessed spreadsheet geek and Football Manager addict, so when I stumbled on an opportunity to combine them both, of course I couldn’t resist!

What started as a simple spreadsheet for my own use in July 2019, it quickly became a project I have continuously worked on and developed for the last 8 months, turning into what I can now proudly release for public download.

But first…

Before I introduce you to the features of v2, I would like to say that the formula’s used in the spreadsheet and the results it gives are based on I have found works during my own saves in Football Manager. I can’t guarantee that they’ll work for every team so please don’t always take what it says as golden as I cannot promise the results are perfect.

How does this differ to v1.5?

  • New Club DNA Analysis feature
  • New Player Analysis sheet
  • New Squad Notes sheet
  • Top 3 Overview is now Top 5
  • Behind the scenes formula update to lower file size and increase speed
  • New colour scheme and layout

Feature Guide

After setting up the spreadsheet by following the installation guide in the zip file, you’ll be given several pages of data.

Each positional area has its own sheet, which is broken down further into the relevant roles.

Every squad player is given a rating based on how suitable they are for that role.

If the player is a natural in the position the role matches – e.g. ST as a Target Man, D (R) as a Wing-Back – they will receive a bonus rating

football manager spreadsheet position overview

Another way you can view role suitability is on the ‘Overall’ sheet. This shows every player and every role on one sheet.

→ The yellow cell can be edited to any percentage based on your required levels and, in turn, any matching ratings will be highlighted in light purple.

football manager attribute analysis spreadsheet overall positions
As an example, I find 70% is a good level for high-quality teams playing in Europe

→ The row to the right of the yellow cell shows how many of your squad have above your chosen percentage so you can see where you have the best depth for that role.

→ The column directly below the yellow cell shows how versatile a particular player is and how many roles, based on your percentage, they could comfortably play or even be retrained in if young enough.

Top 5
An ‘at a glance’ view of the top 5 players for each role, separated into sections based on the positional areas.

football manager attribute analysis spreadsheet top 5 positions

NEW – DNA Analysis
Club DNA is an often overlooked part of Football Manager which I touched upon on in the first part of my DNAjax blog. In short, DNA is all about building a squad that shares the same qualities. There are plenty of blogs around that go into a lot of detail so I’d recommend a quick Google search if you are interested in learning more.

This sheet will populate after you’ve imported your data into the ‘DNA Base’ sheet. The 5 core attributes (Bra, Cmp, Det, Tea, Wor) are my own personal choices so you may want to switch them out for 5 that suit your style of play better. Changing the attribute names on the ‘DNA Base’ sheet will update them on the ‘DNA Analysis’ sheet too.

football manager attribute analysis spreadsheet dna overview

Along with the 5 attributes, the DNA rating is also made up of the following:

Country Where Club is Based: Players who play in the country of their Nationality receive a 5pt bonus on their DNA score.

Core Squad Personalities: Up to 5 of the strongest personalities you’d like in your squad – a 20pt bonus goes to those who possess one of them.

Secondary Squad Personalities: Not every player will be perfect so choose up to another 3 personalities you’d find acceptable – a 15pt bonus will be applied.

Personalities to Develop (u23): Young players still have room to develop their personality with mentoring or experience. There will be a 10pt bonus given to anyone under 23 years old who has one of the personalities you enter here.

IMPORTANT NOTE: I have left in the examples used in my DNAjax save so you can see how the data is filled in – you just need to change your country to the three-letter abbreviation used in Football Manager and the personality types to suit your style of play.

Once all the above data has been filled in, the spreadsheet works its magic formula and gives a suggested squad for the player to be part of and even if you’d be better off without them.

IMPORTANT NOTE: The formula takes into account the suitability percentage you enter on the ‘Overall’ sheet so don’t forget to fill it in or the calculations won’t work!

→ Players between the ages of 17 and 21 can be recommended for a loan spell away from the club in order to develop.

→ Players between the ages of 19 and 21 can be put forward for exposure to your First Team if they show high potential to be a star. I’d suggest training them with the senior squad and using them as a substitute or in cup games.

NEW – Player Analysis
Type the name, or use the drop-down menu, for one of your squad into the top box and it will pull the most important data from the other sheets into one place.

→ Club DNA % is calculated from the information inputted into the ‘DNA Analysis’ sheet. Edit the Target DNA box on the right to the lowest percentage you’d consider as an acceptable match for your DNA vision.

→ Use the Formation Suitability menu to type in, or select using the drop-down menu, the formation and roles being used in your tactic and it will work out whether they are a suitable fit (based on their top 3 roles) for your team.

IMPORTANT NOTE: When inputting your formation, please make sure you state both the role and mentality using the format in the example or the sheet will return an error.

NEW – Squad Notes
This was a last-minute addition to the spreadsheet after it was something I found came in useful whilst setting up my DNAjax save.

There isn’t anything automated about it but it enables you to have a sort of notepad for when you’re moving players around squads, setting up individual role training, or simply just wanting to keep track of who you’re offering out for transfers and loans.


The download you receive contains the following in a zip file:

  • Analysis Spreadsheet
  • Installation Guide

    Attribute Analysis
  • Custom Squad View
  • Custom Player Search View
  • Custom Shortlist View

    Squad DNA Analysis
  • Custom Squad View
  • Custom Player Search View
  • Custom Shortlist View

IMPORTANT NOTE: If you are using different core attributes for your Club DNA than what I have, don’t forget to change them on the views before exporting to the spreadsheet.

Because this version of the spreadsheet has taken so much work, I have made the decision to offer it as a download for a minimum £1 donation


If you’d prefer not to donate, then is a free version of the spreadsheet available which doesn’t include the Club DNA feature


{This spreadsheet is in no way affiliated with Football Manager)

FM Union Wages Spreadsheet

Wages Spreadsheet

Absolutely love this Wages Spreadsheet by FM Union!

I’m always overspending on wages and I can never decide how much bonus I should offer for appearances and goals. Now I’ll never have to worry again as this amazing spreadsheet will work it all out for me!

Check out the FM Union YouTube channel for more details on how to use it, and be sure to give him a follow on Twitter too!

FM Union @ YouTube

Player Development Spreadsheet

After the success of my Attribute Analysis Spreadsheet, I’ve been itching to make more. I just haven’t had the time nor brainpower to do one due to a mass pandemic and the increased demands of my work. Until now!

The most often requested spreadsheet I get is one for player development and tracking it over the course of a few months or seasons. Whilst this is available in-game, this spreadsheet will give a more streamlined and clearer view of the data.

The spreadsheet was made for FM20 but I’ve no reason to believe it wouldn’t work in earlier versions. Please try it out and let me know!

Feature Guide

The first 10 sheets in the spreadsheet are where you’ll input the data exported from the game. Depending on how many months/seasons you’re comparing you can use all 10 or just a couple.

The sheets are currently numbered 1-10 but by right-clicking on the tab, you can rename these to anything you want.

FFM Player Development Spreadsheet

Once all the data you require is imported, head to the Development tab. This sheet is where you can compare the progress one of your players has made.

FFM Player Development Spreadsheet

→ Select cell B2 and type in the name of the player you want to track
→ In the data column, type in the name of the tabs you’re comparing

The attribute will turn green if there’s been an improvement and red if it’s declined.

At the bottom of the sheet, you’ll find a chart where you can compare the progress of up to 10 attributes.

In the coloured cells, you can type in or select from the drop-down menu the attributes you’re interested in.


The download you receive contains the following in a zip file:

  • Player Development Spreadsheet
  • Installation Guide
  • Custom Squad View