• FM24
    • Clubs to Manage
    • Beginners Guide
  • FM23
  • Wonderkids
  • Guides
    • Basic Learning
    • Scouting
    • Training
  • Players
  • Tactics
    • Tactics Creation
  • Databases
  • Downloads
    • Graphics
    • Shortlists & More
  • FM Videos
  • Write for Us
Facebook X (Twitter) Instagram YouTube Steam
Trending
  • FM24 Lower League Clubs to Manage
  • Football Manager 2024 Teams to Manage: Challenging Save Ideas for FM24
  • How to Load FM23 Save Games in Football Manager 2024
  • Football Manager 2024 Save Ideas
LOGIN
|
REGISTER
Facebook X (Twitter) Instagram YouTube
Passion4FMPassion4FM
Subscribe
  • FM24
    • News
    • Clubs to Manage
      • FM24 Save Ideas
      • FM24 Clubs to Manage
  • FM23
    1. FM Essentials
    2. Staff
    3. View All
    Football Manager 2023 increase realism megapack

    FM23 Increase Realism Megapack by Daveincid

    Football Manager 2023 Around the Globe League megapack

    FM23 Around the Globe Leagues Megapack by DaveTheEditor

    Football Manager 2023 Wonderkids & talents

    Football Manager 2023 Wonderkids | The Ultimate FM23 Wonderkids Shortlist

    Football Manager player attribute analysis spreadsheet by TheFFM

    Player Attribute Analysis Spreadsheet by TheFFM

    Best Football Manager 2023 Coaches

    Best Football Manager 2023 Coaches

    Football Manager 2023 Best Scouts

    Best Football Manager 2023 Scouts

    Football Manager 2023 Best Head of youth development

    Best FM23 Head of Youth Development

    Football Manager 2023 Best Assistant Managers

    Football Manager 2023 Best Assistant Managers

    Football Manager 2023 NextGen Wonderkids Database - Find the Potential FM24 Wonderkids

    FM23 NextGen Wonderkids Database

    Football Manager 2023 increase realism megapack

    FM23 Increase Realism Megapack by Daveincid

    Football Manager 2023 Around the Globe League megapack

    FM23 Around the Globe Leagues Megapack by DaveTheEditor

    Football Manager 2023 Transfer budgets & wages

    Football Manager 2023 Transfer Budgets

  • Guides
    1. Beginners Guides
    2. Scouting
    3. Tactics Guides
    4. Training Guides
    5. View All
    Ultimate guide to scouting in Football Manager 2023

    Scouting in Football Manager 2023 | The Definitive Guide

    Football Manager ultimate guide to youth development

    The Ultimate Youth Development Guide | How to develop players in Football Manager

    Beginners guide to Football Manager 2023 - how to set up your save

    Beginners Guide to Football Manager 2023 | Setting Up Your Save

    Football Manager player attributes guide

    Football Manager Player Attributes & Hidden Attributes Explained

    Ultimate guide to scouting in Football Manager 2023

    Scouting in Football Manager 2023 | The Definitive Guide

    Football Manager 2023 youth intake dates

    Football Manager 2023 Youth Intake Dates | Scouting for Newgens

    Football Manager 2023 Best Scouts

    Best Football Manager 2023 Scouts

    Guide to star ratings on Football Manager

    All you need to know about STAR RATINGS on Football Manager

    How to maximize tactical familiarity levels in Football Manager 2023

    How to Maximize Tactical Familiarity | FM23 Pre-Season Training Tips

    Football Manager 2022 Attacking Corner routines

    Football Manager 2022 Attacking Corner Routines; Short, In-swinging or Out-swinging corners in FM22?

    Counter player types using opposition instructions in Football Manager

    How to deal with certain player types using Opposition Instructions in Football Manager?

    Football Manager 2022 guide to opposition instructions

    How to use Opposition Instructions to limit opposing player threats

    Football Manager ultimate guide to youth development

    The Ultimate Youth Development Guide | How to develop players in Football Manager

    Using loans to improve youth development on Football Manager

    Using Loans to Improve Youth Development on Football Manager | FM Youth Development Guide – Part 3

    Football Manager 2022 Training Schedules megapack

    FM22 Training Schedules Megapack

    Football Manager guide to youth intake

    Youth Intake – An In-depth Guide on How Clubs Produce Newgens

    Ultimate guide to scouting in Football Manager 2023

    Scouting in Football Manager 2023 | The Definitive Guide

    Football Manager ultimate guide to youth development

    The Ultimate Youth Development Guide | How to develop players in Football Manager

    Using loans to improve youth development on Football Manager

    Using Loans to Improve Youth Development on Football Manager | FM Youth Development Guide – Part 3

    How to maximize tactical familiarity levels in Football Manager 2023

    How to Maximize Tactical Familiarity | FM23 Pre-Season Training Tips

  • Players
    1. Football Manager Wonderkids & Talents
    2. FM23 Wonderkids
    3. FM23 Cheap Wonderkids Bargains
    4. FM23 South American Wonderkids
    5. FM23 Bargains
    6. View All
    Football Manager 2023 NextGen Wonderkids Database - Find the Potential FM24 Wonderkids

    FM23 NextGen Wonderkids Database

    10 wonderkids to watch UEFA Under-17 European Championship 2023

    10 Future Wonderkid Stars YOU need to watch at the UEFA Under-17 European Championship

    FM23 Wonderkid Review João Rêgo - the next Joao Felix

    João Rêgo: The next João Felix | FM23 Wonderkids Reviews

    van Fresneda FM23 Spanish Wonderkid fullback

    Ivan Fresneda: The Spanish Wonderkid Fullback YOU NEED to sign on FM23

    Football Manager 2024 Lower League Clubs to Manage

    FM24 Lower League Clubs to Manage

    Football Manager 2024 clubs to manage | challenging save ideas for FM24

    Football Manager 2024 Teams to Manage: Challenging Save Ideas for FM24

    Football Manager 2024 new features | FM23 Save Games Compatibility

    How to Load FM23 Save Games in Football Manager 2024

    Football Manager 2024 Save Ideas

    Football Manager 2024 Save Ideas

    Football Manager 2024 Lower League Clubs to Manage

    FM24 Lower League Clubs to Manage

    Football Manager 2024 clubs to manage | challenging save ideas for FM24

    Football Manager 2024 Teams to Manage: Challenging Save Ideas for FM24

    Football Manager 2024 new features | FM23 Save Games Compatibility

    How to Load FM23 Save Games in Football Manager 2024

    Football Manager 2024 Save Ideas

    Football Manager 2024 Save Ideas

    Football Manager 2024 Lower League Clubs to Manage

    FM24 Lower League Clubs to Manage

    Football Manager 2024 clubs to manage | challenging save ideas for FM24

    Football Manager 2024 Teams to Manage: Challenging Save Ideas for FM24

    Football Manager 2024 new features | FM23 Save Games Compatibility

    How to Load FM23 Save Games in Football Manager 2024

    Football Manager 2024 Save Ideas

    Football Manager 2024 Save Ideas

    Football Manager 2024 Lower League Clubs to Manage

    FM24 Lower League Clubs to Manage

    Football Manager 2024 clubs to manage | challenging save ideas for FM24

    Football Manager 2024 Teams to Manage: Challenging Save Ideas for FM24

    Football Manager 2024 new features | FM23 Save Games Compatibility

    How to Load FM23 Save Games in Football Manager 2024

    Football Manager 2024 Save Ideas

    Football Manager 2024 Save Ideas

    Football Manager 2023 NextGen Wonderkids Database - Find the Potential FM24 Wonderkids

    FM23 NextGen Wonderkids Database

    10 wonderkids to watch UEFA Under-17 European Championship 2023

    10 Future Wonderkid Stars YOU need to watch at the UEFA Under-17 European Championship

    FM23 Wonderkid Review João Rêgo - the next Joao Felix

    João Rêgo: The next João Felix | FM23 Wonderkids Reviews

    van Fresneda FM23 Spanish Wonderkid fullback

    Ivan Fresneda: The Spanish Wonderkid Fullback YOU NEED to sign on FM23

  • Tactics
    • Goals Galore Tactics
    • FM23 Pep Guardiola’s Barcelona Tiki-Taka Tactics
    • FM22 Erik ten Hag Ajax Tactics
    • Johan Cruyff’s 3-4-3 Diamond Tactic
    • Lower League Tactical Masterclass
  • Databases
    • FM23 NextGen Database
    • FM23 Around the Globe League Megapack
    • FM23 Increase Realism Megapack
    • League Updates
      • FM23 English Lower Leagues Database
      • FM23 Scottish Non-League Database
      • FM23 Norwegian Lower League Database
    • Retro Databases by MadScientist
      • 1992-93 Retro Database for FM22
      • 1998/99 Database for FM23
  • More
    1. Graphics
    2. Skins
    3. Shortlists, Views & filters
    4. FM Videos
    5. View All
    Football Manager 2023 Standard real kits megapack

    Football Manager 2023 Standard Kits Megapack

    Football Manager 2023 Tato23 Dark skins

    Tato23 Skin v1 – The Cleanest Football Manager 2023 skin ever…

    TCM23

    Football Manager 2023 TCM23 Logopack

    Football Manager 2023 Priisek Retro base skin

    Football Manager 2023 Priisek Retro Skins | Download the FM23 Dark Skin Alternative

    Football Manager 2023 Tato23 Dark skins

    Tato23 Skin v1 – The Cleanest Football Manager 2023 skin ever…

    Football Manager 2023 Priisek Retro base skin

    Football Manager 2023 Priisek Retro Skins | Download the FM23 Dark Skin Alternative

    Football Manager 2022 Priisek Dark skin

    Football Manager 2022 Priisek Dark Skin (Green & Pro, Pro Instant Result)

    Football Manager 2020 TCS Dark skin

    Football Manager TCS 2020 Dark Skin Feat. Instant Result Button

    Football Manager 2023 Wonderkids & talents

    Football Manager 2023 Wonderkids | The Ultimate FM23 Wonderkids Shortlist

    Best Young Talents in Football Manager 2023

    Top 100 Best Young Talents in Football Manager 2023

    Football Manager 2023 Best Brazilian Wonderkids

    The Best Football Manager 2023 Brazilian Wonderkids

    Football Manager 2023 Cheap hidden Gems - best cheap signings in FM23

    Best Cheap Football Manager 2023 Hidden Gems

    Football Manager 2024 Save Ideas

    Football Manager 2024 Save Ideas

    FM23 Wonderkid Review João Rêgo - the next Joao Felix

    João Rêgo: The next João Felix | FM23 Wonderkids Reviews

    van Fresneda FM23 Spanish Wonderkid fullback

    Ivan Fresneda: The Spanish Wonderkid Fullback YOU NEED to sign on FM23

    Alfie Dorrington: The Spurs Big Hope! | FM23 Wonderkid Reviews

    Football Manager 2023 NextGen Wonderkids Database - Find the Potential FM24 Wonderkids

    FM23 NextGen Wonderkids Database

    Football Manager 2023 increase realism megapack

    FM23 Increase Realism Megapack by Daveincid

    Football Manager 2023 Around the Globe League megapack

    FM23 Around the Globe Leagues Megapack by DaveTheEditor

    1998/99 retro database for Football Manager 2023

    1998/99 Database for Football Manager 2023 by TheMadScientist

