[StefanM]

Originally Posted by Jiaz

Excel informs you that JSON value is a List or Record, the type and you have to query which information of that value you're intersted in...

Thanks for the enlightenment!

I checked settings.json and found the correct strings there. So, another 'problem' created by Excel's 'features'.

There are many examples for unwanted 'conversion' etc.

E.g. I want to open a csv file which contains Corona figures for age groups:

0-4
5-9
10-14
15-19
...

What does Excel do?

0-4
05. Sep
Oct 14
15-19
...

Haven't found a way to turn these automatic 'helpers' off.
If you format all columns to Text, Excel won't remember...

Same with the tsv settings file, created by mgpai's script:
Doubleclicking for opening it in Excel results in corruption of some strings.
So, you have to import it, select UTF-8,...

Also haven't found a way to tell Excel that I want to open all files as UTF-8.


Question 1:
You seem to be pretty familiar with Excel, too.
Any ideas, e.g. how to let Excel treat all *.txt, *.csv, *.tsv, ... as UTF-8?

Question 2:
If you format all columns to Text, Excel won't remember...
Do you know how to tell Excel to use text formatting as default? This would solve some problems such as my age group example.

Then I could open csv files from RKI using doubleclick instead of time consuming import of each and every file...