XyTools QGIS plugin for attribute export

Question

I want to export an attribute table to Excel. I see XyTools is used for that (is there another plugin?). Since I installed QGIS from OSGeo4W, I have the required library. However, when I tell XyTools to export the table, I get the following Python error message: UnicodeEncodeError: 'ascii' codec can't encode character u'\xfc' in position 0: ordinal not in range(128) because my table contains nonASCII characters, which is not that unusual, especially for foreign languages. My question is: Is there a fix or workaround this issue or another plugin to export an attribute table to Excel?

See here here for additional information – dmci Jan 21 '16 at 23:34 — dmci, Jan 21 '16 at 23:34

score 2 · Answer 1 · answered Jan 21 '16 at 22:43

2

You can use Save As from the layer popup menu to save attribute table to a CSV file which can be opened by Excel.

answered Jan 21 '16 at 22:43

Zoltan

7,325
17
27

score 0 · Answer 2 · answered Jan 22 '16 at 07:37

0

If your layer is a shapefile, you can also open the *.dbf file with Excel and save it as *.xls format.

answered Jan 22 '16 at 07:37

wiltomap

2,690
2
22
52

Yes, I know about saving to CSV file and opening a DBF. I was looking for a more direct way, and frankly, can't believe XY Tools can be so limited not to handle Unicode :o – Marko Jan 22 '16 at 18:31

XyTools QGIS plugin for attribute export

2 Answers2