[Qgis-user] Problem managing data

Siki Zoltan siki at agt.bme.hu
Mon Dec 28 03:36:44 PST 2015


Dear Eva,

AFAIK there is no direct solution to edit ods/xls/xlsx files from QGIS.
There are two possible scenarios:
1. Edit your speadseet data in Libre|Open|MS office and open it in QGIS 
and join it to your spatial data. If your spreadsheet is open in both QGIS 
and Excel it can cause trouble.

2. Open you spreadsheet in QGIS and save as a QGIS editable format (e.g. 
dbf, sqlite) and edit these data. If you need again these data in a 
spreadsheet convert it back (probably through csv format).

Hope it helps you,

Zoltan

On Mon, 28 Dec 2015, Eva Mosquera wrote:

> Hello everybody!I need to use the data I have in my shpfile in qgis in excel. I need an excel spreadsheet that is able by itself to keep updated with the data changes in qgis. And I don't know how to do this.
> I'm trying to import the database (dbf) in excel but I have problems with the type and characteristics...
> Thank you very much



More information about the Qgis-user mailing list