Excel Import/Export Pro for ERPNext

ECOSIRE builds a proper Frappe app — a real app in your bench with its own module and DocTypes, not a pile of client-side hacks — that turns Excel exchange into a first-class ERPNext feature. At its core is an Excel Export Template DocType where you define, per source DocType, exactly which fields and child-table columns to include, the column order, header labels, number and date formats, and per-sheet grouping. Templates support multi-sheet layouts (for example, invoice headers on one sheet and line items on another, or one sheet per company or cost center) and can inject Excel formulas and subtotal rows that recalculate when the user opens the file. Generation runs through whitelisted server methods that stream the workbook with openpyxl, so styling, frozen header rows, column widths, and cell formats are baked in server-side rather than reconstructed by hand afterward. A companion Excel Import Profile DocType stores reusable field-mapping and validation rules — column-to-fieldname maps, required-field checks, link resolution (matching a supplier name to its Supplier record), and type coercion — so a smart import previews and validates every row before a single document is written.

Technically, the app is wired into ERPNext the way a native feature would be. Saved presets and generated files respect ERPNext permissions and role profiles, so a user only ever exports fields and DocTypes they are already allowed to read, and row-level permission filters are honored in the query. Export and import actions are exposed both as buttons via client scripts on the relevant list and form views and as authenticated endpoints on the Frappe REST API and whitelisted methods, so other systems can request a formatted workbook programmatically. Template-based recurring exports are registered as scheduler_events (hourly, daily, weekly, or a custom cron) that build the workbook and deliver it by email or drop it into a File attachment or configured folder — no one has to remember to run the Monday report. Where business logic needs to fire around an export or import, we use hooks.py doc events and server scripts rather than editing core, which keeps the app upgrade-safe.

Because this is a build-to-order app, you are not downloading a fixed listing — ECOSIRE scopes the templates, DocTypes, formats, and schedules to your actual reporting needs and builds against your ERPNext version. Delivery is typically 2 to 4 weeks from confirmed scope, depending on how many templates and import profiles are in the first release. We install it on a staging site, run UAT with your real data, then deploy to production with a rollback plan, hand over the git repository, and support it through an agreed post-go-live window. The app targets Frappe/ERPNext v15 and v16.