how can I make the logginig in the exported csv datasheet every second ?
While that's not possible via the CSV export, if you have some skills and a SBC lying around, you can log the values every second.
An example would be a simple bashscript that gets the data from the shelly every second and appends to a csv file:
Bash
#!/bin/bash
JQS='"\(.total_act_power),\(.a_act_power),\(.b_act_power),\(.c_act_power)"'
while true; do
sleep 1 &
values=$(curl -sS 'http://192.168.7.7/rpc/EM.GetStatus?id=0' | jq -r "$JQS")
echo "$(date +%s),$values" >> log.csv
wait
done
There is various other ways to do this of course.
You can probably do it with python on windows, using different API endpoints on the shelly, various things.