Support Support HYPERPLANNING

  • Import a list of subjects from a spreadsheet

If you have a spreadsheet with the list of subjects, you can recover or update the data in HYPERPLANNING in a few clicks. If the database already contains subjects, check the spelling of the designations so that HYPERPLANNING does not create duplicates.

First step: preparing the spreadsheet for import

  1. The spreadsheet should have one row per subject and one column per type of information (field). An example of an Excel file is provided with the application in C:\Program Files\Index Education\Hyperplanning 2024\Réseau\Client\Exemples\Fichiers Import\
  2. It is not necessary to have a line of labels, but it can facilitate the matching with the HYPERPLANNING fields during the import.
  3. HYPERPLANNING requires at least one field using either: Designation or UID-identifier.
  4. If more than one subject is to be designated the same way, the field Code must be added that must be different for each of them so that HYPERPLANNING creates all the corresponding subjects.


  1. To import a field not foreseen in HYPERPLANNING, a column for this type of information must be provided in the spreadsheet and must comply with following syntax <Type of Information>Information so that HYPERPLANNING transforms this column into a family during the import.

Second step: import of the subjects in HYPERPLANNING

  1. In the spreadsheet file, select the data to be imported and use Ctrl + C to copy them.
  2. Go to any display from the tab Schedules.
  3. Use Ctrl + V to paste the data: the import window opens.
  4. Select at the top the type of data to import: Subject



  5. Specify Tabulation as the field separator.
  6. Match each column with a HYPERPLANNING field. To do this, click on the arrow next to the title Field ignored and from the drop-down menu select the field to which the column corresponds.
    • If a column is not to be imported, leave Field ignored. As long as required fields are missing, all data is displayed in red. If some data remains in red at the end of the mapping, it's because it doesn't match the expected format: hover the cursor over it to find out why. In most cases, the data is imported anyway, but modified to conform.
    • If you've copied column titles, tick Do not import the [1] first lines.
    • If a column contains data not foreseen by HYPERPLANNING, choose the Family option, which allows you to create fields not foreseen.
    • If imported columns contain multiple data (multiple values for your custom field), verify the sign separating them in the field Separator of multiple resources (by default, the comma).


  1. Click on Import: HYPERPLANNING proposes to switch to Exclusive Usage mode (other users switch to Consultation mode for the duration of the import, and you can choose not to keep the imported data at the end of the process).

  1. HYPERPLANNING displays a report showing the number of data items imported, created or modified.


  1. Close the window.
  2. HYPERPLANNING offers to save the import format, so that the mapping of fields to columns is preserved for all future imports of this type of data.
  3. If you were in Exclusive Usage mode, click on the button in the toolbar.
  4. In the pop-up window, choose by saving your modifications.
Was this content useful to you?
https://docs.index-education.com/docs_en/en-hyperplanning-support-page-208-676-import-a-list-of-subjects-from-a-spreadsheet.php

Can't find an answer to your question ?

Contact our support

INDEX ÉDUCATION | © 2024 - D