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
List of Implementations for common OR problems
Should I warn my boss I might take sick leave
Is it possible to spoof an IP address to an exact number?
Does a reference have a storage location?
Can you move between the attacks of a Twinned Booming Blade?
What can a novel do that film and TV cannot?
What instances can be solved today by modern solvers (pure LP)?
What verb goes with "coup"?
A student "completes" 2-week project in 3 hours and lies about doing it himself
What is -(-2,3,4)?
When should we use dependency injection (C#)
What could a Medieval society do with excess animal blood?
Fine-tuning parameters for existing methods
Which high-degree derivatives play an essential role?
SQL Server error 242 with ANSI datetime
3D nonogram – What's going on?
Performance of loop vs expansion
Construction of the word подтвержда́ть
Did Snape really give Umbridge a fake Veritaserum potion that Harry later pretended to drink?
How come having a Deathly Hallow is not a big deal?
Is よう an adjective or a noun?
What does "another" mean in this case?
How might boat designs change in order to allow them to be pulled by dragons?
Term for a character that only exists to be talked to
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
