The TBW is an XML file you can make a copy of and pull into Excel. It's less than ideal though as often the calcs use different internal references.

I've thought about doing a macro or lookup thing to try to rebuild them properly.

You can write an XML parser or you are free to use the Java application I wrote to extract Calculated fields from a TWB ,,,Also keep in mind a TWBX is just a .zip file so rename a twbx to zip to be able to extract the twb from a twbx

GitHub - pkumar5/Tableau-Parser

I tried your XML Parser and it works great and is very helpful already. I'm not a programmer myself and am wondering if it is possible to get the output in one line, instead of multiple lines.

So current out put is like:

----------------------------------------------------------------------------------------------------------------

2) Name = CYTD Price Units | Role = CYTD Price Units | ID = [Calculation_12893736352719378347] | Datatype = real

[Flag CYTD MP] * [Price Units]

----------------------------------------------------------------------------------------------------------------

is it possible to have it like:

2) Name = CYTD Price Units | Role = CYTD Price Units | ID = [Calculation_12893736352719378347] Datatype = real | [Flag CYTD MP] * [Price Units

or even without  the leading line number 2)

I have built a shiny app to parse the .twb file and visualise the dependency between calculated fields with the exportable list of variables (performance depend on traffic): https://tony-yanjun.shinyapps.io/Tableau_zen_parser/

The code is here: https://github.com/33Vito/Tableau_Zen_Parser

Feedbacks are most welcome!