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.