Passion4FMPassion4FM
Home - Football Manager Downloads & Resources - Player Attribute Analysis Spreadsheet by TheFFM
Football Manager Downloads & Resources

Player Attribute Analysis Spreadsheet by TheFFM

theffmtheffmUpdated:February 1, 20239 Mins Read
Facebook Twitter Reddit Telegram Pinterest WhatsApp Email
Football Manager player attribute analysis spreadsheet by TheFFM
Share
Facebook Twitter LinkedIn Pinterest Email

Do you find it hard to sign the right player for your tactics, or simply want to take squad analysis to the next level by identifying the players’ best role in Football Manager?

Thanks to Jenna aka The Female Football Manager we give you the chance to download one of the most essential tools for Football Manager – her attribute analysis spreadsheet!

The Football Manager Player Attribute Analysis Spreadsheet by TheFFM helps you to analyze your squad’s players, assess the squad depth or discover the player role suitability of any given players – both within your team, from player search or in your shortlist.

The Football Manager attribute analysis spreadsheet is updated for Football Manager 2023 and gives you an percentage value of a players most suited player role and duty. This tool is very easy to use and will help you in the long term planning of your squad by giving you an insight to weaknesses within your squad, either for specific positions or roles which is essential for your tactic, or analyze each player’s individual skills and how they ill rank within your team.

