Export Formats

The CLI can export your activities in multiple formats. Use the -f flag to specify which formats to generate.

Quick Reference

# Generate all formats
chat-to-map analyze chat.zip -f csv,excel,json,map,pdf

# Just CSV and map
chat-to-map analyze chat.zip -f csv,map

# Default: all formats
chat-to-map analyze chat.zip

Output Directory

By default, exports are saved to ./chat-to-map/output/. Customize with:

chat-to-map analyze chat.zip -o ~/Desktop/my-results

CSV

Comma-separated values, compatible with Excel, Google Sheets, and any spreadsheet app.

.csv

Best For

Import into spreadsheets, data analysis, or other tools.

Columns

namecategorylocationlatitudelongitudedateactivity_scoreconfidencesource_messages

Excel

Native Excel format with formatted columns and auto-sizing.

.xlsx

Best For

Direct editing in Microsoft Excel with proper formatting.

Features

• Auto-sized columns
• Header row formatting
• Proper data types

JSON

Structured data format with full activity details.

.json

Best For

Integration with other tools, custom scripts, or APIs.

Features

• Full metadata
• Nested objects
• Machine-readable

Interactive Map

Self-contained HTML file with Leaflet.js map and all activities pinned.

.html

Best For

Share with friends, view offline, or embed in websites.

Features

• Works offline
• No dependencies
• Clickable pins with details
• Zoom and pan

PDF Report

Printable report with activity list, map screenshot, and summary.

.pdf

Best For

Print for travel planning, share as document.

Features

• Professional layout
• Activity thumbnails
• Map overview
• Print-ready

CSV Column Details

The CSV export includes these columns:

Column	Type	Description
name	string	Activity name (e.g., "Joe's Pizza")
category	string	restaurant, hike, trip, activity, errand, etc.
location	string	Full address or location name
latitude	number	GPS latitude coordinate
longitude	number	GPS longitude coordinate
date	string	When the activity was mentioned (ISO 8601)
activity_score	number	0.0 (errand) to 1.0 (fun activity)
confidence	number	AI confidence in the classification (0-1)
source_messages	string	Original chat messages that mentioned this activity

JSON Structure

The JSON export provides full activity details:

{
  "activities": [
    {
      "id": "abc123",
      "name": "Joe's Pizza",
      "category": "restaurant",
      "location": {
        "address": "123 Main St, New York, NY",
        "latitude": 40.7128,
        "longitude": -74.006
      },
      "activityScore": 0.95,
      "confidence": 0.88,
      "sourceMessages": [
        {
          "date": "2024-03-15T14:30:00Z",
          "sender": "Alice",
          "text": "We should try Joe's Pizza sometime!"
        }
      ],
      "metadata": {
        "urls": ["https://joespizza.com"],
        "imageUrl": "https://..."
      }
    }
  ],
  "metadata": {
    "chatName": "Travel Group",
    "messageCount": 15234,
    "dateRange": {
      "start": "2023-01-01",
      "end": "2024-12-15"
    },
    "generatedAt": "2024-12-26T10:00:00Z"
  }
}

Interactive Map

The HTML map export is a self-contained file that works offline. It includes:

Leaflet.js map with OpenStreetMap tiles (cached for offline use)
Clickable markers for each activity
Popup cards with activity details and source messages
Filter controls by category
Responsive design for mobile and desktop

Open the .html file in any browser to view your map. Share it with friends by sending the file directly — no server required.