ok, I'll talk you through the basics.
1. Create a new player in the editor with just the basic fields (name, surname dob etc) and (Make a note of the UNIQUE ID the player is given) SEE IMAGE ONE
2. export it into an XML. File>Export
3. Open it and cut and paste everything from <list id="db_changes"> to the next </list> it into Word (Save as player template). SEE IMAGE TWO
4. You can ignore most of the code. You can see where we have <string id="new value" value="Shrew"/> for the first record the field we have changed. I've used your name here new value will always be the 'field' from the excel sheet we will set up
5. Open excel, and make the columns the values you want to change starting with Unique ID. Save As. SEE IMAGE THREE
Some of the values are straight forward text boxes, some you will have to look up clubs IDs, City IDs etc to link the player to that club (we can cover that later)
6. This will be the database we use for the word doc, open it back up and start the mail merge wizard, use the word doc as the letter, and the excel sheet as the list. SEE IMAGE FOUR
7. You now need to match the fields up in the 'letter'
<large id="db_unique_id" value="606306713973603730"/>
will always become
<large id="db_unique_id" value="«Unique_ID»"/>
I've used your name so you can put first name field where Shrew is etc and you should end up with image 5.
8. DONT Run the wizard, go to finish and merge, edit individual documents and it will open a new window with all the info for each unique id and give you this for each 'person' in the excel sheet. Copy and paste it back into the original xml between the <list id="db_changes"> and </list> as before
9. Save the xml and import in the editor, you should see database changes made.
This is the very basic I can get into the details and show you more when you have it, this isn't easy to really explain. I might do a yt tutorial if i can find some capture gear. Have a go, DM me issues and questions and then i'll dive into the property codes and other things you might need to do full player information (attributes, hair etc)