<html><head></head><body><div style="font-family: Verdana;font-size: 12.0px;"><div>You could install the "Spreadsheet Layers" plugin.</div>
<div> </div>
<div>"<!--StartFragment--><span style="color: rgb(0, 0, 0); font-family: Verdana, sans-serif; font-size: 13.333333015441895px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0.4); -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">This plugin adds a "Add spreadsheet layer" entry in "Layer" / "Add new Layer" menu and a corresponding button in the "Layers" toolbar.</span><br style="color: rgb(0, 0, 0); font-family: Verdana, sans-serif; font-size: 13.333333015441895px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0.4); -webkit-text-stroke-width: 0px;"/>
<span style="color: rgb(0, 0, 0); font-family: Verdana, sans-serif; font-size: 13.333333015441895px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-tap-highlight-color: rgba(0, 0, 0, 0.4); -webkit-text-stroke-width: 0px; background-color: rgb(255, 255, 255); display: inline !important; float: none;">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).</span><!--EndFragment-->"</div>
<div> </div>
<div>Regards,</div>
<div>Roland</div>
<div>
<div>
<div name="quote" style="margin:10px 5px 5px 10px; padding: 10px 0 10px 10px; border-left:2px solid #C3D9E5; word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;">
<div style="margin:0 0 10px 0;"><b>Gesendet:</b> Mittwoch, 17. November 2021 um 01:28 Uhr<br/>
<b>Von:</b> "Firstname Lastname" <byron@conjugategeo.com><br/>
<b>An:</b> Qgis-user@lists.osgeo.org<br/>
<b>Betreff:</b> [Qgis-user] excel file with lat long</div>
<div name="quoted-content">
<div>i have a file with a four columns,
<div>latitude, longitude, outcrop name, identifier</div>
<div> </div>
<div>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?</div>
<div>thanks</div>
<div>
<div> </div>
--
<div class="gmail_signature">
<div>Byron Veilleux, MSc. P.Geo
<div>Conjugate Geologic Services Limited</div>
<div>Calgary, Alberta Canada</div>
<div><a href="mailto:byron@conjugategeo.com" onclick="parent.window.location.href='mailto:byron@conjugategeo.com'; return false;" target="_blank">byron@conjugategeo.com</a></div>
<div>Cell:4037108414</div>
</div>
</div>
</div>
</div>
<div id="DAB4FAD8-2DD7-40BB-A1B8-4E2AA1F9FDF2">
<table style="border-top: 1.0px solid rgb(211,212,222);">
<tbody>
<tr>
<td style="width: 55.0px;padding-top: 13.0px;"><a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" target="_blank"><img alt="" height="29" src="https://ipmcdn.avast.com/images/icons/icon-envelope-tick-round-orange-animated-no-repeat-v1.gif" style="width: 46.0px;height: 29.0px;" width="46"/></a></td>
<td style="width: 470.0px;padding-top: 12.0px;color: rgb(65,66,78);font-size: 13.0px;font-family: Arial , Helvetica , sans-serif;line-height: 18.0px;">Virus-free. <a href="https://www.avast.com/sig-email?utm_medium=email&utm_source=link&utm_campaign=sig-email&utm_content=webmail" style="color: rgb(68,83,234);" target="_blank">www.avast.com</a></td>
</tr>
</tbody>
</table>
</div>
_______________________________________________ Qgis-user mailing list Qgis-user@lists.osgeo.org List info: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a> Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a></div>
</div>
</div>
</div></div></body></html>