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

[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 vector layer.
[image: Logo] <https://spatialthoughts.com/>
Ujaval Gandhi
Spatial Thoughts
mobile: +91-8095684687
email: ujaval at spatialthoughts.com
[image: LinkedIn icon] <https://www.linkedin.com/in/spatialthoughts/>  [image:
Twitter icon] <https://twitter.com/spatialthoughts>



On Tue, Dec 15, 2020 at 10:38 PM Ujaval Gandhi <ujaval at spatialthoughts.com>
wrote:

> 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
> Attributes by Field value' tool in the processing toolbox.
>
> [image: Logo] <https://spatialthoughts.com/>
> Ujaval Gandhi
> Spatial Thoughts
> mobile: +91-8095684687
> email: ujaval at spatialthoughts.com
> [image: LinkedIn icon] <https://www.linkedin.com/in/spatialthoughts/>  [image:
> Twitter icon] <https://twitter.com/spatialthoughts>
>
>
>
> On Tue, Dec 15, 2020 at 10:04 PM Marin Mirosevic <
> marin.mirosevic at bouvet.no> wrote:
>
>> 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
>>
>> *marin.mirosevic at bouvet.no <marin.mirosevic at bouvet.no>*
>>
>>
>>
>>
>>
>> *Bouvet Norge AS*
>>
>> *bouvet.no* <http://www.bouvet.no/>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Qgis-user mailing list
>> Qgis-user at lists.osgeo.org
>> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
>> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20201215/d19d0280/attachment.html>