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

China
China
Excel, CSV, SQL, XML, JSON

Last update : 24 March 2026.

Country
China
Capital
Beijing
Number of cities
792318
Download
Click here

Here you’ll find a curated sample of 100 key cities from China, 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 792318 geographic locations across China.

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 China is Beijing.


Geoname_IDCityAlternate_NameCountry_Code RegionSub_regionLatitudeLongitude ElevationPopulationTimezoneFcode_Name
7655164 Tanzi’ao Tanzi’ao,Tanzi’ao,tan zi ao,潭子凹 CN Hubei Jingmen Shi 31.19254 112.95613 0 Asia/Shanghai populated place
7653681 Zhujia Hekou Zhujia Hekou,zhu jia he kou,朱家河口 CN Hubei Suizhou Shi 31.58137 113.1081 0 Asia/Shanghai populated place
7413407 Shitoupo Shitoupo,shi tou po,石头坡 CN Qinghai Haidong Diqu 35.8649 102.44349 0 Asia/Shanghai populated place
10005425 Longluan Longluan,long luan,龙乱 CN Guizhou Qianxinan Buyei and Miao Autonomous Prefecture 25.2702 106.04 0 Asia/Shanghai populated place
1991901 Futian Futian,fu tian,扶田 CN Guangxi Guilin Shi 25.08029 110.49902 0 Asia/Shanghai populated place
1979757 Xiaxipo Xiaxipo,xia xi po,下西坡 CN Fujian Putian Shi 25.47861 119.15444 0 Asia/Shanghai populated place
7655764 Yanjiawan Yanjiawan,yan jia wan,严家湾 CN Hubei Xiangyang 31.69778 112.61334 0 Asia/Shanghai populated place
10333900 Xiongjiatang Xiongjiatang,xiong jia tang,熊家塘 CN Hunan 27.44693 113.57661 0 Asia/Shanghai populated place
2033363 Yingpancun Inpan’,Inpan’,Yingpan,Yingpancun,ying pan,ying pan cun,营盘,营盘村 CN Liaoning Fushun Shi 41.93345 124.21058 0 Asia/Shanghai populated place
11759388 Longlicun Longlicun,long li cun,龙里村 CN Zhejiang Taizhou Shi 29.03114 120.97076 0 Asia/Shanghai populated place
8519273 Xianglongping Xianglongping,xiang long ping,向龙坪 CN Hubei Yichangshi 31.42727 111.06129 0 Asia/Shanghai populated place
11616282 Liugangcun Liugangcun,liu gang cun,六港村 CN Jiangsu Taizhou Shi 32.3999 120.22632 0 Asia/Shanghai populated place
9992902 Shilonggou Shilonggou,shi long gou,石龙沟 CN Hebei Chengde Prefecture 40.34052 118.59116 0 Asia/Shanghai populated place
10404835 Maoyingou Maoyingou,mao yin gou,毛阴沟 CN Henan Luoyang Shi 33.97235 111.60628 0 Asia/Shanghai populated place
12137066 Dabei Houcun Dabei Houcun,da bei hou cun,大背后村 CN Shandong Weihai Shi 37.18798 121.81757 0 Asia/Shanghai populated place
11451331 Baigou Baigou,bai gou,柏沟 CN Shanxi Linfen Shi 35.94371 110.73437 0 Asia/Shanghai populated place
11891310 Tuiwan Qika Tuiwan Qika,tui wan qi ka,推万其卡 CN Xinjiang Kaxgar Diqu 38.83067 76.05576 0 Asia/Urumqi populated place
7738037 Raoshe Raoshe,rao she,饶舍 CN Jiangxi Fuzhou Shi 27.15374 116.4771 0 Asia/Shanghai populated place
7018434 Lilinxia Lilinxia,li lin xia,坜林下 CN Guangdong Meizhou Shi 24.06486 115.85979 0 Asia/Shanghai populated place
7328564 Wanshacun Wanshacun,wan sha cun,万沙村 CN Jiangxi Nanchang Shi 28.29065 115.90043 0 Asia/Shanghai populated place
1798907 Pengxi P’eng-hsi,P’eng-k’eng,P’eng-k’eng-wai-yang-ts’un,Pengxi,P’eng-hsi,P’eng-k’eng,P’eng-k’eng-wai-yang-ts’un CN Zhejiang Wenzhou Shi 27.43362 120.13755 0 Asia/Shanghai populated place
11586400 Yimancun Yimancun,yi man cun,一曼村 CN Heilongjiang Harbin Shi 45.30504 127.8202 0 Asia/Shanghai populated place
12353805 Hougaozhucun Hougaozhucun,hou gao zhu cun,后高柱村 CN Shandong 35.30812 118.83508 0 Asia/Shanghai populated place
8535312 Hujiabang Hujiabang,hu jia bang,胡家浜 CN Zhejiang Jiaxing Shi 30.57901 120.97489 0 Asia/Shanghai populated place
1991966 Dajing Yaozuxiang CN Guangxi Guilin Shi 25.1825 110.58194 0 Asia/Shanghai populated place
8405884 Chaoyang Chaoyang,chao yang,朝阳 CN Chongqing Chongqing 30.75046 107.67206 0 Asia/Shanghai populated place
10428428 Huangwan Huangwan,huang wan,黄湾 CN Gansu Tianshui Shi 34.9312 105.532 0 Asia/Shanghai populated place
9614104 Taoziyuan Taoziyuan,tao zi yuan,桃子园 CN Jiangxi Ji’an Shi 26.4828 114.159 0 Asia/Shanghai populated place
1919136 Mujiaqiao CN Zhejiang Hangzhou Shi 30.22278 119.775 0 Asia/Shanghai populated place
7692116 Zhangjiapai Zhangjiapai,zhang jia pai,张家排 CN Hunan Changsha Shi 28.33022 114.00206 0 Asia/Shanghai populated place
11505169 Haozigou Haozigou,hao zi gou,耗子沟 CN Liaoning Dandong Shi 40.1741 124.195 0 Asia/Shanghai populated place
9911408 Liangshangtun Liangshang,Liangshangtun,liang shang,liang shang tun,良上,良上屯 CN Guangxi Baise Shi 24.69696 106.51894 0 Asia/Shanghai populated place
11795516 Chenjiacun Chenjiacun,chen jia cun,陈家村 CN Zhejiang Ningbo Shi 29.97019 121.6505 0 Asia/Shanghai populated place
7403825 Yaodabagou Yaodabagou,yao da ba gou,腰大巴沟 CN Liaoning Fuxin Shi 42.43685 122.01445 0 Asia/Shanghai populated place
12339156 Bei’ancun Bei’ancun,Bei’ancun,bei an cun,北安村 CN Shandong 35.71468 116.68467 0 Asia/Shanghai populated place
1924873 Hongshuishan CN Jiangxi Fuzhou Shi 27.0475 115.98667 0 Asia/Shanghai populated place
10050206 Liupang Liupang,liu pang,柳旁 CN Guizhou Qiandongnan Miao and Dong Autonomous Prefecture 26.7079 108.538 0 Asia/Shanghai populated place
11194987 Nangou Nangou,nan gou,南沟 CN Shaanxi Yan’an Shi 36.0578 109.2962 0 Asia/Shanghai populated place
12373535 Nanyangcun Nanyangcun,nan yang cun,南杨村 CN Shandong 36.7583 118.28047 0 Asia/Shanghai populated place
12199190 Qinyuancun Qinyuancun,qin yuan cun,芹园村 CN Fujian Longyan Shi 25.15298 117.18102 0 Asia/Shanghai populated place
11150891 Baipingcun Baipingcun,bai ping cun,白坪村 CN Shaanxi Yan’an Shi 36.8282 109.16788 0 Asia/Shanghai populated place
12461661 Ziyoucun Ziyoucun,zi you cun,自由村 CN Jilin 44.00418 124.76733 0 Asia/Shanghai populated place
8135389 Santiaoling Santiaoling,san tiao ling,三条岭 CN Hunan Changde Shi 29.62366 111.64854 0 Asia/Shanghai populated place
10019515 Luojiazhai Luojiazhai,luo jia zhai,罗家寨 CN Guizhou Lupanshui Shi 26.5517 105.065 0 Asia/Shanghai populated place
6981977 Xiabao Xiabao,xia bao,下包 CN Zhejiang Lishui Shi 28.50441 119.50812 0 Asia/Shanghai populated place
9937676 Guogaomafang Guogaomafang,guo gao ma fang,郭高马坊 CN Hebei Qinhuangdao Shi 39.87948 119.44267 0 Asia/Shanghai populated place
8396108 Yangjia Yangjia,yang jia,杨家 CN Jiangsu Nanjing Shi 31.40651 119.04812 0 Asia/Shanghai populated place
9991553 Qibaizhuang Qibaizhuang,qi bai zhuang,七百庄 CN Yunnan Dali Baizu Zizhizhou 25.4637 100.594 0 Asia/Shanghai populated place
11456141 Taoziwan Taoziwan,tao zi wan,桃子湾 CN Shanxi Taiyuan Shi 38.20117 112.87513 0 Asia/Shanghai populated place
9526596 Yucun Yucun,yu cun,玉村 CN Hebei Shijiazhuang Shi 38.0103 114.428 0 Asia/Shanghai populated place
10913870 Hongsheng Dianjia Hongsheng Dianjia,hong sheng dian jia,洪升店家 CN Jilin Siping Shi 43.22822 124.28947 0 Asia/Shanghai populated place
10441284 Potanggengcun Potanggengcun,po tang geng cun,破塘埂村 CN Anhui Lu’an Shi 31.6025 116.28618 0 Asia/Shanghai populated place
12430017 Lufucun Lufucun,lu fu cun,禄福村 CN Guangdong 22.31664 111.12967 0 Asia/Shanghai populated place
1808674 Heilongji CN Henan Nanyang Shi 32.85278 112.15139 0 Asia/Shanghai populated place
11800704 Pingqiaocun Pingqiaocun,ping qiao cun,坪桥村 CN Zhejiang Shaoxing Shi 29.31952 120.71762 0 Asia/Shanghai populated place
1907686 Yichenggou CN Shanxi Xinzhou Shi 39.26587 113.02526 0 Asia/Shanghai populated place
12483270 Zhixicun Zhixicun,zhi xi cun,支溪村 CN Sichuan 31.58319 107.79127 0 Asia/Shanghai populated place
11348107 Wawuping Wawuping,wa wu ping,瓦屋坪 CN Shaanxi Ankang Shi 33.5898 108.6852 0 Asia/Shanghai populated place
12379561 Shuanghecun Shuanghecun,shuang he cun,双合村 CN Heilongjiang 46.6627 131.15813 0 Asia/Shanghai populated place
7514213 Yingzhangcun Yingzhangcun,ying zhang cun,英张村 CN Henan Luohe Shi 33.60818 113.97209 0 Asia/Shanghai populated place
10403909 Jiancun Jiancun,jian cun,简村 CN Henan Nanyang Shi 33.34728 111.3803 0 Asia/Shanghai populated place
7686756 Yongyangcun Yongyang,Yongyangcun,yong yang,yong yang cun,永洋,永洋村 CN Fujian Ningde Shi 26.61168 118.74183 0 Asia/Shanghai populated place
1798746 Pingle P’ing-lo,Pingle,Pingluo,P’ing-lo,ping le,平乐 CN Sichuan Chengdu Shi 30.34704 103.33724 0 Asia/Shanghai populated place
10424141 Hezhai Hezhai,he zhai,贺寨 CN Henan Zhumadian Shi 32.66511 114.65421 0 Asia/Shanghai populated place
7446850 Maliao Maliao,ma liao,麻寥 CN Fujian Sanming Shi 26.54028 116.6521 0 Asia/Shanghai populated place
11443736 Changling Changling,zhang ling,长岭 CN Shanxi Jinzhong Shi 37.59772 113.88939 0 Asia/Shanghai populated place
11273354 Tayucun Tayucun,ta yu cun,塔峪村 CN Shandong Linyi Shi 35.59938 117.80167 0 Asia/Shanghai populated place
1994573 Luojia Luojia,luo jia,骆家 CN Hunan Yongzhou 26.35485 111.12366 0 Asia/Shanghai populated place
10001998 Sandaogou Sandaogou,san dao gou,三道沟 CN Hebei 42.56999 117.53642 0 Asia/Shanghai populated place
10651043 Dunshangcun Dunshangcun,dun shang cun,墩上村 CN Anhui Tongling Shi 31.05937 117.93781 0 Asia/Shanghai populated place
10415985 Zhaishancun Zhaishancun,zhai shan cun,寨山村 CN Anhui Chuzhou Shi 32.68326 118.37983 0 Asia/Shanghai populated place
11756027 Songjiancun Songjiancun,song jian cun,松建村 CN Zhejiang Taizhou Shi 28.31912 121.58768 0 Asia/Shanghai populated place
10020343 Niujiazhai Niujiazhai,niu jia zhai,牛家寨 CN Guizhou Lupanshui Shi 26.1485 105.454 0 Asia/Shanghai populated place
7763111 Baodiancun Baodian,Baodiancun,bao dian,bao dian cun,宝典,宝典村 CN Hainan Wenchang Shi 19.67873 110.87641 0 Asia/Shanghai populated place
11758177 Xizhicun Xizhicun,xi zhi cun,西峙村 CN Zhejiang Taizhou Shi 28.75549 121.45471 0 Asia/Shanghai populated place
12324783 Sanlizhuangcun Sanlizhuangcun,san li zhuang cun,三里庄村 CN Shandong 37.66089 117.59668 0 Asia/Shanghai populated place
7844292 Hongjiazhai Hongjiazhai,hong jia zhai,红家宅 CN Jiangsu Suzhou Shi 31.29641 121.05598 0 Asia/Shanghai populated place
10403277 Tumen Tumen,tu men,土门 CN Henan Nanyang Shi 32.81721 111.63665 0 Asia/Shanghai populated place
9641335 Daxingzhuang Daxingzhuang,da xing zhuang,大兴庄 CN Hebei Baoding Shi 39.39374 115.92893 0 Asia/Shanghai populated place
8227561 Xinshe Xinshe,xin she,新舍 CN Jiangsu Yangzhou Shi 32.81314 119.76744 0 Asia/Shanghai populated place
8398871 Dawan Dawan,da wan,大湾 CN Chongqing Chongqing 30.91516 110.064 0 Asia/Shanghai populated place
11570344 Donggangcun Donggangcun,dong gang cun,东岗村 CN Heilongjiang Shuangyashan Shi 46.75062 131.20172 0 Asia/Shanghai populated place
9630961 Dongyuzhuang Dongyuzhuang,dong yu zhuang,东于庄 CN Hebei Cangzhou Shi 38.2316 116.326 0 Asia/Shanghai populated place
10424577 Lizhuang Lizhuang,li zhuang,李庄 CN Henan Nanyang Shi 32.80705 112.82141 0 Asia/Shanghai populated place
1814603 Dabanqiao Dabanqiao,Ta-pan-ch’iao,Ta-pan-ch’iao CN Yunnan Kunming Shi 25.04667 102.87611 0 Asia/Shanghai populated place
1908985 Gaozhuang CN Henan Pingdingshan Shi 33.79389 112.7575 0 Asia/Shanghai populated place
11798993 Zaoyuancun Zaoyuancun,zao yuan cun,枣园村 CN Zhejiang Jinhua Shi 29.4873 120.0025 0 Asia/Shanghai populated place
12198416 Dongqingyuancun Dongqingyuancun,dong qing yuan cun,东清源村 CN Hebei Baoding Shi 39.45704 115.17279 0 Asia/Shanghai populated place
9930125 Peiquncun Peiqun,Peiquncun,pei qun,pei qun cun,培群,培群村 CN Guangxi Nanning Shi 23.36401 108.44154 0 Asia/Shanghai populated place
10203006 Alajiaxue Alajiaxue,a la jia xue,阿拉甲学 CN Sichuan Garzê Zangzu Zizhizhou 31.8708 100.81 0 Asia/Shanghai populated place
11564798 Sanbuguan Sanbuguan,san bu guan,三不管 CN Heilongjiang Qiqihar Shi 47.29628 123.1229 0 Asia/Shanghai populated place
10272091 Chalincun Chalincun,cha lin cun,查林村 CN Tibet Nagqu Shi 31.31591 91.31345 0 Asia/Shanghai populated place
6919108 Yangjiaci Yangjiaci,yang jia ci,杨家祠 CN Sichuan Neijiang Shi 29.93373 104.61352 0 Asia/Shanghai populated place
8444631 Houyiwoqi Houyiwoqi,hou yi wo qi,后宜卧奇 CN Inner Mongolia Hulunbuir Region 48.5318 124.47914 0 Asia/Shanghai populated place
10874294 Zhiqiangcun Zhiqiangcun,zhi qiang cun,志强村 CN Jilin Baicheng Shi 45.45013 122.45665 0 Asia/Shanghai populated place
10008141 Luzumo Luzumo,lu zu mo,鲁租莫 CN Yunnan Yuxi Shi 24.1357 101.694 0 Asia/Shanghai populated place
9918522 Shuangping Shuangping,shuang ping,双平 CN Guangxi Wuzhou Shi 23.848 110.802 0 Asia/Shanghai populated place
11575376 Liujiatancun Liujiatancun,liu jia tan cun,刘家潭村 CN Jiangsu Yangzhou Shi 33.29388 119.27228 0 Asia/Shanghai populated place
11826564 Xia’antiancun Xia’antiancun,Xia’antiancun,xia an tian cun,下安恬村 CN Zhejiang Jinhua Shi 29.11951 120.18671 0 Asia/Shanghai populated place
9910783 Hongyan Hongyan,hong yan,烘颜 CN Guangxi Baise Shi 24.86096 105.21096 0 Asia/Shanghai populated place

