Start a new topic
Discussions Community Questions
Answered

Exported CSV separation characters

 Hi, I've exported a data layer to CSV, opened it, and noticed that all the columns, including Y geometry are supplied with quote marks, except for the first, X geometry. Is this on purpose, or a mistake in format?


image

Best Answer

Thank you for the file. There is no problem with the CSV file. Please see attached screenshot. The fields are correctly quoted in the raw csv text. I think that there is some problem when you open file in Excel. Please try to check some settings in your excel how it handle the quotation marks when it opens the CSV file.


I can also suggest to try LibreOffice where it's possible to define quotation mark during import.


Petr

 

5 CommentsSorted by Oldest First

Hi,

tried to export Tress layer from sample "Trees monitoring" as CSV, but it seems to be OK. Would you please send me your .CSV file?

Thanks, Petr

CSV attached, thank You!
csv
biotika19.csv
(1.07 KB)
Answer

Thank you for the file. There is no problem with the CSV file. Please see attached screenshot. The fields are correctly quoted in the raw csv text. I think that there is some problem when you open file in Excel. Please try to check some settings in your excel how it handle the quotation marks when it opens the CSV file.


I can also suggest to try LibreOffice where it's possible to define quotation mark during import.


Petr

 

Thank you! Actually, I could import csv file to QGIS properly, I just couldn't understand why is the difference on the columns with the quote marks. Perhaps there are some setting during import, as you said. Thanks again.

OK Fine. I'm sorry but I'm not so familiar with Excel, so I can't give you better advice but for example mentioned LibreOffice opens it properly

Thank you.

Login or Signup to post a comment
More topics in Questions
See all 55 topics
Help Desk Software by Freshdesk