I have a spreadsheet which has columns (X, Y, Att1, Att2 ...). I want to create a point shapefile, all columns in the spreadsheet to be the column in the shapefile. How can I do this in QGIS?
You will use the Delimited Text Import feature as a one time process.
Save the spreadsheet as .csv (comma separated value) then import it into QGIS via the menu command
LAYER|ADD DELIMITED TEXT LAYER
Many of the options can remain preset, although likely you will have to choose which columns hold the x y data. You may also have to select a CRS (coordinate reference system) as the second stage of the wizard. For instance for x y in decimal degrees you can choose EPSG:4326
Once the data has been imported, you then right click on the new layer and
SAVE AS an ESRI Shapefile to create the shp format.
There is also the ability to read xl files directly but this is troublesome IMHO and does not create a shapefile.
- Convert your spreadsheet to CSV(comma separated values) using MS Office or OpenOffice
- Use QGIS text delimited layer plugin to import your xy data file.
- Select X(Longitude/Easting) and Y(Latitude/Norhting) and press OK
- In CRS window select CRS (for example WGS84) & Press OK
- In the Layers section select the recently imported layer right click and save as shapefile.