Please enable JavaScript to view this site.

Altova® EBA add-in for Excel, version 2020r2 Enterprise Edition

Common Tasks

Batch Conversion from XBRL to Excel

Scroll Home Prev Top Next More

The Batch Conversion command in the Excel ribbon enables you to convert multiple XBRL instance files to Excel format. The result is the same as if you imported multiple XBRL instance files and then saved them to Excel format—while having the advantage that conversion takes place in batch.

 

In order to perform a batch conversion, you must first add all the required files to a batch, as follows:

 

1.In the Excel ribbon, click the EBA tab.

inc-xa-insert-eba

2.Click the Batch Conversion button.

3.Click Add Files. (Alternatively, right-click the grid, and select Add Files from the context menu.)

inc-eba-batch-conversion-dialog

From the conversion dialog box, you can perform the following additional tasks:

 

1.To add files from multiple source folders to the same batch, click Add Files and select the desired source folder.

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 Default target folder for new files list. To add new entries to the list, click Browse and choose a folder.

 

Note: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 files already exist in the batch (on the grid), a dialog box like the one below appears. Click Yes if the target folder of existing files should be changed as well.

inc-xa-change-target-folder-dlg

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 on the grid, and 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 on the grid, and 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, first select them, and then right-click the grid and select Remove from the context menu (or press the Del key).

 

Tip:        To select multiple files from the grid, the standard Windows key combinations apply, 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 at the target folder, a message box appears asking your confirmation to overwrite them.

 

While a batch conversion is running, a dialog box appears that informs you about the progress. The outcome of the conversion operation is reported in the Validation Report window, for example:

inc-eba-batch-conversion-result

When performing batch conversion, the same validation takes place as when importing a single XBRL instance file. If validation is successful, a message similar to "Successfully converted file.xlsx" is reported in the Validation Report for each file. If there are validation errors or warnings, they are reported in the Validation Report as well.

© 2020 Altova GmbH