Read More | Comprehensive list of Football Manager 2023 Female Staff

About the Football Manager Attribute Analysis Spreadsheet & How to Use it

Imagine you inherit a squad with 50 plus players (first team players and reserves) in additional to youth players. The time it would take to get a complete overview of your club’s players; their strength and weaknesses both in terms of skills and their player role and duty suitability would take hours.

Perhaps you’re in a situation where you don’t even know what type of playing style and tactics you should use to get the best out of your players… The star rating of players suitability to play in a number of player roles are the same, three stars. But will be he best suited in the regista role or the deep-lying playmaker role?

Often it might be difficult to see where the player will perform the best – you need to take all the attributes into account and weight them up against each other.

Thankfully we got Football Manager ‘geeks’ in the community which takes everything a step further, not only helping themselves to save time but also everyone else who loves Football Manager, by making their work publicly available.

The player attribute analysis spreadsheet will help you analyze your squad and its players in a quick and easy way.

The spreadsheet contains five different major categories, the base, individual player overview, overall roles, top rated by role, overall positions and finally top rated by position.

Player Overview

The player overview gives you an option to analyze any player you’ve loaded into the spreadsheet to assess his player role suitability and/or main strengths with a drop-down menu. You will see all his technical, mental and physical attributes highlighted according to their levels.

