Format is not important here. As long as the houses are nicely coloured & numbered and I can get the data I need on the data tab.
All in JSON, XML or csv or any other format would be Ok.
The data tab contains exactly the same information that is also rendered on the map, and requires XML or JSON format. Once you switch to CSV, you won’t get anything on the map. Basically what you’re asking for is impossible with overpass turbo. You need to somehow create your own tool for it.
You can just delete the three out:'s from lines 11,13 and 15, and insert one after your 4th out count; in line 27. That should do the trick.
P.S. I’ve cleaned up your query a bit to avoid getting the ways twice from the overpass-server, and filter for the exact streetname. This is the result I ended up with: http://overpass-turbo.eu/s/HEf You might want to take a look at it for inspiration.
I don’t think that is possible using overpass-turbo.eu. At least I wouldn’t know how to do it.
You could try to run Overpass Turbo on your own computer with a modified source code. The source code can be found here: https://github.com/tyrasd/overpass-turbo