MDCollections + Obsidian vs Spreadsheets
Spreadsheets are often the first place people track a collection because they are familiar, flexible, and fast to start. The tradeoff is that physical-item workflows usually outgrow rows and columns. The better question is often whether a spreadsheet is enough, or whether MDCollections plus Obsidian gives you a better long-term setup for real-world collections.
| Category | MDCollections + Obsidian | Spreadsheets |
|---|---|---|
| Best fit | People tracking physical collections with images, notes, barcodes, and storage locations | People who want a fast general-purpose table for lists, counts, and lightweight sorting |
| Data model | One Markdown file per item, plus supporting images and documents in normal folders | Rows and columns in a spreadsheet file or cloud sheet |
| Images and attachments | Designed for item photos, scans, and supporting files | Possible, but usually more awkward and less central to the workflow |
| Barcode capture | Built around mobile scanning and optional product lookup | Usually manual unless you add external tooling |
| Physical storage tracking | Locations, containers, and QR labels are built in | Possible to represent in columns, but not a workflow the tool is built around |
| Obsidian compatibility | Strong, because the underlying data is Markdown | Weak, because the collection lives as a table rather than note files |
Choose MDCollections + Obsidian if
- the collection includes photos, scans, notes, and structured properties per item
- you want each item to exist as a real file instead of only a spreadsheet row
- barcode workflows and storage locations matter
- you want the data to stay usable in Obsidian
Choose spreadsheets if
- the collection is mostly a flat list of values
- you care more about quick ad hoc tables than item-level files and media
- you are already comfortable living in Excel or Google Sheets
- physical storage, mobile capture, and barcode workflows are not core needs
Bottom line
Spreadsheets are excellent general tools for tabular data. MDCollections plus Obsidian is better when the collection is about real items, richer records, and a workflow that continues to make sense after the first hundred entries.