Football Manager Attribute analysis spreadsheet player overview

Any attributes below 10 will be displayed in white. Player attributes between 11-15 will be displayed in blue, meanwhile any attributes over 16 will show with a green background.

You can then flick through different players within your squad to identity their highest percentage suitability to play in any of the player roles available in FM23, and you’ll get the ability to learn the top three positions and roles he’s best used in.

READ MORE | Download the Football Manager 2023 Custom Views Megapack

Overall Roles Rating

This sheet provides an overall breakdown of your squad, or the players you’ve loaded into the spreadsheet, broken down by their percentage rating to play in any roles within Football Manager.

Player roles overview - FFM Attribute Analysis spreadsheet

You’ll be able to digest whether your promising midfielder is best used as a winger or inside forward.. perhaps you’ll spot an opportunity to retraining him into another position and role, or you might discover he’s best utilized in a role you would never consider him playing…?!

It even takes into account the positional abilities by giving a higher rating for the best suited player role within the player’s natural positions.

Look at this screen as another opportunity to view player role suitability – based on percentage ratings which is more accurate than a star rating (as FM23 uses).

The overview of player roles is quite extensive but could come in handy – especially when recruiting players, as you can load your entire shortlist into the Attribute Analysis Spreadsheet.

Useful information

  • The yellow cell can be edited to any percentage based on your required levels. For instance, if you wish to highlight only the player roles with an above ratings of 70% – it will be easier to identify the players best role within each strata. Matching ratings will then be highlighted in green.
  • To the right of the yellow cell, you’ll get to see how much depth you got within a specific player role helping you to decide on future squad planning and what type of players you should recruit based on your use of player roles and duties within your tactics.
  • The ‘Suit Roles’ column describes how versatile a player is by counting the number of player roles he’s comfortable to play in or even be retrained in if young enough, based on your percentage minimum limit (selected in the yellow cell).

Top Rated by Role

If you are like me, you will probably find it easier to analyze the squad depth and player’s suitability to play in a role in a much easier and cleaner view.

The top rated by role screen addresses some of the same things as the squad depth report we’ve been accustomed to in Football Manager. Here you’ll get an insight to the top 5 players for each role, separated into sections based on the positional areas.

Top rated players by role - FFM Attribute Analysis spreadsheet

For some, this page is highly valuable when addressing long term squad planning.

You will clearly see if you have enough squad depth for the Trequartista role, and which players ranks the highest. If you’re weak in a role, it will show with a low percentage rating for the players listed in that player role.

Overall Positions

Overall positions - FFM Attribute Analysis spreadsheet

The overall position view provides you with a breakdown of the player’s positional abilities by combining an average calculation of each role with his preferred foot. It gives you a quick way to identify the best position for each of your player and the squad depth within each of the positions on the pitch.

