India Cities with Latitude & Longitude – Download in Excel, CSV, SQL, JSON, XML

India
India
Excel, CSV, SQL, XML, JSON

Last update : 23 March 2026.

Country
India
Capital
New Delhi
Number of cities
543072
Download
Click here

Here you’ll find a curated sample of 100 key cities from India, each with essential data points such as latitude, longitude, administrative region, and other relevant attributes. This preview is extracted from our full dataset, which includes a total of 543072 geographic locations across India.

Whether you’re working on mapping, analytics, or app development, the data is available for both personal and commercial use. All entries can be downloaded in five formats: Excel (.xlsx), CSV, SQL, JSON, and XML.

Capital Highlight: The official capital city of India is New Delhi.


Geoname_IDCityAlternate_NameCountry_Code RegionSub_regionLatitudeLongitude ElevationPopulationTimezoneFcode_Name
10608606 Gangauli IN Uttar Pradesh Faizābād 26.67754 82.23777 0 Asia/Kolkata populated place
10576917 Rusha Dīh IN Uttar Pradesh Sultānpur 26.33628 81.84673 0 Asia/Kolkata populated place
11682087 Neykkārappatti Neykkarappatti,Neykkārappatti IN Tamil Nadu Salem 11.6225 78.10579 0 Asia/Kolkata populated place
10599534 Rauna Malla IN Uttarakhand Garhwāl 29.77379 79.0053 0 Asia/Kolkata populated place
10616718 Haibatpur IN Uttar Pradesh Ambedkar Nagar 26.33457 82.44623 0 Asia/Kolkata populated place
11661317 Māttūr IN Tamil Nadu Sivaganga 10.10929 78.49398 0 Asia/Kolkata populated place
7701430 Ghorabandha IN Bihar 22.0275 85.8628 0 Asia/Kolkata populated place
10622575 Pura Bhaiya Rām IN Uttar Pradesh Jaunpur 26.00153 82.53212 0 Asia/Kolkata populated place
10720529 Komrātola IN Chhattisgarh Rāj Nāndgaon 20.72402 80.79543 0 Asia/Kolkata populated place
10560619 Ramwānpur IN Uttar Pradesh Shrawasti 27.6476 81.68409 0 Asia/Kolkata populated place
10506970 Chakra IN Uttar Pradesh Mau 25.99254 83.65665 0 Asia/Kolkata populated place
10580597 Bhadras IN Uttar Pradesh Bāra Banki 27.22507 80.98992 0 Asia/Kolkata populated place
10790554 Merattūr IN Tamil Nadu Thiruvallur 13.31309 80.25621 0 Asia/Kolkata populated place
10592217 Aumānpur IN Uttar Pradesh Sultānpur 26.07907 81.8531 0 Asia/Kolkata populated place
10973036 Motlapalli IN Telangana Karīmnagar 18.4714 79.56673 0 Asia/Kolkata populated place
10802820 Kowāri IN Rajasthan Bānswāra 23.44961 74.13879 0 Asia/Kolkata populated place
11677601 Kadiranampatti IN Tamil Nadu Dindigul 10.43907 77.85382 0 Asia/Kolkata populated place
10619007 Pura Kharthuwa IN Uttar Pradesh Basti 26.79642 82.52899 0 Asia/Kolkata populated place
11693048 Khuntapāra IN Odisha Kendujhar 21.7177 85.52218 0 Asia/Kolkata populated place
10463835 Nagla Kāchhiān IN Uttar Pradesh Kasganj 27.6497 78.91091 0 Asia/Kolkata populated place
11322369 Tippakindapalle IN Andhra Pradesh Chittoor 13.49277 78.45273 0 Asia/Kolkata populated place
10843377 Patauri IN Madhya Pradesh Satna 25.05566 80.57735 0 Asia/Kolkata populated place
1271415 Gettavādi IN Tamil Nadu Erode 11.655 76.90684 0 Asia/Kolkata populated place
10583165 Parsia Ālam IN Uttar Pradesh Shrawasti 27.46405 81.84731 0 Asia/Kolkata populated place
10712990 Jadbhaoda IN Maharashtra Gondiya 21.00027 80.34217 0 Asia/Kolkata populated place
10659514 Suraulia IN Uttar Pradesh Gorakhpur 26.71705 83.12336 0 Asia/Kolkata populated place
10703140 Goār IN Rajasthan Ajmer 25.69891 73.9653 0 Asia/Kolkata populated place
10590165 Sojāni Patti IN Uttar Pradesh Gonda 26.83652 81.8946 0 Asia/Kolkata populated place
10609449 Sadhāripur IN Uttar Pradesh Sultānpur 26.33647 82.02004 0 Asia/Kolkata populated place
11643124 Kusumtoli IN Jharkhand Simdega 22.60182 84.23032 0 Asia/Kolkata populated place
10489803 Alra IN Uttar Pradesh Hamīrpur 25.63247 79.84396 0 Asia/Kolkata populated place
10617003 Harsāin Nāgāpur IN Uttar Pradesh Sultānpur 26.23352 82.26404 0 Asia/Kolkata populated place
10695604 Gālowāli Kalān IN Punjab Amritsar 31.78156 74.9544 0 Asia/Kolkata populated place
11326368 Kondamdoddi IN Andhra Pradesh Chittoor 13.30368 78.52217 0 Asia/Kolkata populated place
10899501 Hiriyūru IN Karnataka Mysore 12.20998 76.95579 0 Asia/Kolkata populated place
10559778 Baunkaha IN Uttar Pradesh Bahraich 27.60628 81.52451 0 Asia/Kolkata populated place
11250991 Yelachvādi IN Karnataka Tumkur 12.93652 77.12075 0 Asia/Kolkata populated place
10825729 Kūdha IN Uttar Pradesh Budaun 28.06911 79.37639 0 Asia/Kolkata populated place
10911049 Sahur IN Bihar Jamui 24.92857 86.18474 0 Asia/Kolkata populated place
11409554 Āvulagurappapalle IN Andhra Pradesh Prakasam 15.45977 79.37966 0 Asia/Kolkata populated place
10553145 Arjunamau IN Uttar Pradesh Unnāo 26.66919 80.76063 0 Asia/Kolkata populated place
10618366 Jatauli IN Uttar Pradesh Sultānpur 26.16493 82.42217 0 Asia/Kolkata populated place
11739354 Kalamuri IN Odisha Kandhamal 20.51361 84.19884 0 Asia/Kolkata populated place
10692071 Tākli Hivardi IN Maharashtra Jalna 20.12327 75.7722 0 Asia/Kolkata populated place
10562870 Ruknāpur Khurd IN Uttar Pradesh Bahraich 27.33376 81.53798 0 Asia/Kolkata populated place
10832155 Mahāwa Mānpura IN Uttar Pradesh Pīlībhīt 28.34994 79.77478 0 Asia/Kolkata populated place
9035864 Duanpali IN Odisha Baragarh 21.4011 83.44835 0 Asia/Kolkata populated place
10748462 Saraipāli IN Chhattisgarh Raigarh 21.46257 83.11579 0 Asia/Kolkata populated place
10179497 Muhammadpur Mandauli IN Uttar Pradesh Bijnor 29.4286 78.09145 0 Asia/Kolkata populated place
10529811 Mandwa IN Maharashtra Chandrapur 19.69951 78.95588 0 Asia/Kolkata populated place
10902782 Dewāri IN Bihar Saharsa 25.83356 86.57961 0 Asia/Kolkata populated place
10477279 Sadullipur IN Uttar Pradesh Hardoi 27.4074 79.82037 0 Asia/Kolkata populated place
10465675 Ailampur IN Uttar Pradesh Firozabad 26.99101 78.78955 0 Asia/Kolkata populated place
11452573 Puvadi IN Kerala Malappuram 11.30151 76.22933 0 Asia/Kolkata populated place
11667334 Alamattangudi IN Tamil Nadu Rāmanāthapuram 9.30361 78.63056 0 Asia/Kolkata populated place
10786702 Orada IN Odisha Gajapati 18.86187 83.95118 0 Asia/Kolkata populated place
10452130 Ailwānpalle IN Telangana Mahbūbnagar 17.0877 77.58803 0 Asia/Kolkata populated place
10704641 Saragbundiā IN Chhattisgarh Korba 22.332 82.17527 0 Asia/Kolkata populated place
10727560 Jamdhar IN Himachal Pradesh Kāngra 31.9788 76.19486 0 Asia/Kolkata populated place
10572713 Uniyāl Khīl IN Uttarakhand Garhwāl 29.67068 78.92744 0 Asia/Kolkata populated place
11643684 Chatkaltoli IN Jharkhand Simdega 22.81384 84.47143 0 Asia/Kolkata populated place
11064432 Kalwa Moti IN Uttar Pradesh Kheri 27.83683 80.38683 0 Asia/Kolkata populated place
10920706 Mohkamganj IN Uttar Pradesh Sītāpur 27.31167 80.6266 0 Asia/Kolkata populated place
10801587 Bilaura IN Madhya Pradesh Khargone 22.23593 76.08387 0 Asia/Kolkata populated place
10783373 Simidigeddavalasa IN Andhra Pradesh Vizianagaram District 18.63181 83.27886 0 Asia/Kolkata populated place
11629675 Hettoli IN Jharkhand Rānchī 23.00365 85.81046 0 Asia/Kolkata populated place
10708482 Sutiurkuli IN Chhattisgarh Raipur 21.61153 82.73172 0 Asia/Kolkata populated place
10453315 Vadgaon IN Maharashtra Yavatmal 20.61175 78.25072 0 Asia/Kolkata populated place
10167038 Khajār IN Himachal Pradesh Sirmaur 30.61069 77.66548 0 Asia/Kolkata populated place
10443410 Jamnāhīpāra IN Chhattisgarh Korba 22.3704 82.31329 0 Asia/Kolkata populated place
11421908 Arthingivarayūr IN Andhra Pradesh Chittoor 13.14441 79.2537 0 Asia/Kolkata populated place
10507533 Durgāpur Durgapur,Durgāpur,Lalan,Lalān IN Uttar Pradesh Jhānsi 25.38883 78.51308 0 Asia/Kolkata populated place
9922091 Bāgi IN Himachal Pradesh Mandi 31.625 77.23793 0 Asia/Kolkata populated place
10167212 Bharār IN Himachal Pradesh Sirmaur 30.65973 77.62909 0 Asia/Kolkata populated place
10910037 Mirchai IN Bihar Bhāgalpur 25.42023 86.98215 0 Asia/Kolkata populated place
10547394 Pahārpur IN Uttar Pradesh Allahābād 25.35107 82.11959 0 Asia/Kolkata populated place
10652390 Tejāpur IN Uttar Pradesh Āzamgarh 26.35818 82.90516 0 Asia/Kolkata populated place
10844584 Pakhrauli IN Uttar Pradesh Bānda 25.5712 80.78515 0 Asia/Kolkata populated place
10834388 Manaura IN Bihar Rohtās 24.92253 84.15876 0 Asia/Kolkata populated place
10888824 Aralahalli IN Karnataka Chitradurga 13.70655 76.34155 0 Asia/Kolkata populated place
10580481 Kesripur IN Uttar Pradesh Sītāpur 27.1732 80.92166 0 Asia/Kolkata populated place
11667269 Ilangākkūr IN Tamil Nadu Rāmanāthapuram 9.34417 78.62985 0 Asia/Kolkata populated place
10699113 Nimgaon Nimgaon,Padampur IN Madhya Pradesh Bālāghāt 21.67216 80.14168 0 Asia/Kolkata populated place
10760380 Kallā Ganjauli IN Uttar Pradesh Bahraich 27.44908 81.42372 0 Asia/Kolkata populated place
10581356 Purwa Paragausethi IN Uttar Pradesh Bahraich 27.22828 81.52906 0 Asia/Kolkata populated place
10666587 Dhekohi IN Uttar Pradesh Pratāpgarh 25.7476 81.55445 0 Asia/Kolkata populated place
10503103 Madhuban IN Uttar Pradesh Chandauli District 25.28575 83.2799 0 Asia/Kolkata populated place
10499978 Amdaha IN Uttar Pradesh Mirzāpur 25.08324 83.04175 0 Asia/Kolkata populated place
10467162 Kukrāyān Ratanpur IN Uttar Pradesh Etah 27.52135 79.07035 0 Asia/Kolkata populated place
10446204 Sindgi IN Karnataka Gulbarga 17.34482 76.78205 0 Asia/Kolkata populated place
11461550 Sirukanaru IN Tamil Nadu Coimbatore 11.22308 76.76589 0 Asia/Kolkata populated place
11420494 Moturāyanapalli IN Andhra Pradesh Chittoor 13.25031 79.19442 0 Asia/Kolkata populated place
10622260 Mauna IN Uttar Pradesh Sultānpur 26.21765 82.53833 0 Asia/Kolkata populated place
10610300 Purwa Badna IN Uttar Pradesh Sultānpur 26.35226 82.22549 0 Asia/Kolkata populated place
1260232 Partāpur Partapor,Partapur,Partāpur IN Rajasthan Bānswāra 23.59276 74.17396 10080 Asia/Kolkata populated place
10610732 Sāngran IN Jammu and Kashmir Shupiyan 33.73284 74.90932 0 Asia/Kolkata populated place
10478521 Gādiāpura IN Madhya Pradesh Guna 24.30033 77.02292 0 Asia/Kolkata populated place
10164858 Samela IN Himachal Pradesh Sirmaur 30.65297 77.46735 0 Asia/Kolkata populated place
10408677 Bong IN West Bengal Darjiling 27.05365 88.47801 0 Asia/Kolkata populated place
10698519 Kātharda IN Maharashtra Nandurbar 21.56248 74.38887 0 Asia/Kolkata populated place

