8

I am using QGIS 2.6.1 and have worked in an Excel file database (which was actually converted from a Shapefile). I have managed to convert it as CSV file and load it into QGIS (displays data fine) but I have trouble to convert it to a shapefile.

I can view it but I can´t add or alter data in this file. I think I have to save it as a database.

Any clues how to convert the xlsl-data to a database and finally to a shapefile?

nmtoken
  • 13,355
  • 5
  • 38
  • 87
Darth Freder
  • 81
  • 1
  • 1
  • 2

1 Answers1

6

You can save the csv layer as shapefile to edit the data.

Therefore right click the added csv layer in the layer menue and select Save as....

Following dialog will open:

enter image description here

Now you can save your csv as shapefile. The resulting shapefile is editable.

Martin
  • 2,908
  • 4
  • 22
  • 44
  • I tried this multiple times but I alwas get the (German) error code "Export in Vektordatei schlug fehl. Fehler: Layererzeugung schlug fehl (OGR-Fehler: Failed to open Shapefile `test.shp'". ) – Darth Freder Feb 26 '15 at 08:12
  • It fails to open the file you want to save to? – Martin Feb 26 '15 at 08:15
  • Yes but I am currently working on it. I just managed to get a copy saved as shp but my main file is still complaining. But I am positive that I will get it done. Probably, I have to rename or close the main file. Will try out. Thanks. – Darth Freder Feb 26 '15 at 08:20
  • Probably you still have the layer in edit mode. Try to close all edit modes and try to save again. – Martin Feb 26 '15 at 08:23
  • @DarthFreder - Awesome! Please accept this answer (click the faded tick on the left-hand side) to close off this question. – Joseph Feb 26 '15 at 12:07