Demo of how to add an excel table to ArcGIS Pro and how to add fields to the table. Followup video shows how to use a python expression to split fields: • Using field calculator...
Hi! Great tutorials! My question: how do I make sure that Excel document columns are imported as text? I was trying to change the field type to text in Excel and then importing the table/sheet, but it still shows as Double. Cant make it change scientific notations into text for some reason. Thank you for your videos!
I think I do explain that in another video, try looking towards the end of this one...ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-I3ZJ6jTsMiU.html. If you change the field type in excel it should import as a text field. If you continue to have trouble, you can just create a new field and copy the contents into that new text field in ArcGIS.
Hi, this is very helpful! I have a question, I am trying to import my excel data into my map, but when I click on my excel file I don't have anything that says "sheet 1" like you did. it says my "container is empty" what does this mean? How do I fix this?
I'm not 100% sure why it says "container is empty" it might be the version of Excel you are using and/or the version of ArcGIS you are using. A possible solution is to save your excel table as a .csv file and import it into ArcGIS that way.
Sorry, I should have a logical naming system for these videos. This is the follow-up video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-azsYTmFTIfU.html
@@drmckinnon you should use “part X” or use the time stamp function to link your follow up videos within previous videos. It will drive and keep traffic on your page. Thank you again!
