can csv files have formulas?
The CSV format does not support formulas. It is a plain text only format. Surprised me when I tried it, but Excel will keep the formula. You can import formula's into excel via a text file using comma separated values.