How can I output metadata with xlsx vs csv?

I want to know if there is possibility that metadata file output in the workflow to be in xlsx instead of csv.

Can you clarify what you mean by “metadata file output”? There is no such thing. The Metadata File Management task can save the metadata structure into a binary format (which is neither CSV nor XLSX). You can also use a simple java script task to save to XML (which can be opened with Excel):

var myMeta = new ActiveXObject("Metadatalib.Metafile");
myMeta.LoadFromFile(Watch.GetMetadataFileName());
myMeta.Export("C:\\tests\\test.meta",0);

Is that what you’re looking to do?