The Ultimate Football Manager Spreadsheet Tool – Build Better Squads Faster

Are you a Football Manager spreadsheet fanatic? You’re in the right place.

This custom-built Football Manager spreadsheet is your secret weapon for finding hidden gems, breaking down player data, and sharpening your transfer strategy. Whether you’re chasing wonderkids or trimming the fat from your squad, this tool gives you the insight edge you didn’t know you needed.

I started building this spreadsheet in 2019, purely to level up my own saves. Over time, it evolved into a full-blown analysis tool used by thousands. It’s not magic, but it is a practical way to scout smarter and make more confident decisions.

Now, onto the exciting part: getting this tool set up for your own save. Just follow these steps:

How To Install theFFM Football Manager Spreadsheet

1) Import the theFFM Attribute Analysis 2024 view into Football Manager via Custom > Import View > theFFM Attribute Analysis 2024.fmf

2) Press CTRL + P and save the webpage in your preferred location

3) Open both theFFM Attribute Analysis 2024 spreadsheet and the saved webpage in Excel

4) Highlight all player data (excluding the top row and SIGames link) and copy using CTRL + C

5) Navigate back to theFFM Attribute Analysis 2024 spreadsheet, selecting cell B3 on the ‘Base’ sheet

6) Press CTRL + Alt + P, then select the ‘Values’ option

Voila! Your spreadsheet is primed and geared to dissect player attributes, aiding you in clinching those crucial victories in Football Manager.

Remember, while this tool has been a game-changer for me, different teams might require a touch of personal finesse. But why not give it a shot? After all, every little bit helps in the thrilling world of Football Manager.

theFFM Football Manager Spreadsheet Features

So, you’ve followed the seamless installation guide for the theFFM Football Manager Attribute Spreadsheet.

Now, get ready to embark on a managerial journey like never before, armed with an array of powerful features that will elevate your gaming experience to new heights.

Let’s delve into the treasure trove of functionalities this spreadsheet brings to the table:

Formation Selector

With the Formation Selector, simply use the drop-down menu or type your formation’s roles in the relevant position. This information seamlessly flows into multiple screens without any extra effort on your part.

Player Overview

Effortlessly gather crucial player data in one place. Type in a player’s name or choose from the drop-down menu to access vital information from every sheet. Highlighting attributes with scores of 16+ in green and 11-15 scores in blue, this feature also showcases each player’s abilities for the roles within your formation, emphasising the top three. It considers their position on the pitch within the rating.

Overall Roles

A view of every player and their suitability for various roles awaits you here. The rating system incorporates bonuses for players naturally suited to a position. Tweak the green cell percentage to match your team’s requirements. Matching ratings are highlighted in green, while the row next to the green cell indicates the number of squad members meeting your chosen percentage. Select a position from the drop-down menu in the blue cell to instantly highlight compatible roles for that position.

Top Rated By Role

Need a quick rundown of the top 5 players for each role? This feature separates them for an easier view and highlights the roles utilised in your formation, ensuring a swift and comprehensive overview.

Overall Positions

This sheet displays an average of each role combined with foot strength and best position. Edit the percentage in the same way as the Overall Roles sheet to align with your team’s abilities.

Top Rated By Position

Another ‘at-a-glance’ display offers the top 5 players for each position, aiding in swift decision-making during squad analysis.

Squad Notes

Automating manual tasks, this sheet lets you effortlessly add personalised notes while displaying key data. Filter the ‘Best Role in Formation’ cells by role to streamline your data analysis, especially handy when dealing with vast amounts of information.

Download theFFM Football Manager Spreadsheet

Get your hands on the Football Manager Spreadsheet by downloading the zip file, which also includes four different views:

• theFFM Attribute Analysis 2024 Spreadsheet
• theFFM Attribute Analysis 2024 Squad View
• theFFM Players in Range View
• theFFM Scouted Players View
• theFFM Shortlist View

{This spreadsheet is in no way affiliated with Football Manager)
(Blog post written with assistance from ChatGPT)

FAQ

Q: The spreadsheet is password-protected; can you send me the password?
A: It doesn’t need a password; any cells you need to edit are unlocked; I’ve password-protected the rest to prevent accidental editing of the formulas.

Q: When I export from the player search, some players are showing up as — instead of their name.
A: To prevent this, you need to highlight all players on the search page before exporting the data.

Q: Is there a FM23 version?
A: Yes, I’ll be uploading it soon.