Need help putting latitude and longitude CSV excel file onto map

[BenProsser]

Firstly, I'm new so i can't do much. I have a small amount of data, each linked to a lat/long destination. However whenever I try to import this, it says: 

'Longitude, and / or Latitude, not fully specified".

I was wondering if someone could tell me how I'm meant to lay it out so that it is fully specified?

Thanks.#

[NeilAyres]

Can you post a view of your Lat/Long values here?

[BenProsser]

[NeilAyres]

So which is the Lat & Long columns?

I would suggest you need a header line.

[NeilAyres]

Ah, is that ...

a string with both coords in the same cell?

That's not going to work.

I think you need to re-arrange this data. With 2 columns, one each for the Lat & Long.

And you data items as columns as well, not rows as you have it here.

[BenProsser]

Ah okay, thanks!

[BenProsser]

Is this better?

[NeilAyres]

You will have to split that first column into 2 columns. But that would be the way to go.

[DanPatterson_Retired]

You need to rearrange your table 

Longitude, Latitude, Open_space, Age, Noise, Upkeep, Cleanl, Pedest

            -51       51.                     2        2       -3             0          2          27

Notice, that everything is a number, the first row is the header, there are no blank rows AND, the field names are short, don't begin with a number, and have NO spaces (and don't contain reserved words)

[BenProsser]

Thanks!