I agree, importing a geolocation column is awkward.
This is how you can do it:
- Import the file without doing anything special → you’ll end up with geodata in a multiple select column
- Add a formula column and add the function {<column_name>} where <column_name> is the name of the column storing the GPS data. → the column shows the values a comma-separated text
- Add a geolocation column
- Copy and past the content from the formula column to the new geolocation column
Hope this works for you. We’ll improve the import in the future.