HOW TO CONVERT MICROSOFT EXCEL FILE TO A SHAPEFILE

1.I will be using QGIS 2.8 for this tutorial and an excel file containing X and Y coordinates of crops affected by bacterial diseases in Western Kenya.The data was collected using a handheld GPS.




2.In QGIS go to Layer>Add Layer>Add delimited layer.




3.Browse the location of the excel file and under the x-field,put the column containing the Easting,and y-field the northings.

4.Click OK and choose the appropriate reference system in the coordinate reference system selector window that pop-ups.



5.Finally,right click on the loaded excel file and save it as a shapefile.