I am new to using google sheets. I have used them on a basic level in the past to organize family trips, etc. I am working with a company that is using google sheets to cleanse data. I have always used ms excel. Is sheets as robust for this - can you use power query? Would you recommend taking the data from sheets and saving to excel then use excel to cleanse?
Also I have always exported ms excel into mysql after cleansing. Would I do the same with google sheets?
Thanks in advance.