FM23 | How to extract clubs/cities with UIDs to Excel file?

[geekey]

hey all.

i'd love to export cities and/or clubs from specific country/nation to Excel file. How i can do that? Is it even possible?

Thanks for help!

[Wolf_pd]

Exporting data to Excel isn't possible.

[geekey]

Thanks for the answer @Wolf_pd

Is it possible to export mentioned data to any file? for example .csv or anything similar?

[Wolf_pd]

Only changed data can be exported to XML, but that is then in a very specific format that is in use for FM and not something that is easily formatted into something else.

[geekey]

Thank you. So, if i understand it well, i need to manually check existance of every city/club in editor to avoid duplicates when creating leagues, right?

[Wolf_pd]

32 minutes ago, geekey said:

Thank you. So, if i understand it well, i need to manually check existance of every city/club in editor to avoid duplicates when creating leagues, right?

Yes

[geekey]

Thanks again. Last question: what about converting .xml to .csv or .xls? Normally it is possible. Can i create .xml for cities/clubs from main FM23 database and convert it somehow to .csv/.xls?

[Wolf_pd]

If you are well versed with XML and know how to convert them to other formats, you will probably be able to do so.