Exercise – 5 / How to Create Shapefile's from Excel in QGIS Create centroids from Excel / CSV data. Many times, the GIS data comes in a table or an Excel spreadsheet. Also, if you have a list lat/long or X & Y coordinates, you can easily import this data in your GIS project. Open the excel data for lat/long or X & Y coordinates. Figure 144 - Excel Data with X & Y coordinates Convert Excel data into CSV format. Figure 145 - Saving Excel data from xlsx format to csv format Choose Layer → Add Layer → Add Delimited Text Layer Figure 146 Add Delimited Text Layer Window Click on to browse the csv file Under Record and Fields Option, follow as per the figure 141 Figure 147– Record and Fields Options Check Geometry Definition and follow as per the figure 142 Figure 148 – Geometry Definitions Check for X field and Y fields, if it is lat/long mention X field as Longitude and Y fields as Latitude Select Geometry CRS and provide the CRS information. Click on Add button and ...
This blog is to learn basic concepts of GIS in Telugu. We will teach ARCGIS, ARCMAP, QGIS, Opensource Geoserver in simple and understandable language.