China: Charting the Contours of a Civilization through Its Cities

From Provincial Capitals to Remote County Seats

As a geographer, few countries ignite such a profound sense of scale and complexity as China. It is not merely a nation—it is a mosaic of regions, landscapes, dialects, and administrative layers. Understanding China through its cities is like tracing the circulatory system of a living continent. Each city, from the megapolis of Shanghai to a township tucked into the mountains of Guizhou, reflects a facet of China’s vast human geography. But to truly analyze and appreciate this structure, we must rely on structured, granular, and accessible data—especially in formats that allow fluid exploration, like the newly added Excel (xlsx) version of our dataset.

Administrative Granularity and Geographic Depth

China is subdivided into provinces, autonomous regions, municipalities, and special administrative regions—each with their own constellation of prefectures, counties, and townships. For the geographer, this stratification is not an obstacle but an opportunity: it offers an unparalleled framework for spatial analysis.

That’s why our city-level dataset for China doesn’t stop at names. It links each urban entity directly to its parent region and departmental structure, empowering users to build accurate, scalable models of spatial distribution, demographic density, or economic patterns across all levels of the Chinese administrative ladder.

Mapping Urban Coordinates with Precision

Coordinates are at the heart of geographic understanding. In China, where climatic zones range from subtropical to subarctic, and where tectonic activity, desertification, and water scarcity intersect in complex ways, knowing exactly where a city lies is non-negotiable.

