<html><head></head><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:16px"><div id="yui_3_16_0_1_1450740922800_566523">Hi Eva,</div><div id="yui_3_16_0_1_1450740922800_566586"><br></div><div id="yui_3_16_0_1_1450740922800_566917">If you want to be able to work with the data as if it was a spreadsheet using Excel, rather than actually create a spreadsheet, it is possible.<br></div><div id="yui_3_16_0_1_1450740922800_566960"><br></div><div id="yui_3_16_0_1_1450740922800_566548">You can open the dbf in Excel as an ODBC data source (don't import to a spreadsheet copy of the dbf). This does NOT create a spreadsheet file with the data, but directly opens the dbf in Excel.<br></div><div id="yui_3_16_0_1_1450740922800_566540">And of course you can open the shapefile in QGIS.</div><div id="yui_3_16_0_1_1450740922800_566547"><br></div><div id="yui_3_16_0_1_1450740922800_566542">Both approaches should allow you to view & edit the content, but I'm not sure if you can open & edit concurrently in both tools.<br></div><div id="yui_3_16_0_1_1450740922800_566451"><span></span></div><div id="yui_3_16_0_1_1450740922800_566843">A more robust approach would be to use Postgis instead of the shapefile, and do the same thing - open the Postgis table via ODBC in Excel & directly in QGIS. The underlying database provides a multi-user & concurrent user control/capability that a shapefile cannot.</div><div id="yui_3_16_0_1_1450740922800_566884"><br></div><div id="yui_3_16_0_1_1450740922800_566885"><br></div><div id="yui_3_16_0_1_1450740922800_566886">Also note that if you are using point features (a bit trickier with lines/polygons but still feasible as WKT columns) you can use a csv file instead of a spreadsheet, & open that in both QGIS & Excel. <br></div><div id="yui_3_16_0_1_1450740922800_566992"><br></div><div id="yui_3_16_0_1_1450740922800_567049">Note that Excel is a single user application, so assumes that it has total control of the data source - which it does not in such cases - so you may need to close & reopen Excel to view changes made to the data by tools other than Excel. A ODBC link is likely to be the best way to get around this.<br></div><div id="yui_3_16_0_1_1450740922800_566450" class="qtdSeparateBR"><div id="yui_3_16_0_1_1450740922800_566668"><br></div><div id="yui_3_16_0_1_1450740922800_566667">Cheers</div><div id="yui_3_16_0_1_1450740922800_566806"><br></div><div id="yui_3_16_0_1_1450740922800_566807">Brent Wood<br></div><br></div><div style="display: block;" id="yui_3_16_0_1_1450740922800_566447" class="yahoo_quoted"> <div id="yui_3_16_0_1_1450740922800_566446" style="font-family: verdana, helvetica, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1450740922800_566445" style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;"> <div id="yui_3_16_0_1_1450740922800_566449" dir="ltr"> <font id="yui_3_16_0_1_1450740922800_566448" face="Arial" size="2"> <hr id="yui_3_16_0_1_1450740922800_566510" size="1"> <b><span style="font-weight:bold;">From:</span></b> Siki Zoltan <siki@agt.bme.hu><br> <b><span style="font-weight: bold;">To:</span></b> Eva Mosquera <eva_mosquera_lopez@hotmail.com> <br><b><span style="font-weight: bold;">Cc:</span></b> "qgis-user@lists.osgeo.org" <qgis-user@lists.osgeo.org><br> <b><span style="font-weight: bold;">Sent:</span></b> Tuesday, December 29, 2015 12:36 AM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Qgis-user] Problem managing data<br> </font> </div> <div id="yui_3_16_0_1_1450740922800_566444" class="y_msg_container"><br>Dear Eva,<br clear="none"><br clear="none">AFAIK there is no direct solution to edit ods/xls/xlsx files from QGIS.<br clear="none">There are two possible scenarios:<br clear="none">1. Edit your speadseet data in Libre|Open|MS office and open it in QGIS <br clear="none">and join it to your spatial data. If your spreadsheet is open in both QGIS <br clear="none">and Excel it can cause trouble.<br clear="none"><br clear="none">2. Open you spreadsheet in QGIS and save as a QGIS editable format (e.g. <br clear="none">dbf, sqlite) and edit these data. If you need again these data in a <br clear="none">spreadsheet convert it back (probably through csv format).<br clear="none"><br clear="none">Hope it helps you,<br clear="none"><br clear="none">Zoltan<br clear="none"><div class="yqt6288483258" id="yqtfd46210"><br clear="none">On Mon, 28 Dec 2015, Eva Mosquera wrote:<br clear="none"><br clear="none">> 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.<br clear="none">> I'm trying to import the database (dbf) in excel but I have problems with the type and characteristics...<br clear="none">> Thank you very much<br clear="none">_______________________________________________<br clear="none">Qgis-user mailing list<br clear="none"><a shape="rect" ymailto="mailto:Qgis-user@lists.osgeo.org" href="mailto:Qgis-user@lists.osgeo.org">Qgis-user@lists.osgeo.org</a><br clear="none">List info: <a shape="rect" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a><br clear="none">Unsubscribe: <a shape="rect" href="http://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank">http://lists.osgeo.org/mailman/listinfo/qgis-user</a></div><br><br></div> </div> </div> </div></div></body></html>