If the map preview shows Africa but your coordinates should be in the US, this is often caused by reversing latitude/longitude -- that is, your spreadsheet has them in longitude-latitude order. Switch them and the values should be in North America.