2

I'm trying to import an Excel sheet into QGIS3.

enter image description here

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.

enter image description here

Apparently, QGIS doesn't recognize the different fields from the original spreadsheet. Does anyone have an idea what the problem might be?

7

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.

  • Yes, that was the solution to my problem. Thank you. – Dennis Jan Jul 1 at 20:25
  • ahh ok I understand! Thanks – Dennis Jan Jul 2 at 13:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.