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?

1 Answer 1


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.

  • 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'". ) Feb 26, 2015 at 8:12
  • It fails to open the file you want to save to?
    – Martin
    Feb 26, 2015 at 8: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. Feb 26, 2015 at 8:20
  • Probably you still have the layer in edit mode. Try to close all edit modes and try to save again.
    – Martin
    Feb 26, 2015 at 8:23
  • @DarthFreder - Awesome! Please accept this answer (click the faded tick on the left-hand side) to close off this question.
    – Joseph
    Feb 26, 2015 at 12:07

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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