Our dataset includes exact latitude and longitude for each urban area in China. This precision allows users to overlay city data on satellite imagery, construct transportation corridors, or model population clusters with environmental overlays. While we won’t list these coordinates here, they are seamlessly embedded in the downloadable files—ready to fuel your spatial insights.

Why Excel is the Smartest Format for a Giant Like China

For most professionals—urban planners, logistics analysts, academics—Excel (xlsx) remains the gold standard of usability. It bridges the gap between raw geographic data and strategic decision-making.

Incorporating China’s vast city data into Excel means that users can now sort cities by province, filter by county, or create pivot tables to compare development metrics across vast administrative distances. It’s fast, visual, and universal. No need for specialized GIS software—Excel brings geographic data down to earth and into action.

All Formats, One Goal: Access and Flexibility

While Excel takes the spotlight, the full dataset for Chinese cities is available in multiple formats to suit technical needs across disciplines:

* **CSV** for seamless ingestion by analytics platforms and web-based dashboards

* **SQL** for those building structured, relational models

* **JSON** for web developers or API integration

* **XML** for structured data tasks or compatibility with legacy systems

Whether you’re building an AI-powered population model or a market expansion tool, these formats offer flexibility. But for speed and accessibility, Excel is now the cornerstone.

From Megacities to Microcosms

China’s urban geography is not just about Beijing, Guangzhou, and Shenzhen. The real revelations often lie in the lesser-known urban environments—places like Baoshan, Yinchuan, or Ankang. These cities are witnessing transformations in infrastructure, social policy, and climate adaptation that deserve equal attention.

Our dataset ensures that no city—regardless of size or location—is overlooked. This completeness is essential for equity in analysis and for ensuring that strategic planning accounts for the full spectrum of China’s geographic reality.

Conclusion

To study China is to engage with scale on a scale rarely found elsewhere. And in the age of data, understanding China’s urban system means mastering its underlying structure. With our newly expanded dataset—especially in Excel format—you can explore, analyze, and visualize Chinese cities like never before. Whether you’re mapping development potential, identifying regional inequalities, or simply fascinated by the rhythm of China’s spatial evolution, this data is your essential tool. It’s not just about names on a map—it’s about unlocking the logic behind one of the most dynamic geographic landscapes on earth.

Download China cities in Excel SQL CSV JSON XML

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

List of countries :

download-cities-data.org