Excel data in to shapefile in arcgis ( Import Excel data 2017)

[@prabhasriherath190]

Good one Wymukthi. It was clear and helpful. Way to go....

[@SeekShowSchool]

Welcome and thanks

[@hansikathathsarani3762]

Coordinate system should be introduced at very first. Otherwise points can not be seen after adding x and y field. I took a lot of time to find that error. Other than that explanation is clear. 🙂

[@SeekShowSchool]

Thanks for your continuous feedback

[@NKPbgs]

Serial no should not be there?

[@hansikathathsarani3762]

@@NKPbgs which?

[@yuxiangzhang2343]

Thanks for the video. How does arcGIS know which projection system is the excel data using?

[@SeekShowSchool]

Excel don't have a projection system. But when we import excel data to a shapefile we can set a coordinate system for the particular file, That's all

[@btans0104]

it says error in database while i try to add .XLSX data .. HELP ?? THANKS.

[@SeekShowSchool]

Properly rename the column. Any error code?

[@renzlouiegalura8858]

It says "failed to connect to database. An underlying database error ocurred. Class not registered." while i try to add xlsx data... Help?? Please?

[@SeekShowSchool]

Please try again . I have no idea. But google it. Probably you may trying to add xlsx file directly into database.

[@nchlspch]

Save your XLSX table as XLS and you're good to go :)

[@nain0774]

Sir xy fields is not showing so what i have to do. Please reply

[@SeekShowSchool]

Please check the column names in the excel file. Carefull follow the tutorial again. If not working please change the format of the xy columns in to numbers or text.

[@nain0774]

@@SeekShowSchool sir tried alot but not happening. Iwill change the format then i will try. Thank you sir

[@dextermarlowe9750]

the FID variable is not necessary in the excel file. once you save as shp, arcmap will create the FID column automatically. why didn't you set the coordinate system?

[@SeekShowSchool]

Dexter Marlowe of course you can even in the middle of creating shp file. But it is a event shp file so generally I add coordinate system after exporting as a true shp file. Doesn't matter you can do even adding FID .

[@dextermarlowe9750]

your initial FID would just be inefficient since you won't be using it for anything else and will just inflate your shapefile's size unnecessarily. try creating a feature class in arc catalog. it's much quicker and does not need the intermediate step of creating an event shapefile. but you do have to specify the coordinate.

[@tariqmir1363]

Bekar video