1

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?

the error message

Improve this question
1
  • See here here for additional information
    – dmci
    Jan 21, 2016 at 23:34

2 Answers 2

Reset to default
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.

Improve this answer
0

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

Improve this answer
1
  • 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, 2016 at 18:31

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.