I have done this quite a bit to get a large number of tiddlers created from an external file. Essentially, you want your data in a spreadsheet.
The steps I use are variations on the ‘method’ below.
=======================
You need to have some column headers in a Calc/Excel file, and that one of the column headers is “title” and one column header is “text” (all headers need to be lower case, and “tags” would be a good one to include).
Save the file as a CSV. Then, run your file through a CSV/XLMS → JSON converter. This should turn your file (rows) into an “array of objects” with each object having at least a “title” property. You can then drag and drop this JSON file into vanilla TW5 and it should import as 1-tiddler-per-object.
Here is a converter that would work for you: CSV to JSON Converter | Online Tool
For example run this small sample CSV through the converter:
title,tags,text
One,test,Question One?
Two,test,Question Two?
Three,test,Question Three?
Which renders as:
[{
“title”: “One”,
“tags”: “test”,
“text”: “Question One?”
},{
“title”: “Two”,
“tags”: “test”,
“text”: “Question Two?”
},{
“title”: “Three”,
“tags”: “test”,
“text”: “Question Three?”
}
]
Then, simply drag and drop this Json file into a Tiddlywiki. If it is a file with this correct format, each object will become a separate (regular) tiddler.
I actually find this a more flexible and easier/quicker process than the xlsx-utils plugin.