The previous link was my final version for FIFA 21. I've decided to revisit this with the release of 22 and have two new tables. It's mostly the same (because FIFA is always the same :P) but I've made some adjustments. The first maintains the same basic stat formulas as 21 with minor changes;

https://docs.google.com/spreadsheets/d/1lvYXt3V7plg6DC7JARLMHwuNp8i9dcH2mDoT1Bhfl0o/edit?usp=sharing

The second table is for those who believe the first one creates too much disparity between the top players/teams and mid-tier ones. Middling players will generally be a few levels higher in this version.

https://docs.google.com/spreadsheets/d/1GcUsBju9QyNAkO2TKrSPxg9TOvJ-6pArhLGyQuIKyAQ/edit?usp=sharing

Here's the table for FIFA 23. Messi has been nerfed somewhat between games, so the level 100 benchmark is now De Bruyne/Mbappe. There's also a relatively high difference now between the best players and the rest, so I may have to test these numbers on a mid-low table premier league club and see if I need to provide an alt formula version again.

https://docs.google.com/spreadsheets/d/1i0iKZRqSPdaAfc1WBbcNVvde-EY-aAMV8vix6qONeFQ/edit?usp=sharing

For FC 24, I've decided on a significant overhaul in the way I do ratings. The attributes now use a scale similar to the alt version of 22, and specialisations have been reduced to be more in line with how randomly generated squads pan out. The biggest change however is skills, as no more player types mean skills are only limited by position, and even these limitations have been loosened; Goalkeepers can now have Long Pass when they couldn't before, for example.

https://docs.google.com/spreadsheets/d/1mvBCj94lTK3R9YozSLJkKfsDEf8KkiIcPegASd90Fe0/edit?usp=sharing

how to use it?

Originally posted by bpalex:

how to use it?

To get the ability to edit the fields you need to edit, you'll have to click the file sub-menu and either make a copy on sheets for yourself, or download it for use on your own spreadsheet program.

SoFIFA's player database (full ratings for EA FC, updated regularly) is here; https://sofifa.com/

There may be a 2.0 sheet later if I can automate certain aspects of the data entry process. Right now it's very difficult to complete a nation in a timely fashion and I have to solve that if this converter is to see widespread use.

To better understand the process of how this is done, please record a video guide on using your converter

Originally posted by bpalex:

To better understand the process of how this is done, please record a video guide on using your converter

I don't think a video guide is necessary, but it's clear that my original phrasing of certain terms and steps was not clear enough. I have updated the sheet. It is mechanically identical but goes into more detail regarding how to get the necessary numbers to generate attributes and also work through certain processes.

Skill assignment has now been classed as an optional extra, so for those looking to build rosters quicker, you can ignore it and just assign any skills you like, only sticking to the total skill level limit per player.

I am also going to bring out a V2 of this sheet in the hopes of improving attributes (not so many control main players, better balance between accuracy and defence in lower leagues...)

FC 24 conversion table version 2!

https://docs.google.com/spreadsheets/d/1MlEM5MALC_QPEImNWgy9fRuVtVJnqDZmtwR_1_dszco/edit?usp=sharing

Improvements;

- Rebalanced skill priority based on practical results, + simplified method where you choose player skills proposed.
- Improved attribute spreads, resulting in not so many control main players, and better strikers in lower league play.
- "Add an extra" implemented. This feature ensures that two players that have the same FTG level will also have the same total attributes once this modifier is applied.
- Streamlined input and output process, with a single FC ratings field that's equally compatible for outfielders and goalkeepers, and Skill Levels placed in a more front and centre location to negate unnecessary scrolling.