27 incredibly useful things you didn’t know Google Sheets could do
is.gd/0IlSsZ
Live data: =IMPORTHTML(“sitelink”,”table”,1)
Clean up: =ArrayFormula(TRIM(A2:A50))
Tiny charts! =SPARKLINE(E12:E23,{“charttype”,”column”})
My fav: =GOOGLETRANSLATE(A1,”auto”,”en”)
#pro