Importing CSV (Excel) Coordinates into QGIS

แชร์
ฝัง
  • เผยแพร่เมื่อ 30 ธ.ค. 2024

ความคิดเห็น • 153

  • @sgnMark
    @sgnMark 3 ปีที่แล้ว +27

    Thanks man, probably the most asked question when starting georeferencing in gis and qgis and you answered it without the chaff. thanks bud!

  • @saminyead1233
    @saminyead1233 2 ปีที่แล้ว +6

    Thank God for people like you, helping us poor struggling folks everyday! Very simple, step-by-step explanation. Thank you very much!

  • @sakshamshikshan
    @sakshamshikshan 9 หลายเดือนก่อน

    Thanks a lot! That's probably the most common question when starting georeferencing in GIS and QGIS, and you gave a straightforward answer without any unnecessary details. Appreciate it, buddy!

    • @faycalouarab6127
      @faycalouarab6127 8 หลายเดือนก่อน

      -I don't have OpenStreetMap, how can I get it?

  • @OluwaseunAdeyinka-j2p
    @OluwaseunAdeyinka-j2p 10 หลายเดือนก่อน

    Your tutorial is the best so far, I watched just one of your videos and i was able to create a shapefile now working on creating a map. YOU ARE THE BEST!!!

  • @achionyeikechukwu2503
    @achionyeikechukwu2503 ปีที่แล้ว

    I was overwhelmed by the quality of specialized tutorials on this channel. You are doing a wonder work.
    I wish these videos have a longer version which is a composition of all these shorter ones joined together to create a single video. It's the trend now so that some of us who find it difficult to move from one video to the other will learn from a single extended video. These days it's common to see videos of over seven hours. Please look into this suggestion. Thanks.

  • @elisa.alexander
    @elisa.alexander 4 ปีที่แล้ว +3

    I love you. So. Much.
    I have been trying so hard to figure out why I couldn’t get my points onto my map, trying all kinds of spatial joins, editing the .csvt file to make attributes integers-everything. I found this video and realized oh my god I put the longitude values on the y-axis and latitude on the x-axis! Thank you!!!

  • @mikefish76
    @mikefish76 3 ปีที่แล้ว +2

    Thank you for this video! I am trying to do a GIS assignment at university and had no idea how to do it. You are a life saver!

  • @SamVekemans
    @SamVekemans 2 ปีที่แล้ว +8

    Thank you so much! This was exactly what I was looking for. Clearly explained with no nonsense and no expert language.

  • @sosbro
    @sosbro 4 ปีที่แล้ว +8

    Loved this video! You kept the explanation simple, and stuck to the point! Soo many other vids go waaaaaay off track.
    Saved me alot of trouble I was experiencing using QGIS.

  • @ethhics
    @ethhics 2 ปีที่แล้ว +13

    I cannot express how much I despise this program. Sadly, I am forced to use it for work. Thanks for the tutorial, helped a lot

  • @jcoker423
    @jcoker423 2 ปีที่แล้ว +1

    Thanks alot. Used MGE & Arcview many years ago. I don't find QGIS easy to use (but I appreciate how good it will be) but you explain it very, very well.

  • @rosaliahdez
    @rosaliahdez 2 ปีที่แล้ว

    Me salvaste de la frustración 😁, pues cargaba el archivo como capa vectorial y simplemente no podía hacer que QGIS reconociera el formato de cada columna del csv. I LOVE YOU!!!

  • @SarfarazGolamAhmad
    @SarfarazGolamAhmad ปีที่แล้ว

    This is exactly, what I have been looking for. Thank you very much for creating such a nice tutorial video. Appreciate that. 🙂

  • @angelortegab5
    @angelortegab5 2 ปีที่แล้ว +2

    LIFE SAVER! Thank you very much for this video.

  • @l.a2463
    @l.a2463 2 ปีที่แล้ว

    Thank you for the shearing! I started my own project and had no idea how to add the data.

  • @miss_B_
    @miss_B_ 3 ปีที่แล้ว +2

    Simple and practical. Perfect video, thanks a lot man!!

  • @ThukiYoenten
    @ThukiYoenten 3 ปีที่แล้ว +1

    Love every videos of yours. Keep up the nice work sir

  • @katsugekimochi7250
    @katsugekimochi7250 8 หลายเดือนก่อน

    Thank you!!! doing my thesis now and the video was very helpful thank you!

  • @AnandaEdirisinghe
    @AnandaEdirisinghe ปีที่แล้ว

    Thanks, It is very useful. Clearly explained. Appreciate the good work.

  • @mikefantos2878
    @mikefantos2878 2 ปีที่แล้ว +6

    When I import ths CSV file, the table is not separated. The columns of X, Y coordinates go to one column. Why is that happening? I have made the original excel table like yours

    • @anonymois
      @anonymois 2 หลายเดือนก่อน

      Idem

    • @anonymois
      @anonymois 2 หลายเดือนก่อน +2

      Hi good news for u, I just found a way. It is by changing the file format. You see three options CSV, REGULAR..., COSTUM DELIMITERS. Select the third one and check the semicolon box.

    • @shenree_
      @shenree_ หลายเดือนก่อน

      @@anonymois Thank you, I had the same problem but now it works

  • @sreyagoswamichatterjee1384
    @sreyagoswamichatterjee1384 4 ปีที่แล้ว

    Thanks a lot , you explained this very nicely. you have got a lovely voice.

  • @wasafisafi612
    @wasafisafi612 ปีที่แล้ว

    Thank you so much for your video. You made my day

  • @cassandraopiari9937
    @cassandraopiari9937 ปีที่แล้ว

    Thank you so much! I finally got it right! Thank you thank you!! 🙏🏽🙏🏽🙏🏽

  • @robthomas9680
    @robthomas9680 11 หลายเดือนก่อน

    Perfect video. Thank you very much

  • @dridiabir3004
    @dridiabir3004 2 หลายเดือนก่อน

    Thank you so much you helped me alot !

  • @dikonketsotlaamela6055
    @dikonketsotlaamela6055 ปีที่แล้ว +1

    Thanks a lot. I'm still struggling, my csv file does not separate the longitude and latitude. what can be the problem?

    • @robertwienroder3030
      @robertwienroder3030 10 หลายเดือนก่อน +2

      The reason for your issue is the excel separator. Here is what you need to do: Do anything as he does. After you opened "Add delimited Text Layer" go to the file format menu. You have to choose user-defined. If comma is selected, change to semicolon. If semicolon is selected, change to comma. If both do not work, change to tabulator

  • @gistube1896
    @gistube1896 2 ปีที่แล้ว

    So much great title keep it up bro

  • @yellowboxster06
    @yellowboxster06 8 หลายเดือนก่อน

    Great job - easy to understand.

  • @manivannank7382
    @manivannank7382 3 ปีที่แล้ว

    afetr creating points in web i cant find able to find quick map services and i have no exact geocoordinates map with me . pls suggest what shall i do

  • @mursalsaier5423
    @mursalsaier5423 6 หลายเดือนก่อน

    in Web option i don't have that option to show to map under the dots,
    what should i do??

  • @khoajakhaled9302
    @khoajakhaled9302 2 ปีที่แล้ว +1

    Hi, I imported this csv data to qgis and it displays the dots, but when I added the OSM, it is displaying them as dot outside of the map. Should I change CRS for the imported data, OSM or project or any other changes? Thanks

    • @salummussa1778
      @salummussa1778 ปีที่แล้ว

      How did you win it I failed even finding those dots

  • @robintaylor3752
    @robintaylor3752 2 ปีที่แล้ว

    Legend. Great video, thank you.

  • @sheikhmohamedalphajanneh2590
    @sheikhmohamedalphajanneh2590 4 ปีที่แล้ว

    Thank you man. This has been very useful

  • @Katharina552
    @Katharina552 ปีที่แล้ว

    Hi thanks for the nice video but unfortunately when I do it the exact same way my qGIS does not let me Add my CSV file. The Add button is grey and if I wanna change the geometry definition for the x and y fields I can not change them to longitude and latitude, do you know where I am going wrong? Any help would be very much appreciated

  • @HunterHunter93
    @HunterHunter93 11 หลายเดือนก่อน

    Hi thanks for the video. what would be the procedure if now i want to add points from the americas? i would like to have coordinate points from aroun the world?

  • @haqimzakariah7322
    @haqimzakariah7322 ปีที่แล้ว

    Very helpful video. Thanks for sharing XD

  • @megan2484
    @megan2484 3 ปีที่แล้ว +1

    what if you don't have the latitude and longitude?
    What is the alternative to have your points appearing on the map?

    • @geodeltalabs
      @geodeltalabs  3 ปีที่แล้ว +2

      That information is essential to add the points to the correct locationa

  • @sunnybabu9071
    @sunnybabu9071 ปีที่แล้ว

    Thank you ... Neatly explined

  • @nengsyahirah6855
    @nengsyahirah6855 4 ปีที่แล้ว

    Hi. how want to decide on choosing the x and y axis ? cause i want to add time series data (rainfall data for several districts) ?

  • @vanik0r0
    @vanik0r0 4 ปีที่แล้ว

    Excellent tutorial, as always....

  • @dinoroy8962
    @dinoroy8962 2 ปีที่แล้ว

    Nice tutorial, thank you so much

  • @sebastianbusch6905
    @sebastianbusch6905 4 ปีที่แล้ว

    I'm working with GPS data in CSV format but i need to track a moving object offlline, if my CSV formar data is constantly updating can i export that to QGIS to see a "real-time" change? I know python and i think that i can make it work with that.
    Thanks

  • @fliederblumen1843
    @fliederblumen1843 3 ปีที่แล้ว

    thanks, how to add x and y axis, showing the label of coordinates in UTM, and show legend and save as a picture for scientific publication indicating the experiment sites please

  • @nokuldana8461
    @nokuldana8461 2 ปีที่แล้ว

    Sir i don't have quick map service how can i get that?

  • @oisif950
    @oisif950 4 ปีที่แล้ว +1

    My excel is already divided into multiple columns, but when i imported it into qgis, it read everything as 1 column. Any idea how to fix this?

    • @geodeltalabs
      @geodeltalabs  4 ปีที่แล้ว

      Save your excel as a .CSV file. Then try importing it to QGIS

    • @tembalethutele1
      @tembalethutele1 3 ปีที่แล้ว

      I'm experiencing the same. Did you get help?

    • @robertwienroder3030
      @robertwienroder3030 10 หลายเดือนก่อน

      @@tembalethutele1 same with me now. Could you solve the problem?

    • @anonymois
      @anonymois 2 หลายเดือนก่อน

      Hi good news for u, I just found a way. It is by changing the file format. You see three options CSV, REGULAR..., COSTUM DELIMITERS. Select the third one and check the semicolon box.

    • @anonymois
      @anonymois 2 หลายเดือนก่อน

      ​@@robertwienroder3030Hi good news for u, I just found a way. It is by changing the file format. You see three options CSV, REGULAR..., COSTUM DELIMITERS. Select the third one and check the semicolon box.

  • @danielciobanu8342
    @danielciobanu8342 3 ปีที่แล้ว

    Thanks a lot! It was very very helpful!

  • @Man_-hf4ix
    @Man_-hf4ix 2 ปีที่แล้ว

    Thank You, Good work 👍

  • @coenlammerts8816
    @coenlammerts8816 2 ปีที่แล้ว

    I followed every step but it wont work do you need special settings for excel of something?

    • @geodeltalabs
      @geodeltalabs  2 ปีที่แล้ว

      Not really. Have you check whether you are mixing up x, y with lat, lon assignment? this is a common mistake

  • @azeemsyed8150
    @azeemsyed8150 ปีที่แล้ว

    How to see latitude longitude and as well as northing easting coordinates in qgis attribute table., Please tell me this sir

  • @karoich2174
    @karoich2174 7 หลายเดือนก่อน

    Why do my columns never seperate when inserting the file into QGIS? They are all stacked in one column.

    • @geodeltalabs
      @geodeltalabs  6 หลายเดือนก่อน

      Pretty sure the issue is with specifying the correct delimiter

  • @alfredkik3675
    @alfredkik3675 2 ปีที่แล้ว

    Great work bro!

  • @faycalouarab6127
    @faycalouarab6127 8 หลายเดือนก่อน

    I don't have OpenStreetMap, how can I get it?

  • @КононенкоДмитрий-р2х
    @КононенкоДмитрий-р2х 3 ปีที่แล้ว

    Thank you. You really help me but i have misunderstood how gives name to points .

  • @Darrian4719
    @Darrian4719 2 ปีที่แล้ว

    Is there a way to change or update the coordinate points after importing it to qgis? Or would I have to edit it on excel and then import again

    • @geodeltalabs
      @geodeltalabs  2 ปีที่แล้ว

      The latter would be what I would do

  • @kgosterb
    @kgosterb 3 ปีที่แล้ว

    I do appreciate all of your videos. I have successfully imported a CSV file, but when I try to export to a SHP or KML file format I receive a task failed message - looks like permission denied.
    Export to vector file failed.
    Error: Creation of data source failed (OGR error: Failed to create KML file 911 data.kml: 911 data.kml: Permission denied)
    Is there something else that needs configured?

  • @albaratko
    @albaratko ปีที่แล้ว

    Hello, why at Geometry CRS at my project its "Invalid Projection" ? Can someone help me ;)

  • @kishandarji6408
    @kishandarji6408 4 ปีที่แล้ว

    when i trying to clip the polygone from map its showing me error

  • @alvaroanchondo4691
    @alvaroanchondo4691 4 ปีที่แล้ว

    Thank you, Very well explained.

  • @SujeetYadav-gc5qy
    @SujeetYadav-gc5qy 4 ปีที่แล้ว

    That was very helpful bro
    Thanks

  • @luisbernethpena6844
    @luisbernethpena6844 2 ปีที่แล้ว

    Thank you. For some reason it is not working. I have followed the instructions bit what opens qgis a table without information. My excel look just like your. What could be the problem?

    • @nabilaahmadmandawari6224
      @nabilaahmadmandawari6224 2 ปีที่แล้ว

      Please did you find the cause of the problem? I'm previewing past questions on gis, and I saw thesame question asked.

    • @geodeltalabs
      @geodeltalabs  2 ปีที่แล้ว

      Did you make sure you are using a .csv file and not another format?

    • @robertwienroder3030
      @robertwienroder3030 10 หลายเดือนก่อน

      This whole comment section shows repeatedly this exact problem. Did anybody find out how to fix this?@@nabilaahmadmandawari6224

    • @anonymois
      @anonymois 2 หลายเดือนก่อน

      Hi good news for u, I just found a way. It is by changing the file format. You see three options CSV, REGULAR..., COSTUM DELIMITERS. Select the third one and check the semicolon box.

    • @anonymois
      @anonymois 2 หลายเดือนก่อน

      ​@@nabilaahmadmandawari6224Hi good news for u, I just found a way. It is by changing the file format. You see three options CSV, REGULAR..., COSTUM DELIMITERS. Select the third one and check the semicolon box.

  • @IqraAnimations
    @IqraAnimations 6 หลายเดือนก่อน

    OSM isn't opening. Can you please help me with that?

  • @jaaferepi
    @jaaferepi 3 ปีที่แล้ว

    Thanks ihope to be professional Qgis I need more lectures

  • @souvikmahato9991
    @souvikmahato9991 3 ปีที่แล้ว

    sir can you suggest some portals where i can find Indian city lat longs . Or good open-source portal in india

  • @bijaybasfore658
    @bijaybasfore658 ปีที่แล้ว

    Very helpful. Thank you

  • @mugenmugen7885
    @mugenmugen7885 9 หลายเดือนก่อน

    Thanks! Helped a lot!

    • @geodeltalabs
      @geodeltalabs  9 หลายเดือนก่อน

      You're welcome!

  • @unarinenemutudi4054
    @unarinenemutudi4054 4 ปีที่แล้ว

    How do i solve the issue of the imported data not previewing the way it should on the sample data

    • @geodeltalabs
      @geodeltalabs  4 ปีที่แล้ว

      Did you check the CRS?

    • @unarinenemutudi4054
      @unarinenemutudi4054 4 ปีที่แล้ว

      @@geodeltalabs i managed to do it properly

    • @Eszett263
      @Eszett263 3 ปีที่แล้ว

      @@unarinenemutudi4054 Hey, how did you do it? I've got the same problem and have absolutely no idea how to solve it.

    • @wiesvanlieshout4950
      @wiesvanlieshout4950 3 ปีที่แล้ว

      I have the same problem indeed.. tips anyone?

  • @ankitasonkar42
    @ankitasonkar42 2 ปีที่แล้ว

    How to download landslide point in qgis

    • @geodeltalabs
      @geodeltalabs  2 ปีที่แล้ว

      Sorry i'm not aware of any portals that provide landslide data. There should be some out there though

  • @9k2alamiri
    @9k2alamiri 3 ปีที่แล้ว

    Thank you for your nice tutorial so can you please let me know how to change the file to GPX so I can use it with Garmin GPS

  • @Krishna-vr4ju
    @Krishna-vr4ju 2 ปีที่แล้ว

    sir when u clicked on web u got so many options but for me it is showing only meta search

  • @xsmail6462
    @xsmail6462 ปีที่แล้ว

    Hey brother, where do you extract the csv file from?

    • @geodeltalabs
      @geodeltalabs  ปีที่แล้ว

      Hi, it was created manually just for the purpose of this video tutorial

    • @MrDrushkan
      @MrDrushkan ปีที่แล้ว

      ​​@@geodeltalabs ​ you just manually typed coordinates in excel, and saved as csv, and open it in qgis? But in my case, when I'm opening file in qgis, in ports coordinates - X filed, there are all names and numbers from first column , I can't select only longitude or latitude.... Where is my mistake?

  • @chismiswai9675
    @chismiswai9675 4 ปีที่แล้ว

    Thanks. This is very helpful. Is there a way/link to install the latest version of QGIS?

    • @geodeltalabs
      @geodeltalabs  4 ปีที่แล้ว +1

      You can download from qgis.org

  • @StarR12space
    @StarR12space 3 ปีที่แล้ว

    Can you tell how important this ? I have Presentation and i have to say this in my slides 😭😭

  • @anmovs4066
    @anmovs4066 3 ปีที่แล้ว

    THANKS ALOT! PRAYERS FOR YOU

  • @RogerAzupardo
    @RogerAzupardo 3 ปีที่แล้ว

    thanks for the info :)

  • @rickherzog9275
    @rickherzog9275 4 หลายเดือนก่อน

    It doesnt work for me I just get a table and not actually points on the map

    • @geodeltalabs
      @geodeltalabs  4 หลายเดือนก่อน +1

      Make sure you have selected the right coordinate system which corresponds to the coordinate system of the points. I have done another tutorial addressing some issue people face when trying out this task, it might be useful for you to check it out as well : th-cam.com/video/UxarCcD-mT4/w-d-xo.html

  • @pavankalhane2481
    @pavankalhane2481 2 ปีที่แล้ว

    Good work

  • @ajaypatro1554
    @ajaypatro1554 ปีที่แล้ว

    what about a polygons

  • @dr1lltrckz147
    @dr1lltrckz147 3 ปีที่แล้ว

    What the hell I imported my latitude/longitude data into QGIS which was supposed to show coordinate points in the U.S, but all of my points are in Asia wtf...

  • @indrayudhpaul1203
    @indrayudhpaul1203 2 ปีที่แล้ว

    Thanks 😊

  • @manjimaghosh4712
    @manjimaghosh4712 3 ปีที่แล้ว

    Thank you so much

  • @diliprpanchamia
    @diliprpanchamia 3 ปีที่แล้ว

    well explained

  • @lewiswolff3703
    @lewiswolff3703 2 ปีที่แล้ว

    Thank you.

  • @wordsfromhills
    @wordsfromhills 3 ปีที่แล้ว

    Thank you

  • @blink182bfsftw
    @blink182bfsftw 4 ปีที่แล้ว

    Thank you!

  • @asadshah5005
    @asadshah5005 ปีที่แล้ว

    good tutorial

  • @RafaelSisto
    @RafaelSisto 3 ปีที่แล้ว

    Thanks!

  • @gadingsyahri901
    @gadingsyahri901 ปีที่แล้ว

    thankyou verymuchhhhhh

  • @andreelias8383
    @andreelias8383 3 ปีที่แล้ว

    LoveU Bro!!!!!!!!!!!!!!!!!!!!!!!!!!

  • @kumaramahadesh
    @kumaramahadesh 3 ปีที่แล้ว

    Tnqso much Sir

  • @JahidKhan-tb7gr
    @JahidKhan-tb7gr 4 ปีที่แล้ว

    Tanks sir usefull video

  • @diederikdelange3135
    @diederikdelange3135 หลายเดือนก่อน

    Thanks!!!

  • @raghuramjs3391
    @raghuramjs3391 4 หลายเดือนก่อน

    Google Earth ಬಗ್ಗೆ ಕನ್ನಡ video ಇಲ್ವಾ sir.

  • @manglem10
    @manglem10 4 ปีที่แล้ว

    Very nice

  • @georgen9755
    @georgen9755 5 หลายเดือนก่อน

    Thank you
    Navigation
    Navigation
    Navigation
    Navigation
    Useful

  • @kgosterb
    @kgosterb 3 ปีที่แล้ว

    Whoops..forget that question. Directory file location rights.

  • @sammymarrco2
    @sammymarrco2 ปีที่แล้ว

    thx!

  • @hnevko
    @hnevko 2 หลายเดือนก่อน

    thanks

  • @phungbilibrahma233
    @phungbilibrahma233 ปีที่แล้ว

    Not happening

  • @Notimetotakeblood
    @Notimetotakeblood ปีที่แล้ว

    nice

  • @田逸飞-v1v
    @田逸飞-v1v 4 ปีที่แล้ว +3

    Qgis > ArcGis