Excel to Json, or to xml for easy autocomplete, how to generate?

Question

JavaScript

Friends, there is such a jkware plugin easyautocomplete.com/guide that
can take data from json and xml files. So the question arises, how to make such a file from an Excel spreadsheet? To make the structure clear to the easy autocomplete plugin. As I understand it, some kind of macro could do this, but I have never done this in Excel. If there is an instruction on how to make such a macro, then please share, I don’t even know how to google it. If there are any other solutions for this problem, I will also be glad to know about them.

Answer 1

It all depends on the frequency of the task and your capabilities.
For one time, I would convert by hand.
If you need to convert frequently or if the table is over 1000 rows then you have options
How to do it already depends on the language. I've worked quite successfully with a table through Node.js, for example. I think this is also possible in PHP, Ruby, Python. In short, there are many options, choose for yourself.
PS https://shancarter.github.io/mr-data-converter/ there is also such a converter, you can try using it
PPS You can generate markup on an adjacent sheet and simply substitute the data. Probably the easiest option.