Excel table to yaml: each row (except header) as individual notes. Column headers as the notes' properties

[chubikorn]

What I’m trying to do

I have the following data on a sheet in excel:

Is there a plug-in or converter/script available that can import or extract the data such that:

1. A note gets created based on each row (other than the header) – So three individual notes, each with its own unique title, “Person 1”, “Person 2”, and “Person 3”.

2. Each of the above notes have 2 text properties, based on the header – property1 (all lowercase with no space between “property” and “1”), and property2. These properties will then be automatically populated based on the corresponding table data.

So the final results will be:

NOTE 1:
Note name: Person 1
1st property is a text property called “property1” and the field says “A”
2nd property is a text property called “property2” and the field says “D”

NOTE 2:
Note name: Person 2
1st property is a text property called “property1” and the field says “B”
2nd property is a text property called “property2” and the field says “E”

NOTE 3:
Note name: Person 3
1st property is a text property called “property1” and the field says “C”
2nd property is a text property called “property2” and the field says “F”

Things I have tried

There were two results I came across in the forum but their solutions were not applicable to this scenario. One of them may have been, but it involved running a python script, which at the moment I am not familiar with and do not have the time to learn.

Thank you!