[Qgis-user] Export Attributes to Excel and import back edited

2020-12-15 Thread Marin Mirosevic
Hi, I want to export Attributes from a Layer as excel format and then Edit some values. Then I want to "import" back to Qgis to the same Layer with updated values of Attribute Is that possible ? If so how? With regards/ Vennlig hilsen Marin Mirosevic Consultant Mobil +47 909 67 511 m

Re: [Qgis-user] Export Attributes to Excel and import back edited

2020-12-15 Thread Ujaval Gandhi
Actually, for point layers - there's a better workflow. Use the 'Add geometry attributes' tool to add X and Y columns before exporting to Excel. After you change your values, use the Processing Toolbox -> Create Points layer from Table which can read Excel file directly from disk and give you a vec

Re: [Qgis-user] Export Attributes to Excel and import back edited

2020-12-15 Thread Ujaval Gandhi
Right click -> Export -> Save Features As and select 'MS Office Open XML spreadsheet'. Save it as a '.xlsx' file. Once you are done editing, drag-and-drop it to QGIS and it will be imported as a table. If you want the shapes, you'll have to join the table to the original layer using 'Join Attribute