Skip to content

feat: CSV/spreadsheet metadata export from Library #128

@nikazzio

Description

@nikazzio

Summary

Allow exporting the Library catalog as a CSV or Excel file containing manuscript metadata.

Motivation

Researchers need to produce inventories, share lists with colleagues, or import data into reference managers (Zotero, EndNote). A CSV export of the library catalog is a standard requirement.

Proposed fields

  • Manifest ID / URL
  • Title
  • Provider / Institution
  • Date (if available in metadata)
  • Page count
  • Transcription status (% complete)
  • Download date
  • Local path
  • Custom tags/notes (if implemented)

Acceptance criteria

  • "Export as CSV" button in Library toolbar
  • CSV includes all key metadata fields
  • UTF-8 encoding with BOM for Excel compatibility
  • Optional: Excel (.xlsx) format via openpyxl
  • Filters applied in Library UI are reflected in export (export what you see)

Technical notes

  • Python csv module for CSV, openpyxl for Excel (optional dependency).
  • Route: GET /library/export?format=csv
  • Stream response for large libraries.

Metadata

Metadata

Assignees

No one assigned

    Labels

    area:exportExport pipeline and jobsminorIncrements the minor version when adding new functionality in a backward-compatible manner.priority:P3Low priority / backlogstatus:readyReady to be implementedtype:featureNew user-facing feature

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions