I'm using QGIS 2.0.1

The table is in an excel format that i import through "add vector" and the shapefile is a polygone

I join the attributes by right clicking the polygone-->properties-->join Then once done if i look at the attributes table of the polygone everything is fine But when i do save as shapefile and add the new layer, all the data of the attribute table is there expect that the titles of the columns become data1, data2

Does anyone knows how to fix it? or maybe i'm doing something wrong?


  • I forgot to specify it s when i export it to a new shapefile. also the table is an excel format. thx
    – MarineSen
    Feb 27, 2014 at 11:19
  • You can (and probably should) edit your post (instead of adding comments). Short questions are discouraged on this site. Try to be as descriptive as possible. Feb 27, 2014 at 11:30

1 Answer 1


The .dbf of a shapefile has certain limits on the columns names, e.g. number of characters needs to be <11 characters, and that there cannot be spaces in the column names. I'm guessing when you export out to a new shapefile the function finds these errors and attempts to generate a valid column name.

Make sure your column names are shapefile friendly before performing the join.

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.