When you import a spreadsheet from Excel or Google Sheets, you cannot import data from that sheet into a country column. If you have a column labelled ‘Nationality’ in your spreadsheet, it has to be imported to a text column in Monday.com.
From there, if you want the data in a country column, you have to manually copy it over, which is not a good use of time. Please could you add support for this column type so that we can either import directly into it from Excel/Sheets, or change a Text column within Monday.com to a Country column?
The latter option should be straightforward, as it would be the same process as changing a Text column to an Email column (another column type with specific format/input requirements), and this function already exists.