Batch Convert XBRL to Excel
The Batch Conversion command in the Excel ribbon enables you to convert multiple XBRL instance files to Excel format. The result would be the same as if you imported multiple XBRL instance files and then saved them to Excel format. The main advantage is that the conversion is processed as a batch. To perform a batch conversion, add all the required files to a batch as follows:
1.Click the Solvency II tab in the Excel ribbon.
2.Click the Batch Conversion button.
3.Click Add Files. Alternatively, right-click the grid and select Add Files from the context menu.
The formats available for batch conversion are shown in the screenshot below:
Additional options in the Batch Conversion dialog box
The conversion dialog box allows you to perform the following additional tasks:
1.To add files from additional source locations to the same batch, click Add Files.
2.Whenever you add new files to the batch, their default target folder is the same as the source folder. If you want to assign a specific target folder to all new files by default, select it from the list called Default target folder for new files. To add new entries to the list, click Browse and choose a folder. By default, the option Default target folder for new files affects new files that you add to the batch. However, if you change this option, and if the files already exist in the batch (in the grid), you will be informed that the change will affect all new files added to the batch. Click Yes if the target folder of existing files should be changed as well.
3.You can choose to save all converted files to the same target folder or set a different target folder for each file. To change the target folder of specific files, first select the files in the grid. Then right-click the grid and select Set target folder from the context menu.
4.You can rename the target files. First, select the files in the grid. Then right-click the grid and select Rename from the context menu (or press F2). You can change both the file name and the file path. However, if you change the path, make sure that it exists.
5.To remove files from the batch, select them, right-click the grid and select Remove from the context menu (or press the Del key).
Selecting multiple files
To select multiple files from the grid, use the standard Windows key combinations, for example:
•While holding the Ctrl key pressed, click to select the files of interest.
•Click an empty area in the dialog box and then drag the cursor over the files to be selected (rectangular selection).
•Press Ctrl+A to select all files in the grid.
Once the batch is ready, click Convert to process all files in it. If any files with the same name already exist in the target folder, a message box appears asking your confirmation to overwrite them.
During the batch conversion, a dialog box informs you about the progress. The outcome of the conversion is reported in the Validation Report window (see screenshot below):
The validation report for batch conversion is similar to that for a single imported XBRL instance file. For more information about validation messages, see Validate Data.