FYI it works the copy-paste way. When being in the attribute table in mode editing, with ctrl+a to select all and then ctrl+c to copy and then paste it into the excel file! cheers=)
I have exported the data with the long. & latitude valus of a centroid of the vectors and imported the csv in excel but in one of the two values the decimal point was not reported and also trafmormation in Power qy do not help me....the direct convertion in xlsx works
Whenever I export to CSV the different attributes (ID-X-Y) wont open up in excel in different columns. What did you do so you have the information in different columns? Thanks alot!
Just change the option for all features to selected features. When you right click on the layer to export you should also have the option to only export selected features.
Hey! I was wondering if you happen to know the answer to this. Is it possible to give a singular vector point information from multiple rows of a table? So let's say I have an excel table that I have open in QGIS that I have joined to a point shapefile which will represent the locations of different land properties owned by people. The table has the following information: ID: (simple number, every row has a unique ID) Owner name: Property name: Property address: Property type: Hectares: If I make a new point on this map it will ask to fill in the ID associated with this point. Once I fill it in all other information in the same row of the ID will be copied from the excel tabel. For example I make point on the map, it asks me for the ID associated with that point, and I fill in 1. It will then immediately fill in the rest for me. ID: 1 Owner name: Bob Property name: Bob's plantation Property address: Willowlane 4 Property type: Building Hectares: 1.2 Three rows in this table have the same Owner name, Property, name, and Property address (for example: Bob, Bob's plantation, Willowlane 4). But everything else is different. (So for example the ID: 2, Property type: Farmland, Hectares 2000. And the third row has ID: 3, Property type: forest, Hectares: 320). Now I want 1 point to represent these 3 rows in such a way that if I used the object identification cursor on that point that it will show all three in the identificaiton tab. Ideally there'd be some kind of way that'd let me fill in the ID's of the 3 different rows whenever I make a new point. Sorry for making such a request and thank you for your time.
not sure if I fully understand what you are asking for but I would structure your dataset in three distinct tables and attributes with a shared ID, then you can join them to give you all info at once
FYI it works the copy-paste way. When being in the attribute table in mode editing, with ctrl+a to select all and then ctrl+c to copy and then paste it into the excel file! cheers=)
Thank you very much. Greetings from Quetzaltenango, Guatemala.
You are welcome!
Thank you so very much for this tutorial.
You are so welcome!
Merci beaucoup, je suis sauvé ! 👍
Thank you very much for a great explanation in this tutorial,
You are welcome!
Thank you! This was very helpful.
You're welcome!
Thank you so much. It really does helped a lot :)
Glad it helped!
I have exported the data with the long. & latitude valus of a centroid of the vectors and imported the csv in excel but in one of the two values the decimal point was not reported and also trafmormation in Power qy do not help me....the direct convertion in xlsx works
Whenever I export to CSV the different attributes (ID-X-Y) wont open up in excel in different columns.
What did you do so you have the information in different columns?
Thanks alot!
Very helpful. Thanks!
You're welcome!
Thank you sir.
Most welcome
How can I export the Selected features... into CSV/Excel?
Just change the option for all features to selected features. When you right click on the layer to export you should also have the option to only export selected features.
Hey! I was wondering if you happen to know the answer to this. Is it possible to give a singular vector point information from multiple rows of a table?
So let's say I have an excel table that I have open in QGIS that I have joined to a point shapefile which will represent the locations of different land properties owned by people. The table has the following information:
ID: (simple number, every row has a unique ID)
Owner name:
Property name:
Property address:
Property type:
Hectares:
If I make a new point on this map it will ask to fill in the ID associated with this point. Once I fill it in all other information in the same row of the ID will be copied from the excel tabel.
For example I make point on the map, it asks me for the ID associated with that point, and I fill in 1. It will then immediately fill in the rest for me.
ID: 1
Owner name: Bob
Property name: Bob's plantation
Property address: Willowlane 4
Property type: Building
Hectares: 1.2
Three rows in this table have the same Owner name, Property, name, and Property address (for example: Bob, Bob's plantation, Willowlane 4). But everything else is different. (So for example the ID: 2, Property type: Farmland, Hectares 2000. And the third row has ID: 3, Property type: forest, Hectares: 320).
Now I want 1 point to represent these 3 rows in such a way that if I used the object identification cursor on that point that it will show all three in the identificaiton tab. Ideally there'd be some kind of way that'd let me fill in the ID's of the 3 different rows whenever I make a new point.
Sorry for making such a request and thank you for your time.
not sure if I fully understand what you are asking for but I would structure your dataset in three distinct tables and attributes with a shared ID, then you can join them to give you all info at once
very helpful
Thank you!
You're welcome!
Thank you!
You're welcome!