<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;">Hi Eduardo<br><br>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.<br><br>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:<br>=(A1+(B1+(C1/60))/60) <br><br>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:<br><br> =SUBSTITUTE(A1,"º","",1)+((SUBSTITUTE(B1,"'","")+(SUBSTITUTE(C1,"'","")/60))/60)<br><br><br>Hope this helps,<br><br> Brent
Wood<br><br>--- On <b>Wed, 7/25/12, Carlos Cerdán <i><sig.upagu@gmail.com></i></b> wrote:<br><blockquote style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"><br>From: Carlos Cerdán <sig.upagu@gmail.com><br>Subject: Re: [Qgis-user] Convert spreadsheet (excel) to vector (shape) of Points<br>To: qgis-user@lists.osgeo.org<br>Date: Wednesday, July 25, 2012, 2:08 PM<br><br><div id="yiv540968342">
<div>
<div class="yiv540968342moz-cite-prefix">Hi Eduardo:<br>
<br>
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.<br>
<br>
--------------<br>
<br>
<br>
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). <br>
<br>
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.<br>
<br>
Suerte<br>
<br>
Saludos desde Cajamarca - Perú<br>
<br>
<br>
El 23/07/12 17:04, Eduardo Arévalo escribió:<br>
</div>
<blockquote type="cite">
<div>Hello I'm Eduardo from Peru qgis initial user:</div>
<div>excuse the bad English I'm using the google translator.</div>
<div>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' '</div>
<div>What I do is convert this file into a vector (shape) of
points.</div>
<div>what procedure I should follow.</div>
<div>Thank you very much.</div>
<br>
<fieldset class="yiv540968342mimeAttachmentHeader"></fieldset>
<br>
<pre>_______________________________________________
Qgis-user mailing list
<a rel="nofollow" class="yiv540968342moz-txt-link-abbreviated" ymailto="mailto:Qgis-user@lists.osgeo.org" target="_blank" href="/mc/compose?to=Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a>
<a rel="nofollow" class="yiv540968342moz-txt-link-freetext" target="_blank" href="http://lists.osgeo.org/mailman/listinfo/qgis-user">http://lists.osgeo.org/mailman/listinfo/qgis-user</a>
</pre>
</blockquote>
<br>
</div>
</div><br>-----Inline Attachment Follows-----<br><br><div class="plainMail">_______________________________________________<br>Qgis-user mailing list<br><a ymailto="mailto:Qgis-user@lists.osgeo.org" href="/mc/compose?to=Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br></div></blockquote></td></tr></table>