Neither of the use cases you mention are currently supported by VizAlerts, the enhancements are both described in Export CSV to Excel XLSX · Issue #75 · tableau/VizAlerts · GitHub, if you have extra comments to add there please do. Also if you or someone on your team has some Python coding experience then their contributions would be welcome as well!
Currently VizAlerts uses Tableau's CSV download that doesn't keep the crosstab format, so formatting CSVs would require building out functionality to identify how the CSV should be laid out, whether that's using the XML from the TWB or a separate configuration file is something that is still to be determined.
Also, a question I make sure to ask *every* time someone wants a data dump from Tableau is "What are you doing with that?" and then when they given an answer asking the question again until I get to something that is a "real world" action like making a phone call, sending an email, text message, or Slack message, changing control parameters for hardware or software, etc. There are often cases where the answer is something like "I load the data in Excel, do some filtering and sorting so I can get number X that I then type into system Y." and Tableau could be used to do the filtering & sorting and generate the number X and skip the whole Excel piece.
Did this answer your question, Clair? If so, could you please mark the answer as correct? Thanks!