I am having a few issues with importing a 2013 excel spreadsheet to ArcGIS Desktop 10.2 (free trial). I have added the spreadsheet through 'Add data' and then referred to the Table of Contents (list by source) and navigated to 'Display XY Data...'
I have filled in the X and Y fields and chosen the relevant coordinate system. When the new layer appears I have right clicked to export the data to a shapefile however it does not allow me and states that 'there was an error exporting the layer'.
Has anybody got any suggestions?
I have amended the excel sheet to be values only (instead of drop down boxes etc.) but cant think why else this error keeps occurring!
All comments welcome