I'm planning on making a game with tons of dialogues, so I'm using .json files to put all the text in the game. I'm also planning to:
1) work with several different narrative designers;
2) translate all the text to several different languages;
3) make a "make-your-own-quest" style of editor, where any player can make their own storyline by editing the lines in .json.
But the narrative designers, translators and (especially) players do not have Construct 3 and it's pretty much impossible to try logically changing .json as it is:
(spreadsheet as I see it in Construct 3)
(json file I get if try to download it)
The "easy" solution to that problem is just selecting all the content inside the Construct 3 json editor spreadsheet and pressing CTRL+C, CTRL+V to paste content inside the google spreadsheets. It does work. But there are several errors with that method. For example, after I will receive new dialogues in google spreadsheets - I need to manually CTRL+C, CTRL+V them inside of Construct 3 engine's json file editor. So it can help if I'm with narrative designers and translators but generic player will not be able to do that on his own, so I'd have to abandon the idea to allow players to make their own content by simply changing .json. Also this way is a bit tedious, since even a small error while selecting / copying / pasting (and backwards) can result in a game being umplayable.
Is there a way to easily convert json table that Construct 3 generates into XLS (microsoft office) format and backwards (from XLS into json that Construct 3 will understand)?
I've tried several different automated online JSON->XLS converters but they all change the initial json's Construct 3 spreadsheet into something barely recognisable (structurully-wise).
If there is no option to do that - I would like to suggest implementing such a converter as a possible next feature inside Construct 3: Import XLS as a json / export json as a XLS. I know devs might have more important things to do but I'm sure I'm not the only one struggling with it. Also, I'm not a programmer myself but I think it shouldn't be too difficult to implement, since the original json file editor in Construct 3 already pretty much looks like a table from windows excel.
Thanks.