Frankly, this sheet works in the same way as the Overall Roles tab. Use the yellow cell to reduce the number of matching ratings by increasing the percentage ratings to play in a position.

Top Rated by Position

The final sheet gives you a similar overview of the top 5 players per position as the top rated by role. Here you’ll get another ‘at a glance’ view of the top 5 rated players per position – given to you in a more user-friendly overview with all the different position on the pitch are split up in sections.


Useful Tips

A final tip before learning how to install the Football Manager Attribute Analysis Spreadsheet is to create a spreadsheet for each of your squads; first team, reserves and youth teams, as well as one for recruitment and potential signings.

By creating multiple spreadsheets you’ll be able to better compare your squads and get a better insight to potential signings player role suitability compared to the percentage ratings within your squad.


How to Install the Spreadsheet?

By downloading the Football Manager Attribute Spreadsheet updated for FM23 you will receive all the necessary files to identify suitable players for your squad, along with the ability to analyze your players abilities and their best role.

To install the Football Manager Player Attribute Analysis spreadsheet, you need to download the megapack and unzip the pack.

The megapack contains, the Excel spreadsheet and four different custom views.

  • Analysis Spreadsheet
  • FFM Attribute analysis 2023 (Squad View)
  • Search View
  • Scouted View
  • Shortlist View

Step 1 – Import the View

To get the custom views imported into Football Manager 2023 make sure you copy the files above to:

  1. PC: C:\Users[Your Windows Username]\Documents\Sports Interactive\Football Manager 2023\Views
    MacOS: Users[Your Mac Username]\Library\Application Support\Sports Interactive\Football Manager 2023\Views
  2. Open Football Manager 2023
  3. Click Squad > Custom > Import View..
  4. Load FFM Attribute Analysis 2023.fmf
Football Manager Attribute analysis squad view

The same method applies for the rest of the custom views. For instance, go to Scouting > Players > Players in Range > Custom and Import View to load the Scouted View, or go to your shortlist to import the specific Shortlist View.

2. Print Screen

print web pages in Football Manager

Once loaded the preferred custom view, press CTRL + P or click FM > Print Screen

Choose to select print as Web Page. Now you only need to name the file and save the specific web page in your preferred location. Remember the location of this file and open it.

Copy the content from it to the spreadsheet by highlighting all the data (except the top heading of attributes and SIGames link at the bottom) then press CTRL + C.

3. Open the FFMAttributeAnalysis 2023 Spreedsheet

Open to the FFMAttributeAnalysis spreadsheet in Excel and select cell B3 on the ‘Base’ sheet.

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

Voila! The setup is complete and the spreadsheet will be populated with data!

NB! Please follow the instructions within the readme installation guide to ensure you’ve completed the steps in the correct order. We won’t do support or help you solve problems that may arise with this. Instead we recommend to follow the installation guide to the point and contact the Female Football Manager via her website or Twitter page. Links can be found in Credits.

 

For further screenshots of how this work, please check out the FFM website.

Download Football Manager Attribute Spreadsheet

Take squad analysis to the next level with one of the most essential Football Manager tools created by TheFFM. Discover your squad player’s player role suitability and find the best roles for any potential signings.

Download
Credits

Thanks to Jenna aka The Female Football Manager for giving us permission to re-distribute this amazing work to our community.

Website: https://theffm.co.uk

Twitter: TheFFM_


Your content at Passion4FM?

We are honored to submit more user generated content at Passion4FM.com. If you’re a Football Manager content creator, feel free to reach out to us if you think you got what it takes to show case your content at Passion4FM.

Become a Passion4FM Content Creator and bring your passion for Football Manager to our worldwide audience. register today and be able to submit your videos, blog posts and other tips and tricks to the Passion4FM Community.

Apply Now
FM22 FM23 hints and tips Player Analysis Player Attributes Player Roles spreadsheet Squad Analysis
Previous ArticleThe Ultimate Youth Development Guide | How to develop players in Football Manager
Next Article The Unbeatable Football Manager 2023 Rising Dead Tactic by FM DNA
theffm

You might also like

Football Manager 2023 increase realism megapack

