---
name: friends-orbit-import
description: Converts a spreadsheet, CSV or another app's export of who someone met each day into a Friends Orbit backup zip (people.csv, meetings.csv, days.csv) that the Friends Orbit app (iPhone and Android) imports. Use when the user wants to move their friends, meetings or social diary into Friends Orbit.
---

# Friends Orbit import

The user keeps track of who they meet each day and is moving to Friends Orbit, a phone app for iPhone and Android. Convert the data they attach (a spreadsheet, a CSV, or an export from another app) into a Friends Orbit backup file the app can import. If they haven't attached anything yet, ask for the file first.

The data is about real people. Use it only for this conversion.

## The format

One .zip file named "Orbit backup YYYY-MM-DD.zip" (today's date) holding three files at the top level: people.csv, meetings.csv and days.csv. Each is UTF-8, comma-separated, with a header row; a field that contains a comma, a quote or a line break is wrapped in double quotes, with quotes inside doubled.

### people.csv
One row per person.
- `person_id` (required): A stable, unique id: lowercase letters a–z, digits and hyphens, e.g. anna, anna-k, jo-2. Never the same id for two people.
- `display_name` (required): The name as written, keeping accents and umlauts exactly.
- `circles` (optional): Groups the person is in (family, work, a sport, where you met), several joined by "|", e.g. Family|Climbing.
- `notes` (optional): Free text about the person.

### meetings.csv
One row per person per day you met.
- `date` (required): The day, as YYYY-MM-DD.
- `person_id` (required): Someone from people.csv.
- At most one row per person and day.

### days.csv
One row per day you logged.
- `date` (required): The day, as YYYY-MM-DD.
- `comment` (optional): A note for the day.
- `met_nobody` (optional): 1 if the day was logged on purpose with nobody, otherwise 0.
- Leave out days that were never logged: they stay empty in the app.

A tiny example:

people.csv
```
person_id,display_name,circles,notes
anna,Anna,Climbing,
jo,Jo,Family|Neighbours,Lives next door
anna-k,Anna,Work,Desk opposite
```

meetings.csv
```
date,person_id
2026-03-07,anna
2026-03-07,jo
2026-03-09,anna-k
```

days.csv
```
date,comment,met_nobody
2026-03-07,"Bouldering, then dinner",0
2026-03-08,,1
2026-03-09,,0
```

## Rules

1. Never invent data. Everything in the files must come from my data.
2. Don't merge people on your own. If two spellings could be the same person (nicknames, typos, with or without a surname, initials), list them and ask me. Two names on the same day are always two different people.
3. Two different people with the same name each get their own person_id, but keep the display_name as written. Put what tells them apart (where we met, a group) into circles: the app uses circles to tell people with the same name apart.
4. If an entry stands for several people (a couple, a family, "the team"), ask me who is in it and log each member separately.
5. Work out the date format. If there's a weekday column, check the dates against it. If the year is missing or a date is ambiguous (01/02/2026 could be 1 February or 2 January), ask me.
6. If an entry isn't a person (a place, an event, "work"), ask me whether to drop it or move it into that day's comment.
7. Ignore columns that don't fit the format (mood, hours, ratings and so on), and tell me which ones you ignored.
8. If I give you a people.csv from an earlier import, reuse its person_id for everyone already in it, so the app doesn't create duplicates.

## How to work

1. Read my data and tell me briefly what you found: the columns, the date range, and how names are written.
2. Ask all your questions (rules 2 to 6) in one list, numbered, so I can answer by number. Wait for my answers.
3. Show a summary: number of days, people and meetings, the date range, and the 20 people I met on the most days. Wait for my OK.
4. Create the zip and give it to me as a download. If you can't create files, give me the three CSV files as separate code blocks instead.
5. End with: "In Friends Orbit, open Settings → Import your data… and pick this file." Importing only adds what's missing, so importing the same file twice is safe.
