By
2010-09-02
QGIS
5 Comments

QGIS Now Supports Non-spatial Tables!

Great news everyone: Since revision r14172, QGIS supports non-spatial tables! This means you can finally load your CSV files directly into QGIS and work with them, e.g. use “Join by attribute”.

Loading the CSV file is performed using “Add Vector layer”. (Yes, the terminology is a little confusing here.) The resulting layer will be shown in the legend list and the content can be view via attribute table.

Great work Marco!

5 comments
  1. Klaus Jacobi's avatar

    Yes, I can load non-spatial tables to my TOC and open them. But I see no way to join them to a layer except for saving the result as new layer. Am I right or have I been missing something?

    (using QGIS version r14417)

  3. Edwin Liava'a said:
    Edwin Liava'a's avatar

    You can also use Vector > Data Management Tools > Join Attributes to connect to a .DBF non-spatial data table

  4. Francois said:
    Francois's avatar

    Hi, is there an option for doing this with excel / access too?

    Cheers

    F

    • Edwin Liava'a said:
      Edwin Liava'a's avatar

      Yes, export or save excel/access table in .DBF format. Then use Vector > Data Management Tools > Join Attributes of the spatial layer to the tabular .BDF