Find the following Excel file which contains all public details about world countries, you will get:
- ISO3166 Alpha 2 .. like EG
- ISO3166 Alpha 3 .. like EGY
- ISO3166 Number 3 .. like 818
- English Name .. like Egypt
- Local Name .. like Mişr
- Local Long Name .. like Jumhūrīyat Mişr al ‘Arabīyah
- English Capital Name .. like Cairo
- Local Capital Name .. like Al Qāhirah
- Continent .. like AF
- Demomyn .. like Egyptian
- Latitude .. like 27
- Longitude .. like 30
Click Countries to download the file or get it from my dropbox.