Skip to main content
Skip table of contents

Add data from file

Enrich any grid with data from an Excel or CSV file.

  • The added columns and data temporary. They are available until the window is closed.

  • The added columns are NOT comments/annotations.

Add data from file

From the Grid Actions tab:

  1. Click ‘Add data from file’ and select your file when prompted.

  2. Set to ‘All Rows’ if you don’t want to add only for selected entries.

If you are using a CSV file, set the separator character used (usually a comma) from the submenu list.

  1. Set the mapping key by selecting the header of the matching columns in the file and in the grid.

  2. Select the file columns that you want to add to the grid.

Make sure that your file contains headers. These will be imported as column titles in the grid.

add-data-to-grid.jpg

Remove all added data

Use the submenu item of ‘Add data from file’ to remove all data that was added from a file or list.

remove-added-grid-data.jpg

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.