Export & Import

PRO

Export your collection data to CSV for backup or sharing, and import smart collections from .afoliocollection files.

CSV Export

Go to File → Export Data (⌘E)
Choose your export options:
- Include reference IDs — adds internal IDs for re-import matching
- Parts data — choose to include owned parts, missing parts, both, or none
Click Export and choose a save location

What's Exported

The CSV includes one row per set instance (if you own two copies of a set, that's two rows). Columns include:

Set number, name, year, theme, piece count
Date added, favorite status, rating, notes
Acquisition info (type, date, source, price paid, currency)
Condition (overall, box, instructions, built status, stickers, completeness)
Disposal info (if applicable)
Parts checklist progress (if selected in export options)

Wishlist items and manually-added minifigures are also included with an entry_type column to distinguish them.

Parts Data Format

When parts data is included, it uses a compact format in the parts_owned column. Each part is encoded as partNum/colorID with quantities. For example: 3x3001/1 3002/5 means 3 of part 3001 in color 1, and 1 of part 3002 in color 5.

CSV Import

Go to File → Import Data (⌘I)
Select a CSV file previously exported from Afolio
The import matches sets by reference ID (if available) or creates new entries

You can also drag and drop a .csv file onto the Afolio window to import it.

Tip: Always include reference IDs when exporting if you plan to re-import later. This ensures updates match the correct set instances.

Smart Collection Export & Import

Smart collections use their own file format (.afoliocollection) which contains filter definitions, display settings, and icons — no personal inventory data.

Exporting

Single collection — right-click a smart collection in the sidebar and choose Export
All collections — use File → Export Smart Collections

A single file can contain multiple smart collections.

Importing

Use File → Import Smart Collections
Or drag and drop an .afoliocollection file onto the Afolio window

Before importing, a confirmation prompt shows how many collections will be added. Collections that already exist (same filter conditions) are detected as duplicates and skipped.