FM23 Increase Realism Megapack by Daveincid

Football Manager 2023 Around the Globe League megapack

FM23 Around the Globe Leagues Megapack by DaveTheEditor

Football Manager 2023 Wonderkids & talents

Football Manager 2023 Wonderkids | The Ultimate FM23 Wonderkids Shortlist

1998/99 retro database for Football Manager 2023

1998/99 Database for Football Manager 2023 by TheMadScientist

Add A Comment

Leave A Reply Cancel Reply

You must be logged in to post a comment.

Trending

Football Manager 2024 clubs to manage | challenging save ideas for FM24

Football Manager 2024 Teams to Manage: Challenging Save Ideas for FM24

1998/99 retro database for Football Manager 2023

1998/99 Database for Football Manager 2023 by TheMadScientist

Football Manager 2023 Pep Guardiola Man city tactics 3-2-4-1 formation recreated in FM23

Pep Guardiola Man City Tactics 22/23 | NEW 3-2-4-1 Formation Recreated in Football Manager 2023

Football Manager 2023 Wonderkids & talents

Football Manager 2023 Wonderkids | The Ultimate FM23 Wonderkids Shortlist

Football Manager 2023 Cheap wonderkids bargains winter transfer update

More Cheap Wonderkids Bargains | FM23 Winter Transfer Update

Football Manager 2023 Around the Globe League megapack

FM23 Around the Globe Leagues Megapack by DaveTheEditor

Best Wonderkids

Football Manager 2023 NextGen Wonderkids Database - Find the Potential FM24 Wonderkids

FM23 NextGen Wonderkids Database

10 Future Wonderkid Stars YOU need to watch at the UEFA Under-17 European Championship

João Rêgo: The next João Felix | FM23 Wonderkids Reviews

More Cheap Wonderkids Bargains | FM23 Winter Transfer Update

Latest Tactics

Football Manager 2023 Pep Guardiola Man city tactics 3-2-4-1 formation recreated in FM23
Pep Guardiola Man City Tactics 22/23 | NEW 3-2-4-1 Formation Recreated in Football Manager 2023
Football Manager 2023 Tactic 3-4-3 King Kong

The Special One Football Manager 2023 Tactic 3-4-3 King Kong by FM DNA

Football Manager 2023 Tactic Jurassic Park 4-1-3-2 counter-attack

Title winning 4-1-3-2 Football Manager 2023 Tactic Jurassic Park by FM DNA

FM23 4-3-3 Tactic F84 Broken Beast

High xG Overachieving 4-3-3 FM23 Tactic – F84 Broken Beast

About
About
  • About Passion4FM
  • Get in Touch
  • Write for Us
  • Become a Partner
  • Login
Facebook X (Twitter) Instagram YouTube
Resource Center
  • FM Essentials
  • Basic Learning
  • Guides
  • Tactics
  • Training
  • Scouting
  • Downloads
  • Graphics
  • Databases
  • Wonderkids
  • Staff
  • Club to Manage
Community
  • FM Videos
  • Let's Play Series
  • Join Discord
PARTNERS & CONTRIBUTORS
  • FM DNA
  • FranklyFM84
  • Priisek
Recent Posts
  • FM24 Lower League Clubs to Manage
  • Football Manager 2024 Teams to Manage: Challenging Save Ideas for FM24
  • How to Load FM23 Save Games in Football Manager 2024
  • Football Manager 2024 Save Ideas
  • Football Manager 2024 Mobile – Coming Exclusively to Netflix Games
  • Football Manager 2024 Release Date, New Features, Early Beta Access & More
Facebook X (Twitter) Instagram YouTube Discord
  • Terms of Use
  • Privacy Policy
  • Cookie Policy
  • Disclaimer
  • Sitemap
Copyright © 2023 Passion4FM Media | All Rights Reserved.

SEGA and the SEGA logo are either registered trademarks or trademarks of SEGA Corporation or its affiliates. SEGA is registered in the U.S. Patent and Trademark Office. Football Manager, the Football Manager logo, Sports Interactive and the Sports Interactive logo are either registered trademarks or trademarks of Sports Interactive Limited. All other company names, brand names and logos are property of their respective owners.

Type above and press Enter to search. Press Esc to cancel.