The list was compiled from 5,500 respondents to a survey by hotel chain Travelodge.
First was Edinburgh, then Bath, Liverpool, Belfast, Glasgow, Oxford, London, Cardiff, York and Cambridge.
Newcastle-upon-Tyne was the friendliest city, followed by Liverpool and Manchester.
London was the least friendly city followed by Birmingham and Glasgow.
Finally, the city where the locals had the sexiest accent was Edinburgh.
Well done Edinburgh.