How do you import transactions into Odoo in excel/csv format, which include analytical fields?

Odoo is quite different from what I've seen before, as there are nested lines on the import files, and the analytics must be written in JSON { ID, allocation percentage}.

Do you have any formulas or advices that would enable me to "convert" my excel file of entries into a format accepted by Odoo?

Thank you for your help,