Тёмный

Importing CSV (Excel) Coordinates into QGIS 

GeoDelta Labs
Подписаться 127 тыс.
Просмотров 309 тыс.
50% 1

In this tutorial, we will show you how to import comma separated value (CSV) data which contains latitude & longitude into QGIS, how to plot the points on a map, and how to export the data into an ESRI Shapefile.
Download the data - drive.google.com/drive/folder...

Опубликовано:

 

28 июн 2020

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 137   
@sgnMark
@sgnMark 3 года назад
Thanks man, probably the most asked question when starting georeferencing in gis and qgis and you answered it without the chaff. thanks bud!
@mikefish76
@mikefish76 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!
@saminyead1233
@saminyead1233 2 года назад
Thank God for people like you, helping us poor struggling folks everyday! Very simple, step-by-step explanation. Thank you very much!
@geodeltalabs
@geodeltalabs 2 года назад
You are welcome
@elisa.alexander
@elisa.alexander 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!!!
@achionyeikechukwu2503
@achionyeikechukwu2503 7 месяцев назад
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.
@user-qj4qw6vs5o
@user-qj4qw6vs5o 4 месяца назад
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!!!
@SamVekemans
@SamVekemans 2 года назад
Thank you so much! This was exactly what I was looking for. Clearly explained with no nonsense and no expert language.
@RVJ24
@RVJ24 3 месяца назад
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 2 месяца назад
-I don't have OpenStreetMap, how can I get it?
@miss_B_
@miss_B_ 3 года назад
Simple and practical. Perfect video, thanks a lot man!!
@rosaliahdez
@rosaliahdez Год назад
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. 🙂
@l.a2463
@l.a2463 Год назад
Thank you for the shearing! I started my own project and had no idea how to add the data.
@jcoker423
@jcoker423 2 года назад
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.
@geodeltalabs
@geodeltalabs 2 года назад
Great 👍
@sosbro
@sosbro 3 года назад
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.
@samielbru4112
@samielbru4112 2 года назад
Q0
@sreyagoswamichatterjee1384
@sreyagoswamichatterjee1384 3 года назад
Thanks a lot , you explained this very nicely. you have got a lovely voice.
@AnandaEdirisinghe
@AnandaEdirisinghe Год назад
Thanks, It is very useful. Clearly explained. Appreciate the good work.
@ThukiYoenten
@ThukiYoenten 2 года назад
Love every videos of yours. Keep up the nice work sir
@vanik0r0
@vanik0r0 3 года назад
Excellent tutorial, as always....
@angelortegab5
@angelortegab5 2 года назад
LIFE SAVER! Thank you very much for this video.
@geodeltalabs
@geodeltalabs 2 года назад
You are welcome :)
@sheikhmohamedalphajanneh2590
@sheikhmohamedalphajanneh2590 3 года назад
Thank you man. This has been very useful
@katsugekimochi7250
@katsugekimochi7250 Месяц назад
Thank you!!! doing my thesis now and the video was very helpful thank you!
@ethhics
@ethhics 2 года назад
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
@geodeltalabs
@geodeltalabs Год назад
You are welcome :)
@alvaroanchondo4691
@alvaroanchondo4691 3 года назад
Thank you, Very well explained.
@danielciobanu8342
@danielciobanu8342 2 года назад
Thanks a lot! It was very very helpful!
@yellowboxster06
@yellowboxster06 2 месяца назад
Great job - easy to understand.
@mikefantos2878
@mikefantos2878 Год назад
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
@cassandraopiari9937
@cassandraopiari9937 9 месяцев назад
Thank you so much! I finally got it right! Thank you thank you!! 🙏🏽🙏🏽🙏🏽
@wasafisafi612
@wasafisafi612 8 месяцев назад
Thank you so much for your video. You made my day
@SujeetYadav-gc5qy
@SujeetYadav-gc5qy 3 года назад
That was very helpful bro Thanks
@robthomas9680
@robthomas9680 4 месяца назад
Perfect video. Thank you very much
@sunnybabu9071
@sunnybabu9071 10 месяцев назад
Thank you ... Neatly explined
@gistube1888
@gistube1888 Год назад
So much great title keep it up bro
@robintaylor3752
@robintaylor3752 2 года назад
Legend. Great video, thank you.
@geodeltalabs
@geodeltalabs 2 года назад
You are welcome ☺️
@Man_-hf4ix
@Man_-hf4ix Год назад
Thank You, Good work 👍
@haqimzakariah7322
@haqimzakariah7322 6 месяцев назад
Very helpful video. Thanks for sharing XD
@alfredkik3675
@alfredkik3675 2 года назад
Great work bro!
@geodeltalabs
@geodeltalabs Год назад
You are welcome :)
@mugenmugen7885
@mugenmugen7885 3 месяца назад
Thanks! Helped a lot!
@geodeltalabs
@geodeltalabs 3 месяца назад
You're welcome!
@bijaybasfore658
@bijaybasfore658 6 месяцев назад
Very helpful. Thank you
@anmovs4066
@anmovs4066 3 года назад
THANKS ALOT! PRAYERS FOR YOU
@dinoroy8962
@dinoroy8962 Год назад
Nice tutorial, thank you so much
@geodeltalabs
@geodeltalabs Год назад
You are welcome
@sebastianbusch6905
@sebastianbusch6905 3 года назад
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
@nengsyahirah6855
@nengsyahirah6855 3 года назад
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) ?
@user-gv9er9qf9r
@user-gv9er9qf9r 2 года назад
Thank you. You really help me but i have misunderstood how gives name to points .
@RogerAzupardo
@RogerAzupardo 3 года назад
thanks for the info :)
@jaaferepi
@jaaferepi 2 года назад
Thanks ihope to be professional Qgis I need more lectures
@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?
@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
@asadshah5005
@asadshah5005 7 месяцев назад
good tutorial
@pavankalhane2481
@pavankalhane2481 Год назад
Good work
@diliprpanchamia
@diliprpanchamia 2 года назад
well explained
@souvikmahato9991
@souvikmahato9991 2 года назад
sir can you suggest some portals where i can find Indian city lat longs . Or good open-source portal in india
@JahidKhan-tb7gr
@JahidKhan-tb7gr 3 года назад
Tanks sir usefull video
@andreelias8383
@andreelias8383 3 года назад
LoveU Bro!!!!!!!!!!!!!!!!!!!!!!!!!!
@HunterHunter93
@HunterHunter93 5 месяцев назад
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?
@manglem10
@manglem10 3 года назад
Very nice
@Katharina552
@Katharina552 11 месяцев назад
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
@blink182bfsftw
@blink182bfsftw 3 года назад
Thank you!
@geodeltalabs
@geodeltalabs 3 года назад
You are welcome
@9k2alamiri
@9k2alamiri 2 года назад
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
@RafaelSisto
@RafaelSisto 3 года назад
Thanks!
@zsofiaszabo5383
@zsofiaszabo5383 2 года назад
THANK YOU!
@geodeltalabs
@geodeltalabs 2 года назад
Welcome ☺️
@chismiswai9675
@chismiswai9675 3 года назад
Thanks. This is very helpful. Is there a way/link to install the latest version of QGIS?
@geodeltalabs
@geodeltalabs 3 года назад
You can download from qgis.org
@wordsfromhills
@wordsfromhills 2 года назад
Thank you
@manjimaghosh4712
@manjimaghosh4712 3 года назад
Thank you so much
@geodeltalabs
@geodeltalabs 3 года назад
You are welcome
@gadingsyahri901
@gadingsyahri901 Год назад
thankyou verymuchhhhhh
@kishandarji6408
@kishandarji6408 3 года назад
when i trying to clip the polygone from map its showing me error
@JibHyourinmaru
@JibHyourinmaru 2 года назад
thank you so much.
@geodeltalabs
@geodeltalabs Год назад
You are welcome :)
@megan2484
@megan2484 3 года назад
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 года назад
That information is essential to add the points to the correct locationa
@albaratko
@albaratko Год назад
Hello, why at Geometry CRS at my project its "Invalid Projection" ? Can someone help me ;)
@khoajakhaled9302
@khoajakhaled9302 2 года назад
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 7 месяцев назад
How did you win it I failed even finding those dots
@nokuldana8461
@nokuldana8461 Год назад
Sir i don't have quick map service how can i get that?
@lewiswolff3703
@lewiswolff3703 2 года назад
Thank you.
@geodeltalabs
@geodeltalabs 2 года назад
No problem 👍
@Darrian4719
@Darrian4719 Год назад
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 Год назад
The latter would be what I would do
@dikonketsotlaamela6055
@dikonketsotlaamela6055 Год назад
Thanks a lot. I'm still struggling, my csv file does not separate the longitude and latitude. what can be the problem?
@robertwienroder3030
@robertwienroder3030 4 месяца назад
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
@StarR12space
@StarR12space 3 года назад
Can you tell how important this ? I have Presentation and i have to say this in my slides 😭😭
@mursalsaier5423
@mursalsaier5423 19 дней назад
in Web option i don't have that option to show to map under the dots, what should i do??
@azeemsyed8150
@azeemsyed8150 11 месяцев назад
How to see latitude longitude and as well as northing easting coordinates in qgis attribute table., Please tell me this sir
@kumaramahadesh5739
@kumaramahadesh5739 3 года назад
Tnqso much Sir
@geodeltalabs
@geodeltalabs 2 года назад
You are welcome :)
@indrayudhpaul1203
@indrayudhpaul1203 2 года назад
Thanks 😊
@geodeltalabs
@geodeltalabs 2 года назад
Welcome 😊
@sammymarrco2
@sammymarrco2 6 месяцев назад
thx!
@Notimetotakeblood
@Notimetotakeblood 8 месяцев назад
nice
@oisif950
@oisif950 3 года назад
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 3 года назад
Save your excel as a .CSV file. Then try importing it to QGIS
@tembalethutele1
@tembalethutele1 2 года назад
I'm experiencing the same. Did you get help?
@robertwienroder3030
@robertwienroder3030 4 месяца назад
@@tembalethutele1 same with me now. Could you solve the problem?
@faycalouarab6127
@faycalouarab6127 2 месяца назад
I don't have OpenStreetMap, how can I get it?
@coenlammerts8816
@coenlammerts8816 Год назад
I followed every step but it wont work do you need special settings for excel of something?
@geodeltalabs
@geodeltalabs Год назад
Not really. Have you check whether you are mixing up x, y with lat, lon assignment? this is a common mistake
@unarinenemutudi4054
@unarinenemutudi4054 3 года назад
How do i solve the issue of the imported data not previewing the way it should on the sample data
@geodeltalabs
@geodeltalabs 3 года назад
Did you check the CRS?
@unarinenemutudi4054
@unarinenemutudi4054 3 года назад
@@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 2 года назад
I have the same problem indeed.. tips anyone?
@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 Год назад
Did you make sure you are using a .csv file and not another format?
@robertwienroder3030
@robertwienroder3030 4 месяца назад
This whole comment section shows repeatedly this exact problem. Did anybody find out how to fix this?@@nabilaahmadmandawari6224
@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
@madelynturner1867
@madelynturner1867 Год назад
me too. how do you fix this
@tasneemfatma3113
@tasneemfatma3113 2 года назад
good
@ankitasonkar42
@ankitasonkar42 Год назад
How to download landslide point in qgis
@geodeltalabs
@geodeltalabs Год назад
Sorry i'm not aware of any portals that provide landslide data. There should be some out there though
@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?
@karoich2174
@karoich2174 27 дней назад
Why do my columns never seperate when inserting the file into QGIS? They are all stacked in one column.
@geodeltalabs
@geodeltalabs 26 дней назад
Pretty sure the issue is with specifying the correct delimiter
@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...
@kgosterb
@kgosterb 3 года назад
Whoops..forget that question. Directory file location rights.
@ajaypatro1554
@ajaypatro1554 10 месяцев назад
what about a polygons
@user-bk5ep5wy8r
@user-bk5ep5wy8r 4 года назад
Qgis > ArcGis
@phungbilibrahma233
@phungbilibrahma233 Год назад
Not happening
@tundupgyalpo2251
@tundupgyalpo2251 Год назад
Please take the online classes,...
@isaacnzayisenga1189
@isaacnzayisenga1189 2 года назад
Thank you
@davet2069
@davet2069 2 года назад
Thank you
Далее
Prepare Study Area Map Easily |QGIS
14:44
Просмотров 164 тыс.
Importing CSV Coordinates (Excel) into QGIS
12:57
Просмотров 7 тыс.
Я нашел кто меня пранкует!
00:51
ШАР СКВОЗЬ БУТЫЛКУ (СКЕРЕТ)
00:46
How to Make a Map using QGIS3
30:20
Просмотров 136 тыс.
Learn GIS - QGIS Full Course for Beginners (New for 2024)
1:12:46
QGIS BASEMAPS: the ULTIMATE GUIDE
11:29
Просмотров 5 тыс.
How to Georeference in QGIS (2024)
8:19
Просмотров 4,2 тыс.
An Absolute Beginner's Guide to QGIS 3
1:10:08
Просмотров 1,2 млн
QGIS 101: How to import Excel Data (No CSV files)
10:47
Qgis comment Importer des Csv et les convertir en Shp
5:50