With version 1.7 you can load text files with a WKT column, so you don't need to convert text to columns (unless need to use the coordinates for processing in the spreadsheet). This also means you can export and import lines and polygons as well as point layers.
Cheers Chris ________________________________________ From: Goyo [[email protected]] Sent: 27 February 2011 15:54 To: Václav Řehák Cc: [email protected] Subject: Re: [Qgis-user] Export to vector layer to CSV with coordinates 2011/2/25 Václav Řehák <[email protected]>: > Hi list, > > is there a way how to export vector layer to a csv file including the > coordinates? The "Save as..." - "Comma Separated Value" command > exports only the attributes but my users would like to export the > data, perform some processing (such as filtering) in Excel and load > the data as a new layer. This is what I do. Select the features in QGIS, copy, paste into your spreadsheet app. The geometries are pasted as WKT in the first column. Use "Text to columns" feature (this depends on your app) if you want the coordinates as numbers. This works only for points and shouldn't be necessary since the text import plugin seems to understand WKT. Do your stuff, then select all cells, copy and paste into a text file for use with QGIS. This is indeed a terrible idea for data integrity but if you work with shapefiles, dbf and text files you haven't got data integrity anyway. Goyo ______________________________________________________________________________________________________ This message contains information, which is confidential and may be subject to legal privilege. If you are not the intended recipient, you must not peruse, use, disseminate, distribute or copy this message. If you have received this message in error, please notify us immediately (Phone 0800 665 463 or [email protected]) and destroy the original message. LINZ accepts no responsibility for changes to this email, or for any attachments, after its transmission from LINZ. Thank you. ______________________________________________________________________________________________________ _______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
