Hi Eduardo I'm not sure if exporting your data as it is to CSV will work. I think you'll need to create columns with lat & long values as decimal degrees to read it in as delimited text with QGIS.
Given lon_d (a), lon_m (b) & lon_s (c) columns in your spreadsheet you can generate a longitude column via a formula in a new column, (assuming all your values are positive) something like this in cell D1: =(A1+(B1+(C1/60))/60) repeat for latitudes, then export as CSV as suggested. If your values are character strings with non-numeric strings (like ' for minutes), it is a bit trickier, but you could use the SUBSTITUTE() function to trim the unwanted character so you have a number to use, like: =SUBSTITUTE(A1,"º","",1)+((SUBSTITUTE(B1,"'","")+(SUBSTITUTE(C1,"'","")/60))/60) Hope this helps, Brent Wood --- On Wed, 7/25/12, Carlos Cerdán <[email protected]> wrote: From: Carlos Cerdán <[email protected]> Subject: Re: [Qgis-user] Convert spreadsheet (excel) to vector (shape) of Points To: [email protected] Date: Wednesday, July 25, 2012, 2:08 PM Hi Eduardo: Save your data as a semicolon separated CSV file, and in QGIS use "layer --> add delimited text layer" (QGIS 1.8). It's better to use semicolon to prevent problems with decimal coma. -------------- Guarda tu información como un archivo de texto CSV, separado por punto y coma. En QGIS utiliza la opción "capa ---> añadir capa de texto delimitado" (QGIS 1.8). Es mejor usar archivo de texto separado con punto y coma porque a veces el separador decimal es coma (según la configuración de tu sistema operativo). Si no se logra importar tu archivo de texto porque no reconoce las coordenadas, tendrás que cambiar el separador decimal de punto a coma o viceversa. Suerte Saludos desde Cajamarca - Perú El 23/07/12 17:04, Eduardo Arévalo escribió: Hello I'm Eduardo from Peru qgis initial user: excuse the bad English I'm using the google translator. I have a file format spreadsheet in which I have weather information of the fields (columns) of this file are the geographical coordinates of the stations (latitude, longitude and altitude) in degrees, minutes and seconds eg 21 º 23 '12' ' What I do is convert this file into a vector (shape) of points. what procedure I should follow. Thank you very much. _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user -----Inline Attachment Follows----- _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
