Just remember, if you are going to be saving your data as CSV file at the end of your editing session, don't waste your time with formatting or trying to save formulas to be used again. CSV is plain text
, which means all your hard work will straight up disappear
once it's saved as CSV format. As nice as your formatted table and highlighting look, they won't do you any good here!
And when you're done tidying up your dataset, just remember to save as .CSV (comma delimited) format, with UTF-8 encoding