trim data on import in google sheets code example Example: trim data on import in google sheets =ARRAYFORMULA(TRIM(IMPORTDATA("https://data.com/table.csv")))