Skip to main content
Geographic Information Systems

Return to Question

edited title
Link
PolyGeo ♦
PolyGeo ♦
  • 65.4k
  • 29
  • 114
  • 345

How to join Joining data from excelExcel to an attribute table in QGIS without creating duplicates?

Notice removed Improve details by Laurent Robitaille-Lainesse
Bounty Ended with Artec's answer chosen by Laurent Robitaille-Lainesse
spelling, cvs to csv, joins tag
Source Link
edit approved Mar 29, 2016 at 20:13
Community Bot
edit approved Mar 29, 2016 at 20:13
Community Bot
  • 1

I have an attribute table with two empty fields in QGIS.

Example_1

I want to import an excel database to fill my empty fields in QGIS. My excel file matchmatches the columns in my QGIS attribute table.   

Example_2

I am able to properly join my excel (.CVSCSV) to my shapefile. However,the process, instead of filling the blank fields as iI wish, created duplicates. With the help of « Table Manager » iI am able to correct the situation, but it requires a lot of time. I am looking for a more efficient way to join my excel data.

Example_3

How can iI join my excel file to my attribute table without creating duplicates  ?

I have an attribute table with two empty fields in QGIS.

Example_1

I want to import an excel database to fill my empty fields in QGIS. My excel file match the columns in my QGIS attribute table.  Example_2

I am able to properly join my excel (.CVS) to my shapefile. However,the process, instead of filling the blank fields as i wish, created duplicates. With the help of « Table Manager » i am able to correct the situation, but it requires a lot of time. I am looking for a more efficient way to join my excel data.

Example_3

How can i join my excel file to my attribute table without creating duplicates  ?

I have an attribute table with two empty fields in QGIS.

Example_1

I want to import an excel database to fill my empty fields in QGIS. My excel file matches the columns in my QGIS attribute table. 

Example_2

I am able to properly join my excel (.CSV) to my shapefile. However,the process, instead of filling the blank fields as I wish, created duplicates. With the help of « Table Manager » I am able to correct the situation, but it requires a lot of time. I am looking for a more efficient way to join my excel data.

Example_3

How can I join my excel file to my attribute table without creating duplicates?

Notice added Improve details by Laurent Robitaille-Lainesse
Bounty Started worth 50 reputation by Laurent Robitaille-Lainesse
Adding precisions
Source Link
Laurent Robitaille-Lainesse
Laurent Robitaille-Lainesse
  • 828
  • 2
  • 11
  • 29

How to join data from excel to an attribute table in QGIS? without creating duplicates

I have a vector layer with an empty attribute table with two empty fields in QGIS.

Example_1

I want to import an excel database to fill themy empty attribute tablefields in QGIS. My excel file match the columns in my QGIS attribute table. Example_2

How do I proceedam able to importproperly join my excel (.CVS) to my shapefile. However,the process, instead of filling the blank fields as i wish, created duplicates. With the help of « Table Manager » i am able to correct the situation, but it requires a lot of time. I am looking for a more efficient way to join my excel data.

Example_3

How can i join my excel file to QGISmy attribute table without creating duplicates ?

How to join data from excel to an attribute table in QGIS?

I have a vector layer with an empty attribute table in QGIS. I want to import an excel database to fill the empty attribute table in QGIS. My excel file match the columns in my QGIS attribute table.

How do I proceed to import my excel file to QGIS?

How to join data from excel to an attribute table in QGIS without creating duplicates

I have an attribute table with two empty fields in QGIS.

Example_1

I want to import an excel database to fill my empty fields in QGIS. My excel file match the columns in my QGIS attribute table. Example_2

I am able to properly join my excel (.CVS) to my shapefile. However,the process, instead of filling the blank fields as i wish, created duplicates. With the help of « Table Manager » i am able to correct the situation, but it requires a lot of time. I am looking for a more efficient way to join my excel data.

Example_3

How can i join my excel file to my attribute table without creating duplicates ?

Tweeted twitter.com/StackGIS/status/704155756942237696
edited tags
Source Link
Joseph
Joseph
  • 76.3k
  • 7
  • 172
  • 286
Source Link
Laurent Robitaille-Lainesse
Laurent Robitaille-Lainesse
  • 828
  • 2
  • 11
  • 29