CSV & spreadsheets

CSV with Latitude and Longitude on a Map: Open It in the Browser and Fix the Seven Things That Go Wrong

Three columns, lat and lon, dropped into the csv-viewer — that is the clean case. This post covers the others: the decimal comma Excel pt-BR writes, a title row that shreds every line, swapped columns that draw silently in the wrong ocean, DMS, UTM and Latin-1 — what the viewer shows, and the fix.