Upload csv into QGISHow to duplicate a map layer at most once as the bottom layer in qgis3 (python)Open...
How can I get a file's size with C++17?
3D nonogram – What's going on?
Old story where computer expert digitally animates The Lord of the Rings
Where is read command?
Can Monks spellcast?
Why is the saxophone not common in classical repertoire?
Upload csv into QGIS
Contributing to a candidate as a Foreign National US Resident?
Which high-degree derivatives play an essential role?
What is meaning of 4 letter acronyms in Roman names like Titus Flavius T. f. T. n. Sabinus?
My players like to search everything. What do they find?
Construction of the word подтвержда́ть
How frequently do Russian people still refer to others by their patronymic (отчество)?
What can a novel do that film and TV cannot?
Why would a propellor have blades of different lengths?
What do you call the motor that fuels the movement of a robotic arm?
Did Snape really give Umbridge a fake Veritaserum potion that Harry later pretended to drink?
Sleepy tired vs physically tired
What instances can be solved today by modern solvers (pure LP)?
Do I need to be legally qualified to install a Hive smart thermostat?
Show that there are infinitely more problems than we will ever be able to compute
Can I deep fry food in butter instead of vegetable oil?
Yield on municipal bonds versus treasury
Phrasing "it says" or "it reads"
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
