Patron Bulk Import Helper

Seamlessly migrate your patron data into the Koha ILS with confidence.

Core Features

Universal Format Support

Import your data from .xlsx, .xls, or standard .csv files without needing manual conversion.

Smart Date Normalization

Our engine automatically translates dozens of date formats into the required YYYY-MM-DD standard for Koha.

Secure & Validated

Designed for the Library Koha Suite with integrated session authentication and secure upload handling.

How to Use This Tool

1 Upload Your File

Select your patron spreadsheet. Ensure the first row contains the column headers (e.g., Name, Email, Card Number).

2 Configure & Map

Set your global defaults (Branch/Category). Use the intuitive dropdowns to map your Excel headers to the specific database fields required by Koha.

Mandatory fields (Branch, Category, Card Number, Surname) must be assigned to ensure a successful import.
3 Generate & Import

Click "Generate & Download". The tool will process your file and provide a sanitized, ready-to-use CSV file perfectly formatted for the Koha Patron Import tool.

Return to Import Tool