CSV Coordinate Converter
Convert latitude and longitude columns in CSV or TSV files between decimal degrees and DMS while keeping other data.
You might also need: Latitude Longitude Converter , GPS Coordinates Distance Calculator , GeoJSON Point Generator and more
CSV / TSV input
UTF-8 CSV or TSV, up to 2 MB, 5,000 data records, and 100 columns. Include one header row with unique, nonempty column names. Coordinates must already use the same datum; this tool changes notation only.
Common latitude / longitude header names are selected automatically. Check both columns before converting.
Recommended for Excel or Google Sheets: adds a leading apostrophe to text cells beginning with formula characters, including headers. Decimal coordinate values remain numeric. Turn off to preserve all other cell text exactly.
Validation and CSV output
Validate and convert your table to see results. Export is available only when every record is valid.
How to convert a CSV coordinate table
- Paste a table or choose a UTF-8 CSV / TSV file with one header row.
- Select the input separator, conversion direction, latitude column, and longitude column.
- Validate the table. Correct any reported records, then convert again.
- Copy or download the CSV. Other columns and record order are kept; optional spreadsheet protection may prefix formula-like text with an apostrophe.
Examples
- Decimal: name,latitude,longitude followed by Taipei,25.033,121.5654 converts the coordinate cells to 25°1′58.8″N and 121°33′55.44″E.
- DMS: use cells such as 40°42′46.08″N and 74°0′21.6″W. Select DMS → decimal degrees to obtain 40.7128 and -74.006.
- For a tab-separated export from a spreadsheet, choose Tab (TSV). Quoted commas and line breaks inside other cells are preserved as CSV values.
Frequently asked questions
Does this convert WGS84, TWD97, UTM, or projected coordinates?
No. It changes latitude / longitude notation between decimal degrees and DMS only. It does not transform coordinate systems, datums, or map projections.
What happens to invalid records?
Export is blocked until every record is valid. The tool reports record numbers and never silently drops records or exports a partial table.
Can I keep names, IDs, and other spreadsheet columns?
Yes. Header names, other column values, and record order are retained. Spreadsheet protection can add an apostrophe to formula-like text; turn it off when exact text preservation is required.
How precise are the converted coordinates?
Decimal degrees are rounded to at most 8 decimal places, and DMS seconds to 6 places. Conversion does not increase the accuracy of your source measurements.
Your table and files are processed in your browser. Coordinate values and file names are not included in tool analytics.
Find this tool useful? Share it with your team to speed up your workflow.
If you like it, tap to support it; if it needs improvements, tap and we’ll prioritize updates.