Re: [Qgis-user] excel file with lat long

[Garth Fletcher]

Be careful if you are using "DMS" format (42º17'35.123'') to use the 
right symbols.
In my experience, using Mac OS X, option-zero for the degree symbol is 
accepted, but option-k, which also makes a degree symbol, is not.  
Similarly, "smart quotes", i.e., those which tilt, are rejected for 
minutes, as are double quotes for seconds.


As long as you use the right symbols it works perfectly.  Of course if 
you are using decimal degrees (42.123456) there is no problem.


--
Garth Fletcher

___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] excel file with lat long

[Roland Spielhofer]

You could install the "Spreadsheet Layers" plugin.

 

"This plugin adds a "Add spreadsheet layer" entry in "Layer" / "Add new Layer" menu and a corresponding button in the "Layers" toolbar.
These two links open the same dialog to load a layer from a spreadsheet file (*.ods, *.xls, *.xlsx) with some options (use header at first line, ignore some rows and optionally load geometry from x and y fields)."

 

Regards,

Roland

 
 

Gesendet: Mittwoch, 17. November 2021 um 01:28 Uhr
Von: "Firstname Lastname" 
An: Qgis-user@lists.osgeo.org
Betreff: [Qgis-user] excel file with lat long


i have a file with a four columns,  
latitude, longitude, outcrop name, identifier

 

how do i import an excel file, do i need to convert to a text file and how do i assign the format in qgis to import as lat long?

thanks

 
 
--


Byron Veilleux, MSc. P.Geo
Conjugate Geologic Services Limited

Calgary, Alberta Canada

by...@conjugategeo.com

Cell:4037108414





 

	
		
			
			Virus-free. www.avast.com
		
	


___ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user



___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user

Re: [Qgis-user] excel file with lat long

[Ujaval Gandhi]

Drag and drop the Excel file to QGIS. Then use the “ Points layer from
table” tool from the Processing Toolbox to create a point layer from it.

On Wed, 17 Nov 2021 at 5:58 AM, Firstname Lastname 
wrote:

> i have a file with a four columns,
> latitude, longitude, outcrop name, identifier
>
> how do i import an excel file, do i need to convert to a text file and how
> do i assign the format in qgis to import as lat long?
> thanks
>
>
> --
> Byron Veilleux, MSc. P.Geo
> Conjugate Geologic Services Limited
> Calgary, Alberta Canada
> by...@conjugategeo.com
> Cell:4037108414
>
>
> 
>  Virus-free.
> www.avast.com
> 
> <#m_-3135534670972974893_DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2>
> ___
> Qgis-user mailing list
> Qgis-user@lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>
-- 
[image: Logo] 
Ujaval Gandhi
Spatial Thoughts
mobile: +91-8095684687
email: uja...@spatialthoughts.com
[image: LinkedIn icon]   [image:
Twitter icon] 
___
Qgis-user mailing list
Qgis-user@lists.osgeo.org
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user