Link to home
Create AccountLog in
Avatar of Patricia Timm
Patricia TimmFlag for United States of America

asked on

cleansing data with google sheets or ms excel?

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.
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
You should also look at Open Refine.  It originated with Google.
Avatar of Patricia Timm

ASKER

Thanks