Import structure from Excel

Hello,
I’ve read many topics on this, but found varying answers. I have a huge list of variables (in a txt document) and I want to copy it into GDevelop.

From what I understand, I need to:

  1. Create the structure in Excel.
  2. Convert it to JSON.
  3. Import it into GDevelop.

My only issue is with step 1. How should the table be set up to have a structure like:
[Structure][Substructures][Strings of each structure]

For example, I might have:
Structure Name
-----> Substructure1
-----------> String1
-----------> String2
-----> Substructure2
-----------> String
-----------> String2

I also tried manually editing the project’s JSON file as suggested, but there are issues: some structures have values created by GDevelop that can’t be made up, like: “persistentUuid”: “38bb30fb-4f3f-4221-946a-1a0d37fa2212”

Thanks so much in advance!

For your table, start with columns for each level: Structure Name, Substructure, and String. Each row should represent a unique string under its corresponding substructure. For example, if you have “Structure A” with “Substructure 1” and its strings, list them out like this:

Structure A | Substructure 1 | String 1
Structure A | Substructure 1 | String 2
Structure A | Substructure 2 | String 1
Structure A | Substructure 2 | String 2
Using advanced excel formulas & functions examples can help with organizing and converting this to JSON format later. I used some of those functions when I was prepping my data, and it made the whole process smoother.

1 Like

Thank you, you were very clear and detailed. I’ve currently chosen a different solution, but it will definitely be useful to me in the future!