New answers tagged excel
If your file is an .xls or .xlsx file these should open correctly in ArcMap. Clearly this isn't happening though, but my experience of using Excel is that it simply stuffs up csv exporting and the resulting file isn't usable. Does opening the .xls or .xlsx file in LibreOffice Calc then saving as a text csv (with commas as a field separator) and importing ...
If you have two suspected spatial references for the list of coordinates, here are some steps to confirm if they are correct or not. Open up new ArcMap Add one of the ESRI general basemap WMS layers (one that has data for entire Earth) For dataframe select Properties>Coordinate System tab, change the spatial reference to one of the suspected spatial ...
Google maps uses WGS 84 Web Mercator. If you've tried creating your points with this coordinate system and haven't been successful, there is probably something wrong with your inputs. The commas for decimal points raises an eyebrow for me. Replace the commas with periods and see if it works.
There are many Python modules you can use for manipulating Excel sheets: xlutils; xlwt; openpyxl; xlrd You could use any of those that allow modifications on Excel sheet; developing this piece of code is not dependent on ArcGIS in any way. When you have a chunk of code that does the work for you, you can wrap it to a custom Python script tool (or a Python ...
As mentioned by @brichins in a comment there is ArcGIS documentation entitled "About joining and relating tables" which provides an excellent introduction and tips like: When using data where a one-to-many or many-to-many relationship exists, you should use a relate or relationship class to establish the relationship between the datasets.
As mentioned in comments, I am not aware of any out-of-the-box way for ArcMap to symbolize layers using RGB values stored in an attribute table, or using RGB values in Excel joined onto an attribute table. However, there is an existing ArcGIS Idea to Set symbol color from RGB values in attribute table so I recommend that you add your vote to that. Note ...
You can use the Replace function detailed in this guide: Remove all spaces with the Replace function Sometimes, we want to remove all spaces between character and numbers in a range, we can use Replace function to solve it. Highlight the range that you want to remove all spaces. Click Home > Find & Select > Replace…, the Find and ...
An alternative to exporting the results of a join is to use the Join Field tool instead of creating a join. This tool directly adds the attributes to the feature class based on a join (one step) as opposed to joining and exporting (two step).
If you want to preserve a permanent copy of the fields that you have joined to a feature class, you need to export it to a new feature class. Right-click the layer in the TOC and choose Data > Export Data.
Before anything else, one must try to understand why ArcGIS imports a field as a string type instead of a numerical / double data type. I found that even if your cell (in Excel) is blank, if it has "spaces" inside (like when you press the spacebar), ArcGIS will interpret these as characters. If you remove them, you will see that they will now register as ...
Top 50 recent answers are included