I believe the issue is that your excel file is exceeding the charcater limit for excel so the coordinates are being truncated. Using the data you provided I was able to load
but I could not get CA or FL to work. When I look at the data in Excel it appears the data is truncated for those states.
I would recommend you load the data from your source file vs copying into Excel.
Please mark my reply as correct or helpful if appropriate so other members can find answers to their questions.
Are you trying to use this coordinates as KLM or CSV file?
As far as I'm concern those are KLM coordinates.
You have got few missing states as well
Try attached- this is extract from KLM file
us states.xlsx 119.5 K
Thanks for the reply Robert...I was loading them via excel file. I tried the excel file you attached which seems to much better version of what I had but no luck either (on Qlik sense desktop). You mentioned KML file in your response so I searched and found a KML file (which probably has the exact same data that you have in your excel file) and that worked!
I found KML file here: KML US and World Map and Sample Data
I am marking this as the answer since your tip on "KML" solved the issue for me.