If they are numbers to begin with (not "numbers"), you can just import the csv and you'll get the expected result out of the box.
In the end things are just 1s and 0s, but that doesn't mean we only ever do binary operations on data at the abstraction layer we humans operate, so saying it's just 0s and 1s or just strings is not very smart.
unquoted input:
0, 10, "Text", "123"
unambiguous output:
(Num) 0, (Num) 10, (Text) Text, (Text) 123
quoted input:
"0", "10", "Text", "123"
output :
(Num) 0, (Num) 10, (Text) Text, (Num) 123Unquoted input should look like this:
unquoted input: 0,10,Text,123
Note the absence of spaces as well. Not sure what flavour of CSV you are using, but there usually aren't spaces after the delimiter.