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?
Best Answer
P
Petr Voldan
said
almost 5 years ago
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.
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
G
Gábor Zvara
said
almost 5 years ago
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.
Petr Voldan
said
almost 5 years ago
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
Gábor Zvara
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?
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
- Oldest First
- Popular
- Newest First
Sorted by Oldest FirstPetr Voldan
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
Gábor Zvara
Petr Voldan
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
Gábor Zvara
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.
Petr Voldan
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.
-
No sound on 'Guide On'
-
Locus GIS Basic version limitations
-
usage of beta versions
-
SHP to DWG vith atributes
-
11th Hungarian GIS Conference and Exhibition
-
Problem with Selektion Attributes after (re-)import
-
Different colors for different attribute values
-
Import Shapefile Map Value
-
Sharing project
See all 55 topics