I’m trying to import an CSV URL into a Google Sheet so I can make a DataStudio dashboard. Unfortunately the import isn’t formatted right. Numbers are formatted as textfields and this isn’t something I can change easily because of the way the numbers are imported. They show up in Google Sheet like this:
Any one has a clue how I can import is so only the numbers are in the sheet not the ? characters splitting every individual number?