XLSX import interface

available from ID Validation 1.5.0 / free of charge for all existing customers

With the import interface for Microsoft Excel (XLSX) file, the module “Duplicate check” offers you a possibility, to check your entire database from your master data.

We take care to maintain compatibility (also with Microsoft Excel) when extending the XLSX duplicate interface. This means that you can always use the latest version without generating additional effort when integrating it into your ERP system.

In order to be able to uniquely assign an XLSX data record from your ERP system in the duplicate check, you have the option, specify up to two unique keys in the import file. These are returned in the export file and can be used for re-import into your ERP system. However, you can also leave these two fields (Key_1 and Key_2) blank.

The names of the column headers of the duplicate check are searched for within the XLSX file during import and assigned during import. Please enter only one name at a time, e.g. “key1” and not “key1,key_1”.

The upper and lower case of the column headers is not relevant for the import.

Structure - import file

fieldformatexample
key1String
key2String
firstnameString
lastnameString
name1String
name2String
name3String
name4String
streetString
numberString
postcodeString
townString
departmentString
countryString

Structure - export file

The XLSX export file of the duplicate check contains the returned values of the individual checks, also, unless otherwise specified, in the same data format.

fieldformatexample
internalidString
key1String
key2String
firstnameString
lastnameString
name1String
name2String
name3String
name4String
streetString
numberString
postcodeString
townString
departmentString
countryString
// cleaned data
cleaned firstnameString
cleaned lastnameString
cleaned name1String
cleaned name2String
cleaned name3String
cleaned name4String
cleaned streetString
cleaned numberString
cleaned postcodeString
cleaned townString
cleaned departmentString
cleaned countryString
// applied cleaners
applied cleanersString
// applied duplicates
duplicate idsString
address groupString

XLSX versions

We support in the module duplicate check all XLSX versions up to and including the latest version of Office 365. Please understand that we will no longer support older versions (XLS). support older versions (XLS).

Our test scope for the duplicate check module includes many different variants of how a Microsoft Excel document can look like. Nevertheless, we could not test all functions and possibilities tested. If you encounter a problem when importing XLSX files, please contact us and send us one or two test data sets so that we can help you quickly. help you.