Saving and Exporting Straight Line Distance Results
This guide covers how to export your calculations to CSV, access your calculation history, and manage your saved results.
Exporting Results to CSV
After calculating distances, you can download the full results as a CSV file.
1
Run Your Calculation
Enter your address pairs and click Calculate Distances. Wait for all results to appear in the results table.
2
Click Export CSV
The Export CSV button appears above the results table after a successful calculation. Click it to start the download.
3
Open in Your Application
The CSV file downloads with a UTF-8 BOM header for proper character encoding. Open it in Excel, Google Sheets, LibreOffice, or any spreadsheet application.
CSV File Contents
The exported CSV includes these columns:
| Column | Description |
|---|---|
| **Row** | Row number matching your original input order |
| **Origin** | Geocoded origin address (standardized by Google Maps) |
| **Destination** | Geocoded destination address |
| **Distance (mi)** or **Distance (km)** | Straight-line distance in your selected unit |
| **Origin Lat** | Origin latitude coordinate |
| **Origin Lng** | Origin longitude coordinate |
| **Dest Lat** | Destination latitude coordinate |
| **Dest Lng** | Destination longitude coordinate |
| **Status** | OK or ERROR |
| **Error** | Error description (blank for successful rows) |
Coordinate Bonus
Every export includes the geocoded latitude/longitude for both origin and destination. These coordinates are useful for mapping in GIS software, plotting in Google Maps, or importing into location databases.
File Naming
Exported CSV files are named using this pattern:
straight-line-distances-YYYY-MM-DD-ID.csv
For example: straight-line-distances-2026-02-20-42.csv
Calculation History
Paid subscribers get automatic history saving. Every batch you calculate is saved and accessible from the Calculation History section on the tool page.
Viewing History
1
Scroll to Calculation History
Below the results area, click the Calculation History header to expand the section.
2
Browse Past Calculations
Your history shows each batch with the date, number of pairs, successful/failed counts, unit used, and processing time.
3
View Details
Click View on any history entry to reload the full results into the results table.
4
Download Again
Click the CSV download button on any history entry to re-download that batch's results.
History Details
Each history entry shows:
| Field | Description |
|---|---|
| **Date** | When the calculation was run |
| **Pairs** | Number of origin-destination pairs processed |
| **Successful** | How many pairs were calculated successfully |
| **Failed** | How many pairs had errors |
| **Unit** | Miles or kilometers |
| **Time** | Processing time in milliseconds |
History Pagination
History entries are paginated at 10 per page. Use the page navigation at the bottom to browse older calculations.
Using Exported Data
In Excel or Google Sheets
- Open the CSV file directly (File > Open)
- All columns auto-populate with proper headers
- Use filters and sorting to analyze your data
- Create charts or pivot tables from the distance data
In GIS Software (QGIS, ArcGIS)
- Import the CSV with the coordinate columns
- Set Origin Lat/Lng as point geometry
- Optionally create a second layer for Dest Lat/Lng
- Visualize distances on a map
In Mapping Platforms (Google Maps, Mapbox)
- Use the lat/lng coordinates to plot markers
- Draw lines between origin-destination pairs
- Color-code by distance range
In Databases
- Import the CSV into your database table
- Use the coordinates for spatial queries
- Join with your existing location data
Data Privacy
Your calculation results are private to your account. History is only accessible when you are logged in. We do not share, sell, or use your location data for any other purpose.
Trial vs Paid Export Features
| Feature | Trial | Paid Subscriber |
|---|---|---|
| View results on screen | Yes | Yes |
| Export to CSV | No | Yes |
| Saved calculation history | No | Yes |
| Re-download past results | No | Yes |
| Coordinates in export | — | Yes |
Unlock Full Export
Subscribe to the Straight Line Distance Calculator to get CSV export, saved history, and unlimited calculations.