India: Mapping the Living Mosaic of a Subcontinent

A Cartographer’s Dream in a Nation of Contrasts

India is not merely a country—it is a dynamic, living mosaic of cultures, climates, and geographies. As a geographer, exploring India is akin to navigating a universe of contrasts, from the Himalayan cradles of the north to the sun-soaked deltas of the south, from the arid deserts of Rajasthan to the evergreen forests of the Western Ghats. But understanding India in its full spatial complexity requires more than poetic descriptions. It requires data. Clean, structured, locationally precise data.

This is why I’ve developed a comprehensive database of Indian cities, categorized by state and district, and enriched with geographic coordinates—making spatial analysis of this vast land not just possible, but profoundly insightful.

From States to Districts: The Administrative Backbone

India is divided into 28 states and 8 union territories, which further segment into more than 700 districts. These divisions are not administrative trivia—they are deeply tied to historical boundaries, cultural identities, and political structures. Cities and towns are interlaced within these layers, each functioning as an economic node, a demographic marker, and a cultural beacon.

To truly study India spatially, one must view it through the lens of these administrative tiers. My dataset ensures that every city is indexed with its proper region and departmental division, allowing for accurate multi-level filtering and comparative geographic studies.

Cities as Catalysts of Transformation

India’s cities are evolving at an astonishing pace. Megacities like Mumbai and Delhi dominate the narrative, but equally crucial are the Tier-II and Tier-III cities like Bhopal, Guwahati, Coimbatore, and Jodhpur. These urban centers are engines of decentralization, hotspots of growth that require careful spatial mapping for planning, policy-making, and market analysis.

