This Excel-based tool simplifies the task of analyzing and migrating files from local or networked drives to SharePoint (including Office 365 SharePoint Online). There are a few steps involved, none of them too difficult, and these are captured in the detailed instruction video. Intermediate skill with Excel and basic understanding of the Windows Command window is recommended. Detailed instructions on how to use this tool are in this video. For a PowerPoint deck showing the process I use for migration, see SlideShare here.
- Allows you to capture a complete list of all files that may be migrated to SharePoint;
- Gives you tools to analyze that list – you can quickly pinpoint file or directory names that contain invalid characters (like &, #, or %), file or path names that are too-long , or files that are too large to copy to SharePoint.
- Convert invalid characters to whatever you want.
- Allows you to filter or sort the list of files by name, size, date, or problem area.
- Allows you to remove spaces in file names.
- Allows you to convert names to CamelCase.
- Gives you the full power of Excel for sorting, filtering, analyzing and reporting.
- Produces a batch file of COPY (or RENAME, etc.) commands to copy to SharePoint (or anywhere) while fixing invalid names, removing spaces, or shortening long names.
- Keeps a record of the files copied for future reference.
Microsoft Excel and Windows are required for this tool. This has been developed and tested in Excel 2016, Windows 7, Windows 10, and Office 365 SharePoint online. Your results may vary. If not fully satisfied, please contact us for help or a 150% refund.