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

  • See here here for additional information – dmci Jan 21 '16 at 23:34
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.

0

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

  • 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

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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