Instead of using CSV, there is also a lesser used format tsv, tab spaced variables.) Exporting as tsv and then opening in a text editor saves the search and replace part. Andrew -- Sent with K-9 Mail On 21 December 2022 07:45:47 GMT, Tarquin Wilton-Jones via Therion <therion@speleo.sk> wrote:

Step 1 would be to get the data out of Excel and into a text-based format. Axel suggests copy & paste, which works very well. Alternatively, in Excel, use "Save as" to save it as a CSV file. Then open the CSV file in a text editor that has a find-&-replace function, and replace all commas with spaces. Save the file as something.th

It's entirely up to you which approach you would prefer.

Step 2 is to add in the basic Therion wrapper that Axel suggested.

Cheers, Tarquin

...

u have to wrap it around some basic Therion code (survey/ centerline). As ure question suggest u have not worked before with Therion u might want to have a look at one of the dokumentations listet here: https://therion.speleo.sk/wiki/doku.php u want something like:   survey 1     centerline       date jjjj.mm.dd       data normal from to length compass clino left right up down       1.1  1.2  7.74  331  3.7  1.9  6.4  2  0       (copy&paste)       ...     endcenterline   endsurvey in a text file saved as *.th as stated before, pls have a look at the dokumentation. There are plenty listed: e.g. a step by step one for cavers: https://therion.speleo.sk/wiki/tfc   Axel

---

Therion mailing list Therion@speleo.sk https://mailman.speleo.sk/listinfo/therion

i was thinking - maybe someone has some script that does this conversion?

Possibly there is, but there is not really a need to do so for simple data sets: 1. in Excel, save-as "Text (tab-delimited) (*.txt)", call it foo.th 2. edit it in a text editor 3. add this at the start: survey foo centreline date yyyy.mm.dd data normal from to length compass clino left right up down and this at the end: endcentreline endsurvey That's it. Done. Not really enough steps to need a script. If your spreadsheet has data in this order, you could do it with step 1 only: survey|foo centreline date|yyyy.mm.dd data|normal|from|to|length|compass|clino|left|right|up|down 1.1|1.2|7.74|331|3.7|1.9|6.4|2|0 endcentreline endsurvey If you have a *lot* of files, then yes, maybe you could create a macro to do it, but the exact information needed would depend on how your spreadsheet is arranged, so the macro would need to be created specifically for your spreadsheets, and you could not use someone else's script. It would depend on the order of your data, and where the date is written in the spreadsheet, what format the date is written in the spreadsheet, and where the survey name is written in the spreadsheet. Your macro would need to rearrange the file to match that format given above, then save the file as a TSV. An Excel macro could do all of that, and you could probably record it, without needing any programming/scripting ability. (Except maybe you might need to manually put the date in the right format.)