...
- In the Contents pane, right-click the Sheet1$_Layer layer and select Zoom to Layer.
Exporting XY
...
Data
Since the points appear to be in reasonable locations (rather than in another country or the middle of the ocean), you will want to export them to a new feature class in your XYData geodatabase. Exporting to a feature class will allow you to reuse this points layer in other future map documents without having to go through the display XY data process each time.
...
You have successfully mapped point locations using XY coordinates.
Bonus Exercise: Spatial Join
The following section is optional and does not contain additional information on mapping locations using XY coordinates.
...
Before you can covert DMS coordinates to DD coordinates, it is necessary to separate out the degrees, minutes, and seconds components into their own columns. In Excel, you can divide single cells into multiple columns using either delimiters or fixed width break lines. You will try both methods.
Converting
...
Text to Columns Using Delimiters
- Click cell D2 to select it.
- In the formula bar, highlight the degree symbol (°) and press Ctrl+C to copy it.
...
You could repeat this same process twice more, using the apostrophe symbol (‘) and the quotation marks symbol (“) as the respective delimiters. If your coordinates data had differing numbers of decimal places in each row, repeating this method would be necessary, but, in this case, each set of coordinates has exactly the same number of characters, so using fixed width break lines is possible.
Converting
...
Text to Columns Using Fixed Width Break Lines
- Click column E to highlight the entire column.
- On the Data tab, under the Data Tools section, click the Text to Columns button.
- In the ‘Convert Text to Columns Wizard’, select Fixed width and click Next >.
- In the ‘Data preview’ box at the bottom, click on both sides of the apostrophe symbol (‘) to add break lines.
- Click on both sides of the quotation mark symbol (“) to add break lines.
...
Your spreadsheet should now appear like that shown below. If you have any additional columns, showing because they were not marked to be skipped, delete them now.
Using the DMS to DD
...
Conversion Formula
Now that your degrees, minutes, and seconds components are each in their own column, you can use the following formula to convert them into decimal degrees: DD = D+(M/60)+(S/3600).
...