Exactly. The thing I'm talking about is necessarily a semi-manual process (data exploration, usually prior to migrating data from one system to another).

In the example you give, when you've done all the exploration you need, there's a program interpreting that CSV that ensures the location column values are strings. At least, that's how I do it!