Before you import your data using a Microsoft Excel file, you will need to make sure that the Excel file meets the required formatting. Below is a list of items to take into account:
· The Excel file must have a column called ID and the value in each row must be unique
· The ID column must be the first column of the sheet
· The ID column header must be the first row of the sheet
· All column headers must be on the first row of the sheet
· (Optional) You can include a ParentID column to define a parent for each topic that is created. This column should contain de ID of the topic that will act as the parent for each topic. This allows you to build a structure with the imported topics
· Make sure that only values are stored in the sheet and not results of functions (Copy and paste values)
If your Excel sheet does not meet the requirements, you will be given a message during the import to explain what you need to do to make the sheet compatible.
Simply click the Details button to get a description.
