{"id":2172,"date":"2016-01-27T04:18:28","date_gmt":"2016-01-27T04:18:28","guid":{"rendered":"https:\/\/grindgis.com\/?p=2172"},"modified":"2016-01-28T00:19:34","modified_gmt":"2016-01-28T00:19:34","slug":"x-and-y-coordinate-qgis","status":"publish","type":"post","link":"https:\/\/grindgis.com\/?p=2172","title":{"rendered":"Add X and Y Coordinate in QGIS"},"content":{"rendered":"

QGIS has become a powerful mapping software and best\u00a0thing is it is free. You can download it from QGIS<\/a> official website. If you do not have a good skill on QGIS tools, then please read my earlier tutorial on QGIS Basics.<\/a> Today I thought I should write tutorial on adding X and Y coordinates from the excel file. If you like to read about adding X and Y coordinates on the ArcGIS then I have written\u00a05 ArcGIS Tips helps you to perform you daily job<\/a>.<\/p>\n

Well if you do not have the QGIS software then download it from its homepage.<\/a> I have few longitude and latitude value of world cities. Remember longitude is always X<\/strong> and latitude is always Y. <\/strong>If you want to practice on this data, then copy this and paste into excel sheet.<\/p>\n

There are are two ways to add X and Y value from Excel into\u00a0QGIS.<\/p>\n

A.\u00a0By converting Excel data into Delimited Text<\/strong><\/h2>\n
\"x<\/div>\n

1.<\/span><\/strong>In excel save the table into the Text (Tab delimited)
\n<\/strong><\/span><\/p>\n

\"excel
\n<\/strong><\/span><\/p>\n

2.<\/span><\/strong>Open the QGIS software, for this example I am using QGIS 2.8.2 version. Now click the Layer > Add Layer > Add Delimited Text Layer.
\n<\/strong><\/span><\/p>\n

\"add
\n<\/strong><\/span><\/p>\n

3.<\/span><\/strong>Browse the saved delimited text file (in our case is Book1.txt), then you can assign the layer name. Select the Custom delimiters <\/strong>which will automatically check mark the Tab option. In table if you already have X and Y field names then it will automatically assigned into appropriate filed, if you have something different then assign your field names in x field<\/strong> and y field. <\/strong>Other option leave as it is, after that press Ok.
\n<\/span><\/strong><\/p>\n

\"create
\n<\/strong><\/span><\/p>\n

4.<\/span><\/strong>Then\u00a0select the appropriate projection system of your x and y values, for above table the coordinate system is WGS84. Then press Ok<\/strong> to finish the process.<\/p>\n

\"Coordinate
\n<\/strong><\/span><\/p>\n

5.<\/span><\/strong>After that you will notice points are plotted on the main window.<\/p>\n

\"Final<\/p>\n

B.\u00a0By using XYTools Plugin<\/strong><\/h2>\n

 <\/p>\n

1.<\/span><\/strong>Download the plugins by going to Plugins>Manage and Install Plugins<\/strong><\/p>\n

\"Plugins\"
\n<\/strong><\/p>\n

2.<\/span><\/strong>Under the search box type\u00a0Xytools and press Install Plugins. This will install Xytools plugin and you will have many option to play with x and y coordinates including adding x and y values directly from excel sheet.<\/p>\n

\"Plugins<\/p>\n

3.<\/span><\/strong>Under Now go to Vector>XY tools>Open Excel File as attribute table or point layer<\/strong>, this will open the browse window.<\/p>\n

\"XYtools<\/p>\n

4.<\/span><\/strong>Browse your excel file, best practice to avoid version conflict save excel file in 2003 format and press open.<\/p>\n

\"browse<\/p>\n

5.<\/span><\/strong>Now select the Coordinate Reference system, for our example is WGS84 and then press OK.<\/p>\n

\"coordinate<\/p>\n

6.<\/span><\/strong>Then assign your X and Y field under X: and Y: drop box.<\/p>\n

\"x<\/p>\n

7.<\/span><\/strong>Points will be plotted on the main window.<\/p>\n

\"final<\/p>\n","protected":false},"excerpt":{"rendered":"

QGIS has become a powerful mapping software and best\u00a0thing is it is free. You can download it from QGIS official website. If you do not have a good skill on QGIS tools, then please read my earlier tutorial on QGIS Basics. Today I thought I should write tutorial on adding X and Y coordinates from […]<\/p>\n","protected":false},"author":1,"featured_media":2178,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[316],"tags":[389,390,388,309,387],"class_list":["post-2172","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-qgis","tag-add-x-and-y","tag-delimited-text","tag-excel-to-qgis","tag-qgis","tag-x-and-y","entry","has-media"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/posts\/2172","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2172"}],"version-history":[{"count":0,"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/posts\/2172\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=\/wp\/v2\/media\/2178"}],"wp:attachment":[{"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2172"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2172"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/grindgis.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2172"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}