I have around 12 sheets in a Google Spreadsheets document where I have a bunch of formulas. I'd like to do one of two things:
I would love to just export these as CSVs. I don't want the values though, I want the actual formulas. I.e. instead of the cell value being
3
, I would like it to be=B2+B4
. I don't mind manually downloading each.If that's not possible, is there some way to convert all the the formula cells to the formula itself?
I know that I can just put quotes around the formulas and they will become text strings which I can then export to CSV. The issue is, that's a lot of cells ... and I don't want to have to do that for all the cells.
Can you folks help me out with this?