By including every city’s latitude and longitude, this dataset allows you to visualize settlement patterns, infrastructure corridors, and regional imbalances with clarity and precision.

Latitude and Longitude: The Geometry of Understanding

Coordinates are not just dots on a map—they are keys to unlocking patterns. India’s river valleys, trade routes, and linguistic zones become intelligible when seen through the prism of geolocation. Whether you’re analyzing population clusters along the Indo-Gangetic Plain or tracing economic zones across coastal regions, the inclusion of accurate coordinates turns geographic curiosity into actionable insight.

The Power of Excel in Geographic Data

While the dataset is available in multiple technical formats—CSV, SQL, JSON, and XML—the recent addition of Excel (.xlsx) marks a turning point. Excel is the lingua franca of planners, analysts, and researchers who want immediacy and clarity.

In this new Excel format, the data is organized intuitively: city name, state, district, and geographic coordinates, all formatted for instant use. Filter by region, sort by latitude, analyze clusters, or plug into dashboards—Excel transforms spatial data into strategic intelligence. Whether you're a policy researcher in Delhi or a logistics planner in London, Excel empowers your decisions with the accessibility of a spreadsheet and the depth of a GIS platform.

Multi-Format Precision for Every Use Case

Beyond Excel, the dataset supports full interoperability. Developers can import JSON and XML into web applications, data scientists can integrate SQL into relational databases, and statisticians can pull clean rows from CSVs. No matter your ecosystem, the data adjusts without compromise.

Each format is kept consistent, complete, and error-free—because integrity in spatial data isn’t optional. It’s essential.

Why This Database Matters Now

India is undergoing an urban transition of historic scale. By 2030, it is estimated that over 40% of its population will live in cities. Planning for this shift demands rigorous, structured data—not just for megacities, but for every municipality that forms the beating heart of local economies.

This database is not simply a collection of city names—it is a strategic resource. It enables cross-regional comparisons, tracks spatial inequalities, supports smart city initiatives, and feeds into models for climate adaptation and infrastructure resilience.

Conclusion: A Passion for Mapping, A Tool for Progress

To understand India is to embrace its scale and complexity. And to do that effectively, you need a data framework that is as detailed, diverse, and dynamic as the country itself. With the inclusion of Excel format—alongside CSV, SQL, JSON, and XML—this geographic dataset offers a panoramic yet precise view of Indian urbanity.

Let this data be your map, your lens, your analytical foundation. India is not just a place—it is a pattern. And with the right data, that pattern becomes crystal clear.

Download India cities in Excel SQL CSV JSON XML

Access detailed latitude and longitude data for cities in India, now available in Excel (.xlsx) — plus CSV, SQL, XML, and JSON formats

List of countries :

download-cities-data.org