Import tools

Some templates were created to import data into openIMIS; these can be useful when gathering data from external systems in order to initialise openIMIS.

The templates can be found in here.


  • Open the Registers_init.ods

  • Each tab corresponds to a register e.g. tblHF for Health Facilities

  • Delete the sample data from the template

  • Insert the data to be imported into openIMIS

  • SQL insert statements are generated in the same worksheet as data is typed in

  • Copy those statement in the database manager (e.g. SQL Server management studio) and run them

Did you encounter a problem or do you have a suggestion?

Please contact our Service Desk

This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.