# Display of DIVA-GIS Gazetteer *.dbf Files in QGIS

I've looked through other questions/answers and not seen what I am looking for…

1. How do I display the contents of a DIVA-GIS Gazetteer *.dbf file in QGIS?

Ideally I would like to take contents of the dbf and display a symbol according to coordinate(s), defining symbol character from another column and finally labelling according to a fourth column.

I think the easiest way is to open the DBF file in a Spreadsheet software (e.g., LibreOffice Calc or Excel), export it to CSV, and open it in QGIS using theAdd Delimited Text Layertool (find it inLayer-->Add Layer-->).

Being there, you can select fields for longitude (X field) and latitude (Y field).

Once points are loaded into QGIS, right click on that layer and go toProperties-->Style. ChooseCategorizedin the very first combo box. Select the field you want the symbology to be based on and click onClassifyandOK.

Finally, for labeling points, go toProperties-->Labels, activate theLabel this layer withcheck box, select the field you want labels from, and clickOK.

You should see a result like this (I'm using DIVA-GIS Gazetteer data for Colombia):

Of course, you can set your own symbology and labeling properties, such as color, shape, font, and the like.