Hi Mans,
Starting with a spreadsheet - data in colums, no headers - put a blank
column inbetween each, starting at the beginning and, in the top cell, add
little snippets like this...
{ "text": "
so that, as a whole, a single line of the spreadsheet reads as a valid json
entry, with a comma at the end, and 'fill' down the sheet, so it looks like
this...
<https://lh3.googleusercontent.com/-r6SDMepHHYc/VV_wEguePqI/AAAAAAAAA_4/7SVc-hDx8tQ/s1600/Screen%2BShot%2B2015-05-23%2Bat%2B1.03.23%2Bpm.png>
Then copy and paste the columns into a friendly text editor (not a
word-processor). When I do it I get some kind of 'tab' character that I
need to globally remove (search and replace all). I've highlighted it in
the top left of this screenshot.
<https://lh3.googleusercontent.com/-QjPOY0TnAtE/VV_xJNeyrQI/AAAAAAAABAA/fY9NcKgSZtM/s1600/Screen%2BShot%2B2015-05-23%2Bat%2B1.08.06%2Bpm.png>
Then I add opening and closing square brackets and save it as .json
<https://lh3.googleusercontent.com/-79r35DvmyBQ/VV_xVzPCVGI/AAAAAAAABAI/UpgR6pCPHqM/s1600/Screen%2BShot%2B2015-05-23%2Bat%2B1.08.34%2Bpm.png>
Drag it into TW and it appears like a regular import.
<https://lh3.googleusercontent.com/-eFuxd_WxrIA/VV_xn2APjSI/AAAAAAAABAQ/oKPJ7fFkhTY/s1600/Screen%2BShot%2B2015-05-23%2Bat%2B1.18.01%2Bpm.png>
NB: if there's anything wrong with your json, you get a big red warning but
nothing breaks - but use a backup, obviously.
Regards,
Richard
--
You received this message because you are subscribed to the Google Groups
"TiddlyWiki" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/tiddlywiki.
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/96128f98-02f1-4500-a45c-12c41d4af110%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
