Hi, I am in a class that uses ARC GIS 10.2.2. Until now, my professor has always given us the data that we needed for projects. However, I have my own data in an Excel and I want to put it in ARC GIS. I have no idea how to create an attribute table, or if it would be easier to include the Microsoft Excel document.
Can someone tell me how to do either or both of those?
You can bring the excel file into ArcMap as a table. If you want to visualize it you could try to join the table with the state feature based on name. To create an attribute table you can export the excel table in ArcMap.
Hope this helps.
Sounds to me like your professor didn't cover the basics of GIS before turning you loose on this assignment. But... Maybe that's the madness to his/her madness. Here's an option; try looking here:
This should make it more of a learning experience...
You could try this
1) Save the excel sheet as a CSV file.
2) Go to www.arcgis.com, login with your Esri Global account.
3) Go to Map. Drag the CSV file from Windows Explorer and drop it on the Map Viewer of ArcGIS.com.
4) A new dialog box will open. click the radio button next to address.. And also change the location field. Then Add Layer.
The points should get displayed
Save and share the map with everyone, if required.
This is what I got when I successfully managed to get the information from Excel to ARC GIS. How do I fix this?
What format did you "successfully" create in ArcGIS (assuming arcmap)? Is it just the table/ or where you trying to create an event (in which case you would need coordinates like x/y or long/lat).
What you have displayed "looks" like a projection issue where you might have the long/lat x/y reversed, or telling ArcMap that is is a different coordinate system coming in.
If you only have a state name...find a layer that has state shape file already, then follow the advice of other below and join the created table to the shapes. Use the online help as Joe pointed out, to search for different concepts.