Page History

...

1. Towards the top of the window, right-click the link that says following link and select Save link as….  (Yours will have a different download number than shown below.)
   
   
   
   
2. Double-click the XY folder.
3. For 'File name:' rename your file “LatLongMayors” and click Save.
4. Return to Excel.
5. At the bottom of the worksheet, click the Insert Worksheet New sheet button.
   
   Image Added
   
   
6. Click the Data tab.
7. Under the ‘Get External Data’ section, click From Text.
8. Navigate to select your saved LatLongMayors text file (Desktop > XYTutorialData XY > LatLongMayors) and click Import.
9. In the ‘Text ImportWizard’ Import Wizard’ window, ensure that Delimited is selected and click Next >.

A delimiter is simply a character, such as a tab, space, or comma that tells Excel when to move the text into the next column.

1. In the ‘Delimiters’ box, ensure that Tab is checked and check Tab and ensure that the column break lines appear in the correct locations in the ‘Data preview’ box, as shown below, and click Next >.
   
   
   
   
2. Click Finish.
3. In the Import Data window, click OK.

...