1

I'm trying to add Excel sheet as a point layer, that includes coordinates into QGIS.

Instead of a shapefile, it comes as attribute table (layer name is shown and attribute table logo beside it instead of point layer) and the layer doesn't appear in the canvas. What I am doing wrong?

closed as unclear what you're asking by ahmadhanb, Fran Raga, Vince, Dan C, Taras Jun 25 at 13:04

Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.

1

You would have to save your Excel sheet as a CSV file. That file can be imported in QGIS (layers -> add layer-> add comma separated value layer). Once you do that, a screen should pop up where you can set your x- and y-coordinates among other settings.

0

You are not doing anything wrong, it's just that an excel file IS an (attribute) table, it doesn't contain any geometry, if you want to display it as point you have to use one steep more to tell QGIS what attributes needs to be converted to geometry.

The first way of doing this is to convert your Excel to CSV as when adding a SCV you could specify geometry column, if you can't/dont want to convert your Excel file to CSV you could import it as a table (as you already did) and use the "Create Point Layer From Table" tool (you'll find it in the Processing Toolbox, in the Vector creation group)

enter image description here

Not the answer you're looking for? Browse other questions tagged or ask your own question.