Why do we need to consider multiple worksheets for Excel data import?
When importing data from an Excel workbook, you may have the scenario when your data is spread over multiple sheets in the file. You wish to import the data from all sheets in one go. codeit will ensure that the columns you select (for Id, Variable, Response and so on) are contained on each of the sheets you select for import.
How to import Excel files with multiple worksheets
The process for importing this format is the same as that covered in Data Import Overview & Basics, except for one additional step that appears at step 4 in the wizard. The screenshot below shows the option that will appear. You can choose the worksheets you wish to import in this session.
If a selected sheet doesn't contain an expected column, codeit will raise an error. Each sheet can also contain either nested or non-nested data, so it's possible to import a mix of both from a single workbook. If a worksheet sheet contains the selected "nesting identifier" column, it will be treated as nested data, otherwise it will be treated as non-nested data.
See below for an example of this data format that you can use to recreate this scenario.