Tool to auto fix broken excel links after migration to SharePoint online

JamesT100ReplaceMagic can help with fixing links after migration to SharePoint.
In general, you have relative or absolute links and, if we assume, that absolute links is:

\\ServerABC\Folder\SubFolder\Filename

and that in the future, on SharePoint, it will be:

https://company.sharepoint.com/sites/DocLib/folder/subfolder/filename

you can just set that ReplaceMagic searches for \\ServerABC and replaces it with http://company.sharepoint.com/sites/DocLib. Of course, tool can align  slashes or backslashes.

Final result will be https://company.sharepoint.com/sites/site/DocLib/Folder/SubFolder/filename and of course, all link where we have match with your search string will be updated.

Similar applies for relative links. For example, you have something like:

\Folder\Subfolder\Filename

you can replace it by searching for \Folder and making replacement with https://company.sharepoint.com/sites/site/DocLib/Folder

With this approach all files in selected location will get this change.

To get initial idea about your links you can do scan of files after migration (of course, you can do that also before migration) and ReplaceMagic will create snapshot of everything found (btw. you do not need to buy the tool to do scanning) which will be starting point to see what kind of links you will need to fix.

BR,

Oliver