Organising multiple senses in a spreadsheet for FLEx import via Standard Format Marker (SFM)

This is my personal note (see the PDF file) on organising fields for multiple senses/glosses of a lexeme in a spreadsheet before being converted into the Standard Format Marker (SFM) (using Sheet Swiper), which is the input basis into the FieldWorks – Language Explorer (FLEx).

I put this note here for others to use and/or comment if they find a better solution.

In addition to the note, for the hope of reproducibility, I also put:

1. The original spreadsheet (format3.xls)
2. The resulting .db file after converting the spreadsheet into SFM using Sheet Swiper (format3.db), and
3. The backup copy of the FLEx with these mini-entries (format1-test 2023-08-31 1040)

Readers who are not yet familiar with FLEx and SFM are encouraged to read further the Technical notes on SFM database import. I am also grateful for a few posts in the FLEx Google groups under the search term "spreadsheet" that show how to organise lexical data for SFM import in the spreadsheet (though I haven't found any discussion about managing multiple senses of a lexical entry in the spreadsheet, hence this note).

Feedback and comments are very welcome!