says there is a problem with line 2. It does not tell you what the problem is. It turns out it is the spaces after the commas. This is not obvious, nor should an import format be sensitive to extra spaces (in my book leading and trailing spaces are NEVER significant in data and should always be trimmed).
Ship,Departure port,Coordinates "Abeona", "Tampico", "-97.861099,22.2331041" "Adelaida", "Havana", "-82.3665956,23.1135925"
says there is a problem with line 2. It does not tell you what the problem is. It turns out it is the spaces after the commas. This is not obvious, nor should an import format be sensitive to extra spaces (in my book leading and trailing spaces are NEVER significant in data and should always be trimmed).