The requested file is not valid because its destination path refers to a different file type than its source counterpart

Symptoms

When attempting to copy an item using Excel, Sharegate displays the following error message:

The requested file '<filename>' is not valid. Its destination path refers to a different file type than its source counterpart.

Error code

Details

The error occurs because the Excel file contains a type mismatch between the source and destination paths. During an Excel copy, the paths for a folder must contain a trailing slash at the end. This error indicates that the either the source or destination path refers to a folder while the other refers to a file.

A path for a folder should have the following format "MyFolder/" while a path for an item or a file should look like "MyFolder/MyFile.txt".

Solution

• If the source item is a folder, make sure that the destination path ends with a slash (/).
• If the source item is an item or a file, make sure that the destination path does not end with a slash (/).