[Qgis-user] Export to vector layer to CSV with coordinates

[Alex Mandel]

On 02/25/2011 11:34 AM, Václav Řehák wrote:
> 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.
> 
> I know this should be rather done in QGIS itself but there are users
> used to Excel that find QGIS difficult to use for this kind of
> operations.
> 
> Thank you.
> 
> Vaclav

Such an export can easily be written as a python plugin or done on the
command line with ogr2ogr. If you're interested I can dig up a kml
example that could be changed to csv easily.

I highly advise against allowing users to "filter" data in a
spreadsheet, in fact I have a whole section of my thesis (in progress)
dedicated to why this is a terrible idea for data integrity. As an
alternative you could either teach them to do it in QGIS, or use a
database and connect their spreadsheet to the database via odbc to allow
for editing from Excel.

Suggestions would also be welcome on how to improve the QGIS interface
to make this easier for users.

Thanks,
Alex