[Qgis-user] Convert spreadsheet (excel) to vector (shape) of Points

[pcreso at pcreso.com]

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 <sig.upagu at gmail.com> wrote:

From: Carlos Cerdán <sig.upagu at gmail.com>
Subject: Re: [Qgis-user] Convert spreadsheet (excel) to vector (shape) of Points
To: qgis-user at lists.osgeo.org
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
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user

    
    

  


-----Inline Attachment Follows-----

_______________________________________________
Qgis-user mailing list
Qgis-user at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20120724/a4dad661/attachment.html>