Albania cities list with latitude and longitude in CSV format

Albania
CSV, SQL, XML, JSON
Last update : 11 December 2023.
This is the best list of 3814 cities in the Albania available in 4 formats ( CSV, Json, SQL, XML ). We have cleaned up the Geoname database to leave only the towns, capitals and villages. All are all associated with regions and sub-regions (where available).
Each file contains the following data: Geoname_ID, City, Alternate_Name, Country_Code, Region, Sub_region, Latitude, Longitude, Elevation, Population, Timezone, Fcode_Name. See the FAQ below for a detailed explanation.
Here is an example of the data from the Albania file that you are going to retrieve. The data is displayed here in the form of a table:
Geoname_ID | City | Alternate_Name | Country_Code | Region | Sub_region | Latitude | Longitude | Elevation | Population | Timezone | Fcode_Name |
---|---|---|---|---|---|---|---|---|---|---|---|
3343805 | Zarovë | Zarova,Zarove,Zarovë | AL | Elbasan County | Bashkia Belsh | 40.86528 | 19.9225 | 0 | Europe/Tirane | populated place | |
3205258 | Guri i Lekës | Gur i Lekes,Gur i Lekës,Guri i Lekes,Guri i Lekës | AL | Shkodër County | Bashkia Shkodër | 42.19278 | 19.79167 | 0 | Europe/Tirane | populated place | |
782527 | Letëm | Letem,Letemi,Letjum,Letmi,Letëm,Ljetim,Verasi | AL | Elbasan County | Bashkia Librazhd | 41.24861 | 20.33833 | 0 | Europe/Tirane | populated place | |
782967 | Hoshtecë | Hoshtec,Hoshteca,Hoshtece,Hoshteci,Hoshtecë,Hoshteça,Hosteca,Hostece,Hosteçë,Oshteca,Oshtece,Oshtica,Оштица | AL | Korçë County | Bashkia Pogradec | 40.94611 | 20.55722 | 0 | Europe/Tirane | populated place | |
781565 | Sllatinë | Slatina,Sllatina,Sllatine,Sllatinë | AL | Dibër County | Bashkia Dibër | 41.78806 | 20.41389 | 0 | Europe/Tirane | populated place | |
781456 | Taroninë | Kakadhigi,Kardhiq,Kardhiqi,Taronin,Taronine,Taroninë | AL | Gjirokastër County | Bashkia Gjirokastër | 40.12333 | 20.00944 | 0 | Europe/Tirane | populated place | |
3185435 | Gur | Gur,Guri | AL | Fier County | Bashkia Divjakë | 40.89806 | 19.535 | 0 | Europe/Tirane | populated place | |
781798 | Roshnik Qender | Fikaj,Roshnic,Roshnik,Roshniku,Rosniki,Rroshniku | AL | Berat County | Bashkia Berat | 40.73278 | 20.03944 | 252 | Europe/Tirane | populated place | |
782743 | Kosharisht | Kasharishta,Kosarist,Kosharisht,Kosharishte,Kosharishti,Kosharishtë,Kosharist,Kosharista,Košarist | AL | Kukës County | Bashkia Kukës | 42.04806 | 20.56611 | 0 | Europe/Tirane | populated place | |
865092 | Vërzhezaj | AL | Berat County | Bashkia Skrapar | 40.56028 | 20.21583 | 0 | Europe/Tirane | populated place | ||
781500 | Stëmbec | Stembec,Sterbeci,Stermbec,Stermbeci,Strembec,Strembeci,Strimbec,Strimbeni,Strëmbec,Strëmbeci,Stëmbec,Stërbeci,Stërmbec | AL | Gjirokastër County | Bashkia Përmet | 40.15472 | 20.46278 | 0 | Europe/Tirane | populated place | |
783285 | Dukagjin | Dukagjin,Dukagjini | AL | Dibër County | Bashkia Mat | 41.69972 | 20.06194 | 0 | Europe/Tirane | populated place | |
3343779 | Canaj | AL | Elbasan County | Bashkia Belsh | 40.92444 | 19.89528 | 0 | Europe/Tirane | populated place | ||
3185011 | Laç | Lac,Lac-Qyrsac,Lac-Qyrsaci,Lac-Qysac,Lach,Laç,Laç-Qyrsaç,Laç-Qyrsaçi,Laç-Qysaç,Лач | AL | Shkodër County | Bashkia Vau i Dejës | 42.01056 | 19.64028 | 0 | Europe/Tirane | populated place | |
3343914 | Ecër | Ecer,Ecri,Ecër | AL | Fier County | Bashkia Roskovec | 40.77944 | 19.65944 | 0 | Europe/Tirane | populated place | |
782048 | Gjinkar | Gjinakar,Gjinkan-Petrani,Gjinkar,Gjinkar-Petran,Petran,Petrani,Petrani-Gjinkari,Petranit,Петрани | AL | Gjirokastër County | Bashkia Përmet | 40.19944 | 20.40611 | 3243 | Europe/Tirane | populated place | |
3186180 | Arrëz | Areza,Arrez,Arreza,Arreze,Arrëz,Arrëza,Arrëzë | AL | Berat County | Bashkia Kuçovë | 40.81302 | 19.85749 | 440 | Europe/Tirane | populated place | |
783435 | Çerniev | Cerniev,Cernjeve,Çerniev | AL | Dibër County | Bashkia Dibër | 41.82444 | 20.45556 | 0 | Europe/Tirane | populated place | |
3185650 | Frashër | Frasher,Frasheri,Frashër,Frashëri,Frasr,Frašr | AL | Fier County | Bashkia Fier | 40.71472 | 19.615 | 0 | Europe/Tirane | populated place | |
3343835 | Lazaj | AL | Fier County | Bashkia Roskovec | 40.68 | 19.75167 | 0 | Europe/Tirane | populated place | ||
3343803 | Blir | Blir,Bliri | AL | Berat County | Bashkia Kuçovë | 40.85639 | 19.93833 | 0 | Europe/Tirane | populated place | |
783453 | Çemericë | Cemerica,Cemerice,Çemerica,Çemericë | AL | Korçë County | Bashkia Korçë | 40.54278 | 20.47472 | 0 | Europe/Tirane | populated place | |
3186007 | Bolenë | Bolena,Bolene,Bolenë,Boljena | AL | Vlorë County | Bashkia Himarë | 40.2428 | 19.76328 | 0 | Europe/Tirane | populated place | |
782191 | Nezhaj | Nezhaj,Xhearik,Xhedik | AL | Dibër County | Bashkia Dibër | 41.79 | 20.32861 | 0 | Europe/Tirane | populated place | |
3186187 | Arishtë | AL | Lezhë County | Bashkia Mirditë | 41.75028 | 19.78944 | 0 | Europe/Tirane | populated place | ||
3184057 | Shpat-Vesqi | Shpati-Vesqia | AL | Tirana | Bashkia Tiranë | 41.16667 | 19.81667 | 0 | Europe/Tirane | populated place | |
782365 | Marina | AL | Gjirokastër County | Bashkia Libohovë | 40.01667 | 20.26667 | 0 | Europe/Tirane | populated place | ||
363296 | Llanzat | AL | Vlorë County | Bashkia Konispol | 39.66833 | 20.175 | 0 | Europe/Tirane | populated place | ||
865008 | Bratilës | AL | Elbasan County | Bashkia Prrenjas | 40.99639 | 20.40639 | 0 | Europe/Tirane | populated place | ||
3186124 | Bardhor | Barderoll,Barderoll Xheles,Bardhor,Bardhori,Bardhuer,Bardrol,Bardëroll,Bardëroll Xheles,Peqinaj | AL | Tirana | Bashkia Kavajë | 41.13986 | 19.46625 | 0 | Europe/Tirane | populated place | |
865161 | Fushë | AL | Gjirokastër County | Bashkia Kelcyrë | 40.38056 | 20.13639 | 0 | Europe/Tirane | populated place | ||
3183809 | Uznovë | Azenovo,Uznova,Uznove,Uznovë,Азеново | AL | Berat County | Bashkia Berat | 40.69722 | 19.98028 | 2569 | Europe/Tirane | populated place | |
3184613 | Ndrejaj | Ndreaj,Ndrejaj,Nrejaj | AL | Shkodër County | Bashkia Shkodër | 42.24833 | 19.79278 | 0 | Europe/Tirane | populated place | |
782540 | Leskaj | AL | Gjirokastër County | Bashkia Libohovë | 40.24611 | 20.19194 | 0 | Europe/Tirane | populated place | ||
363212 | Vërvë | Vei,Verna,Verne,Verva,Verve,Ververa,Vërnë,Vërvë | AL | Vlorë County | Bashkia Konispol | 39.67917 | 20.2125 | 0 | Europe/Tirane | populated place | |
3184184 | Seman i Ri | Seman i Ri,Semani i Ri | AL | Fier County | Bashkia Fier | 40.78764 | 19.49704 | 0 | Europe/Tirane | populated place | |
3184018 | Sinanaj | Sinanai,Sinanaj,Sinananji | AL | Gjirokastër County | Bashkia Tepelenë | 40.3667 | 19.84314 | 0 | Europe/Tirane | populated place | |
3184664 | Mukje | Mukaj,Muke,Mukja,Mukje,Mukë | AL | Durrës County | Bashkia Krujë | 41.44694 | 19.8275 | 0 | Europe/Tirane | populated place | |
781485 | Suhë | Suha,Suhe,Suhë,Suka | AL | Gjirokastër County | Bashkia Libohovë | 40.07222 | 20.25583 | 0 | Europe/Tirane | populated place | |
783511 | Bulçar | Bulcar,Bulcari,Bulçar,Bulçari | AL | Elbasan County | Bashkia Gramsh | 40.80444 | 20.27139 | 0 | Europe/Tirane | populated place | |
783429 | Cërujë | Cerruja,Cerruje,Ceruja,Ceruje,Cerunje,Cerunjë,Cërruja,Cërrujë,Cëruja,Cërujë | AL | Dibër County | Bashkia Klos | 41.53278 | 20.13194 | 0 | Europe/Tirane | populated place | |
3186158 | Bakushe Visha | AL | Durrës County | Bashkia Krujë | 41.48333 | 19.7 | 0 | Europe/Tirane | populated place | ||
3186159 | Bakall | AL | Tirana | Bashkia Tiranë | 41.32389 | 19.74861 | 0 | Europe/Tirane | populated place | ||
783506 | Bulshar | Bulshar,Bulshara,Bulshare,Bulshari,Bulsharë | AL | Lezhë County | Bashkia Mirditë | 41.84583 | 20.06583 | 0 | Europe/Tirane | populated place | |
834111 | Arat e Mira | AL | Shkodër County | Bashkia Fushë Arrës | 42.03889 | 20.18056 | 0 | Europe/Tirane | populated place | ||
3185611 | Gërdec | Gerdec,Gerdeci,Gjecaj,Gjeçaj,Gërdec,Gërdeci | AL | Tirana | Bashkia Vorë | 41.41778 | 19.63111 | 0 | Europe/Tirane | populated place | |
864717 | Selitë | Selita,Selite,Selitë | AL | Dibër County | Bashkia Dibër | 41.64361 | 20.18944 | 0 | Europe/Tirane | populated place | |
3343963 | Ballan | Ballan,Ballani | AL | Fier County | Bashkia Mallakastër | 40.56222 | 19.71806 | 0 | Europe/Tirane | populated place | |
782059 | Peshtan | Peshtan,Peshtani | AL | Korçë County | Bashkia Kolonjë | 40.24417 | 20.53528 | 0 | Europe/Tirane | populated place | |
3185577 | Gjoroven | Gjerevan,Gjerovan,Gjerovani,Gjeroven,Gjeroveni,Gjiroven,Gjoroveni | AL | Berat County | Bashkia Berat | 40.6675 | 19.925 | 540 | Europe/Tirane | populated place | |
3343798 | Shpataj | AL | Berat County | Bashkia Kuçovë | 40.8425 | 19.99667 | 0 | Europe/Tirane | populated place | ||
3184567 | Paçram | Paciram,Pacirami,Pacram,Pacrami,Paqrami,Pasram,Paçiram,Paçirami,Paçram,Paçrami | AL | Shkodër County | Bashkia Vau i Dejës | 41.95778 | 19.58389 | 0 | Europe/Tirane | populated place | |
3316652 | Kutreq | AL | Tirana | Bashkia Tiranë | 41.39667 | 19.96167 | 5 | Europe/Tirane | populated place | ||
782335 | Mbrakull | Brakull,Mbrakull,Mbrakulla,Mbrakulle,Mbrakulli,Mbrakullë,Vrakule | AL | Berat County | Bashkia Poliçan | 40.62917 | 20.06667 | 706 | Europe/Tirane | populated place | |
3185380 | Hemenraj | Ermeneraje,Hemenraj,Hemenraje,Remendraj | AL | Tirana | Bashkia Rrogozhinë | 41.10667 | 19.67556 | 0 | Europe/Tirane | populated place | |
3343688 | Shijezë | Shieza,Shijeze,Shijezë | AL | Lezhë County | Bashkia Kurbin | 41.59306 | 19.76667 | 0 | Europe/Tirane | populated place | |
3184894 | Luadh | Luadh,Luadhaj | AL | Gjirokastër County | Bashkia Memaliaj | 40.43722 | 19.94056 | 0 | Europe/Tirane | populated place | |
3343832 | Velaj | AL | Berat County | Bashkia Ura Vajgurore | 40.70472 | 19.79 | 0 | Europe/Tirane | populated place | ||
783444 | Çerenec i Poshtëm | Cerenec,Cerenec i Poshtem,Cereneci,Cereneti Poshtem,Cernec i Poshtem,Cerneci e Poshther,Cernes i Poshtem,Dolnje Cerneze,Dolnje Černeze,Dolno Cherenci,Çerenec,Çerenec i Poshtëm,Çereneci,Çereneti Poshtëm,Çernec i Poshtëm,Çerneci e Poshthër,Çernes i Poshtëm,Долно Черенци | AL | Dibër County | Bashkia Bulqizë | 41.51694 | 20.425 | 0 | Europe/Tirane | populated place | |
783504 | Golemaj | Golemaj,Golemanj,Golemi,Kalemaj | AL | Gjirokastër County | Bashkia Kelcyrë | 40.44 | 20.04917 | 0 | Europe/Tirane | populated place | |
3205115 | Nelegam | AL | Shkodër County | Bashkia Shkodër | 42.17889 | 19.68583 | 0 | Europe/Tirane | populated place | ||
783552 | Brasnik | Bersnik,Besniku,Brasnik,Brasniku,Bresnik,Brsnik | AL | Elbasan County | Bashkia Gramsh | 40.78306 | 20.13028 | 0 | Europe/Tirane | populated place | |
781997 | Podë | Poda,Pode,Podhe,Podhë,Podë | AL | Korçë County | Bashkia Kolonjë | 40.23972 | 20.61389 | 0 | Europe/Tirane | populated place | |
783270 | Dushk | Dushk,Dushku | AL | Elbasan County | Bashkia Gramsh | 40.93417 | 20.10944 | 0 | Europe/Tirane | populated place | |
3343819 | Lapardha Dy | Lagjja e Re,Lapardha Dy,Lapardha-2,Lapardha-2 (Dy) | AL | Berat County | Bashkia Berat | 40.7625 | 19.96139 | 1628 | Europe/Tirane | populated place | |
3184552 | Palermo | AL | Vlorë County | Bashkia Himarë | 40.06306 | 19.79278 | 0 | Europe/Tirane | populated place | ||
781162 | Xhavur | AL | Elbasan County | Bashkia Cërrik | 40.89444 | 20.01556 | 0 | Europe/Tirane | populated place | ||
783512 | Bulagarec | Bujgarec,Bulagarec,Bulgareci,Bullgarec,Bullgareci | AL | Korçë County | Bashkia Korçë | 40.65833 | 20.75722 | 0 | Europe/Tirane | populated place | |
3205141 | Hysebaj | AL | Shkodër County | Bashkia Malësi e Madhe | 42.19056 | 19.50556 | 0 | Europe/Tirane | populated place | ||
3184813 | Mal-Milot | Mal-Milot,Mal-Miloti,Milot | AL | Lezhë County | Bashkia Kurbin | 41.68028 | 19.72444 | 0 | Europe/Tirane | populated place | |
782657 | Lagjja i Vjetër | Kukur i Vjeter,Kukur i Vjetër,Lagjja i Vjeter,Lagjja i Vjetër | AL | Elbasan County | Bashkia Gramsh | 40.85694 | 20.34472 | 0 | Europe/Tirane | populated place | |
3344012 | Çunaj | Cunaj,Llanaj,Çunaj | AL | Gjirokastër County | Bashkia Memaliaj | 40.495 | 19.99 | 0 | Europe/Tirane | populated place | |
3343651 | Kuzhnen | Kuzhnen,Kuzhneni | AL | Shkodër County | Bashkia Pukë | 41.90194 | 19.97556 | 0 | Europe/Tirane | populated place | |
3185258 | Karavasta | Cravasta,Karavasta,Karavastaja,Kavarsta,Kravasta | AL | Fier County | Bashkia Divjakë | 40.8775 | 19.49083 | 0 | Europe/Tirane | populated place | |
783531 | Bual | Bual,Buali,Buhal,Buhali,Buhall | AL | Gjirokastër County | Bashkia Përmet | 40.2525 | 20.30361 | 0 | Europe/Tirane | populated place | |
865175 | Shanaj | AL | Gjirokastër County | Bashkia Memaliaj | 40.45694 | 20.06444 | 0 | Europe/Tirane | populated place | ||
3185157 | Kodras | Kodras,Kodrasej,Kodraseji | AL | Tirana | Bashkia Rrogozhinë | 41.09194 | 19.69944 | 0 | Europe/Tirane | populated place | |
783029 | Gumen | Gumen,Gumeni | AL | Berat County | Bashkia Poliçan | 40.63889 | 20.00417 | 0 | Europe/Tirane | populated place | |
3186110 | Bashtovë | AL | Tirana | Bashkia Rrogozhinë | 41.05 | 19.5 | 0 | Europe/Tirane | populated place | ||
3184467 | Picallë | Picala,Picall,Picalla,Picalle,Picalli,Picallë | AL | Tirana | Bashkia Tiranë | 41.27806 | 19.8075 | 0 | Europe/Tirane | populated place | |
782767 | Konaj | Konaj,Konal | AL | Lezhë County | Bashkia Mirditë | 41.91333 | 20.15556 | 0 | Europe/Tirane | populated place | |
3185770 | Drenie | Drenia,Drenica,Drenie,Drenieja,Drenija,Drenje,Drenjes,Drenjës,Drenova,Ndrenic | AL | Fier County | Bashkia Patos | 40.67361 | 19.7425 | 0 | Europe/Tirane | populated place | |
3316612 | Gurra e Vogël | Gurra e Vogel,Gurra e Vogël,Gurre e Vogel,Gurrë e Vogël | AL | Tirana | Bashkia Tiranë | 41.28639 | 19.88833 | 5 | Europe/Tirane | populated place | |
3185896 | Çërrilë | Cerila,Cerile,Cerilë,Cerrila,Cerrile,Çërrila,Çërrilë | AL | Gjirokastër County | Bashkia Memaliaj | 40.37 | 19.99 | 0 | Europe/Tirane | populated place | |
3185156 | Kokaj | Kokaj,Kokay | AL | Shkodër County | Bashkia Malësi e Madhe | 42.27444 | 19.53083 | 0 | Europe/Tirane | populated place | |
3183786 | Varr i Papes | AL | Shkodër County | Bashkia Malësi e Madhe | 42.35278 | 19.48444 | 0 | Europe/Tirane | populated place | ||
3186061 | Bicaj | AL | Shkodër County | Bashkia Pukë | 42.06389 | 19.98861 | 0 | Europe/Tirane | populated place | ||
3185737 | Dukat | Ducati,Dukat,Dukat-Fshat,Dukati | AL | Vlorë County | Bashkia Vlorë | 40.25051 | 19.56474 | 0 | Europe/Tirane | populated place | |
865168 | Murisht | AL | Gjirokastër County | Bashkia Kelcyrë | 40.46083 | 20.13111 | 0 | Europe/Tirane | populated place | ||
3186160 | Ivanaj | Bajza,Bajze,Bajzë,Ivanaj,Jvanaj | AL | Shkodër County | Bashkia Malësi e Madhe | 42.28528 | 19.43778 | 0 | Europe/Tirane | populated place | |
781940 | Prrenjas | Perrenjas,Perrenjasi,Prenjas,Prenjasi,Prrenjas,Përrenjas,Përrenjasi | AL | Berat County | Bashkia Skrapar | 40.57056 | 20.29472 | 0 | Europe/Tirane | populated place | |
3184028 | Kodër-Shupal | Koder-Shupal,Kodër-Shupal,Shen-Pal,Shepali,Shupal,Shupali,Shupalli,Shën-Pal,Shëpali | AL | Tirana | Bashkia Tiranë | 41.41417 | 19.93333 | 0 | Europe/Tirane | populated place | |
3184938 | Lezhan | Leshan,Leshani,Leshni,Leshnje,Leshnjë,Lezhan,Lezhani,Liesgne,Ljesni,Lješni | AL | Vlorë County | Bashkia Selenicë | 40.41111 | 19.69889 | 0 | Europe/Tirane | populated place | |
865138 | Guman | Guman,Gumani | AL | Berat County | Bashkia Berat | 40.6525 | 20.00667 | 0 | Europe/Tirane | populated place | |
782591 | Lashkizë | Lashkiz,Lashkiza,Lashkize,Lashkizë | AL | Dibër County | Bashkia Dibër | 41.81556 | 20.2975 | 0 | Europe/Tirane | populated place | |
3183914 | Telume-Kllogjen | Telume-Kllogjen,Telume-Kllogjena,Telume-Kllogjene,Telumë-Kllogjena,Telumë-Kllogjenë,Telune-Kllogjena,Telune-Kllogjene,Telunë-Kllogjena,Telunë-Kllogjenë | AL | Shkodër County | Bashkia Vau i Dejës | 42.15917 | 19.81917 | 0 | Europe/Tirane | populated place | |
3184115 | Sheqi i Vogël | AL | Fier County | Bashkia Fier | 40.73028 | 19.57139 | 0 | Europe/Tirane | populated place | ||
783411 | Çorogjaf | Cioroghiaf,Corogjaf,Corogjafi,Coroqaf,Corrogjaf,Corrogjafi,Çorogjaf,Çorogjafi,Çoroqaf,Çorrogjaf,Çorrogjafi | AL | Berat County | Bashkia Poliçan | 40.53167 | 20.005 | 142 | Europe/Tirane | populated place | |
783495 | Buranj | Burani,Buranj,Buranje,Buranji,Buranjë,Burraj,Burranj,Burranji,Burrenji | AL | Berat County | Bashkia Skrapar | 40.69583 | 20.26889 | 25 | Europe/Tirane | populated place | |
781880 | Qesarakë | Cesaraca,Qesaraka,Qesarake,Qesarakë | AL | Korçë County | Bashkia Kolonjë | 40.41167 | 20.52833 | 0 | Europe/Tirane | populated place |
FaQ about Albania
Once you have placed your order, you can download the product straight away! You'll also immediately receive an order confirmation email in which you can download your product. Remember to check your spam.
Don't panic, just log back in to the site and click on "your account" in the menu. You'll be able to find all your orders and re-download them whenever you like.
Yes, of course, click here to retrieve an archive containing an extract of the 4 CSV, XML, JSON and SQL files for a country.
Absolutely! You can pay with paypal or stripe in total security.
- Geoname_ID: This is a unique identifier for each place or geographical name in the Geoname database.
- City: The name of the place, which can be a town, village or any other form of human settlement.
- Alternate_Name: Other names or appellations that the place may have. These alternative names may be in different languages, dialects or even local names.
- Country_Code: This is the ISO 3166-1 alpha-2 code for the country in which the place is located. For example, "US" for the United States, "FR" for France.
- Region: This represents the first-order administrative division in which the location is situated. For example, this could be a state, province or territory.
- Sub_region: This is a second-order administrative division, such as a county or district, within the region.
- Latitude: The geographical latitude of the location, usually in decimal degrees.
- Longitude: The geographical longitude of the location, also usually in decimal degrees.
- Elevation: The elevation or altitude of the location in relation to sea level, usually measured in metres.
- Population: The estimated number of inhabitants or population of the location.
- Timezone: The time zone in which the location is located, in accordance with global time zone standards.
- Fcode_Name: This is a code that categorises the type of location. For example, "PPL" could mean a populated place, while "PPLC" could be the capital of a political entity.
You will retrieve a .rar archive containing the country files in csv, sql, xml and json formats.
Yes, you'll be able to download the content you've purchased whenever you want, with no time limit.
Make sure your Internet connection is stable, as some files can be quite large and take a long time to download.
Unfortunately we don't offer files in excel format, but it's really very easy to convert a csv file into excel. There are a plethora of free online sites that allow you to do this, here are a few: click here to convert csv to excel