Upload csv into QGISHow to duplicate a map layer at most once as the bottom layer in qgis3 (python)Open FileGDB Using QGIS 3 + OSXSetting Attribute form window resizable in QGIS 3?PyQGIS import csv- QGIS 3.4Grouping layers using PyQGIS makes them not visible on canvas?How to fix the geocode error: UnicodeEncodeError ascii codec can't encode character ufeff and xfcQGIS Server 3.4 - No labels in WMSConfusing result of raster calculator in QGISQGIS — Extract Values from KDE raster to orginal point data layerConvert point layer to raster QGIS 3
Do I need to be legally qualified to install a Hive smart thermostat?
PhD: When to quit and move on?
Should I hide my travel history to the UK when I apply for an Australian visa?
Fine-tuning parameters for existing methods
gzip compress a local folder and extract it to remote server
Construction of the word подтвержда́ть
List of Implementations for common OR problems
Go function to test whether a file exists
What is -(-2,3,4)?
How long had Bertha Mason been in the attic at the point of the events in Jane Eyre
What is the difference between figures illustration and images?
What does the ash content of broken wheat really mean?
What does "another" mean in this case?
What is the difference between a historical drama and a period drama?
Web is cast, when do I make my first save?
Language Selector
What can a novel do that film and TV cannot?
Which are more efficient in putting out wildfires: planes or helicopters?
A student "completes" 2-week project in 3 hours and lies about doing it himself
Term for a character that only exists to be talked to
Is there any way for a Half-Orc Sorcerer to get proficiency with a heavy weapon?
Why did my leaking pool light trip the circuit breaker, but not the GFCI?
How to travel between two stationary worlds in the least amount of time? (time dilation)
Which high-degree derivatives play an essential role?
Upload csv into QGIS
How to duplicate a map layer at most once as the bottom layer in qgis3 (python)Open FileGDB Using QGIS 3 + OSXSetting Attribute form window resizable in QGIS 3?PyQGIS import csv- QGIS 3.4Grouping layers using PyQGIS makes them not visible on canvas?How to fix the geocode error: UnicodeEncodeError ascii codec can't encode character ufeff and xfcQGIS Server 3.4 - No labels in WMSConfusing result of raster calculator in QGISQGIS — Extract Values from KDE raster to orginal point data layerConvert point layer to raster QGIS 3
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I'm trying to import an Excel sheet into QGIS3.
For that, I saved my spreadsheet as a .csv and in QGIS I went to "Layer->add Layer-> add delimited text layer..."
Unfortunately, I get the following screen.
Apparently, QGIS doesn't recognize the different fields from the original spreadsheet. Does anyone have an idea what the problem might be?
qgis-3
edited 8 hours ago
TomazicM
2,6781 gold badge8 silver badges20 bronze badges
asked 9 hours ago
Dennis JanDennis Jan
974 bronze badges
add a comment |
I'm trying to import an Excel sheet into QGIS3.
For that, I saved my spreadsheet as a .csv and in QGIS I went to "Layer->add Layer-> add delimited text layer..."
Unfortunately, I get the following screen.
Apparently, QGIS doesn't recognize the different fields from the original spreadsheet. Does anyone have an idea what the problem might be?
qgis-3
edited 8 hours ago
TomazicM
2,6781 gold badge8 silver badges20 bronze badges
asked 9 hours ago
Dennis JanDennis Jan
974 bronze badges
add a comment |
I'm trying to import an Excel sheet into QGIS3.
For that, I saved my spreadsheet as a .csv and in QGIS I went to "Layer->add Layer-> add delimited text layer..."
Unfortunately, I get the following screen.
Apparently, QGIS doesn't recognize the different fields from the original spreadsheet. Does anyone have an idea what the problem might be?
qgis-3
edited 8 hours ago
TomazicM
2,6781 gold badge8 silver badges20 bronze badges
asked 9 hours ago
Dennis JanDennis Jan
974 bronze badges
I'm trying to import an Excel sheet into QGIS3.
For that, I saved my spreadsheet as a .csv and in QGIS I went to "Layer->add Layer-> add delimited text layer..."
Unfortunately, I get the following screen.
Apparently, QGIS doesn't recognize the different fields from the original spreadsheet. Does anyone have an idea what the problem might be?
qgis-3
qgis-3
edited 8 hours ago
TomazicM
2,6781 gold badge8 silver badges20 bronze badges
asked 9 hours ago
Dennis JanDennis Jan
974 bronze badges
edited 8 hours ago
TomazicM
2,6781 gold badge8 silver badges20 bronze badges
asked 9 hours ago
Dennis JanDennis Jan
974 bronze badges
edited 8 hours ago
TomazicM
2,6781 gold badge8 silver badges20 bronze badges
edited 8 hours ago
TomazicM
2,6781 gold badge8 silver badges20 bronze badges
edited 8 hours ago
TomazicM
2,6781 gold badge8 silver badges20 bronze badges
2,6781 gold badge8 silver badges20 bronze badges
asked 9 hours ago
Dennis JanDennis Jan
974 bronze badges
asked 9 hours ago
Dennis JanDennis Jan
974 bronze badges
asked 9 hours ago
Dennis JanDennis Jan
974 bronze badges
974 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
Your CSV is separated by semicolon. This is common in Germany and other european countries. But "standard" is comma, as it is used in the US.
Change the seperator to "Benutzerdefiniert" ("custom delimiters") and select semicolon. You will then get your columns correctly. Then you can also choose your geometry columns.
You may also want to select "Use comma as decimal separator" in case you have real numbers in your dataset. Also you may want to check "first record has fieldnames" to get your fieldnames as headline.
answered 8 hours ago
MrXsquaredMrXsquared
3,1941 gold badge10 silver badges26 bronze badges
Yes, that was the solution to my problem. Thank you.
– Dennis Jan
6 hours ago
add a comment |
Your Answer
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "79"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f327448%2fupload-csv-into-qgis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
Your CSV is separated by semicolon. This is common in Germany and other european countries. But "standard" is comma, as it is used in the US.
Change the seperator to "Benutzerdefiniert" ("custom delimiters") and select semicolon. You will then get your columns correctly. Then you can also choose your geometry columns.
You may also want to select "Use comma as decimal separator" in case you have real numbers in your dataset. Also you may want to check "first record has fieldnames" to get your fieldnames as headline.
answered 8 hours ago
MrXsquaredMrXsquared
3,1941 gold badge10 silver badges26 bronze badges
Yes, that was the solution to my problem. Thank you.
– Dennis Jan
6 hours ago
add a comment |
Your CSV is separated by semicolon. This is common in Germany and other european countries. But "standard" is comma, as it is used in the US.
Change the seperator to "Benutzerdefiniert" ("custom delimiters") and select semicolon. You will then get your columns correctly. Then you can also choose your geometry columns.
You may also want to select "Use comma as decimal separator" in case you have real numbers in your dataset. Also you may want to check "first record has fieldnames" to get your fieldnames as headline.
answered 8 hours ago
MrXsquaredMrXsquared
3,1941 gold badge10 silver badges26 bronze badges
Yes, that was the solution to my problem. Thank you.
– Dennis Jan
6 hours ago
add a comment |
Your CSV is separated by semicolon. This is common in Germany and other european countries. But "standard" is comma, as it is used in the US.
Change the seperator to "Benutzerdefiniert" ("custom delimiters") and select semicolon. You will then get your columns correctly. Then you can also choose your geometry columns.
You may also want to select "Use comma as decimal separator" in case you have real numbers in your dataset. Also you may want to check "first record has fieldnames" to get your fieldnames as headline.
answered 8 hours ago
MrXsquaredMrXsquared
3,1941 gold badge10 silver badges26 bronze badges
Your CSV is separated by semicolon. This is common in Germany and other european countries. But "standard" is comma, as it is used in the US.
Change the seperator to "Benutzerdefiniert" ("custom delimiters") and select semicolon. You will then get your columns correctly. Then you can also choose your geometry columns.
You may also want to select "Use comma as decimal separator" in case you have real numbers in your dataset. Also you may want to check "first record has fieldnames" to get your fieldnames as headline.
answered 8 hours ago
MrXsquaredMrXsquared
3,1941 gold badge10 silver badges26 bronze badges
edited 8 hours ago
answered 8 hours ago
MrXsquaredMrXsquared
3,1941 gold badge10 silver badges26 bronze badges
answered 8 hours ago
MrXsquaredMrXsquared
3,1941 gold badge10 silver badges26 bronze badges
answered 8 hours ago
MrXsquaredMrXsquared
3,1941 gold badge10 silver badges26 bronze badges
3,1941 gold badge10 silver badges26 bronze badges
Yes, that was the solution to my problem. Thank you.
– Dennis Jan
6 hours ago
add a comment |
Yes, that was the solution to my problem. Thank you.
– Dennis Jan
6 hours ago
Yes, that was the solution to my problem. Thank you.
– Dennis Jan
6 hours ago
Yes, that was the solution to my problem. Thank you.
– Dennis Jan
6 hours ago
add a comment |
Thanks for contributing an answer to Geographic Information Systems Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fgis.stackexchange.com%2fquestions%2f327448%2fupload-csv-into-qgis%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
