New to importing data, I have an excel spreadsheet containing about 100 rows to do as a first attempt. 
I have several locations with different Grid References with the same site name. When I try to import using site name as location, I get the message asking for the centroid to use or advising to tick box to use location name.  When using Site Name as Location name, the import reports the date and location as Vice County  - this does not make sense.  What I really need Recorder to do is put Location Name into Event Name so that the Hierarchy makes sense - don't think that I am really making sense here but any assistance would be welcome.