SP Data Manager Tool for SharePoint

• Turn Microsoft Excel into a powerful data management tool
• Migrate data from DBs, CSVs to SharePoint Lists
• Migrate documents from file servers or legacy SharePoint
• Migrate content and data from SharePoint Servers to Online
• Perform in-place mass field/column updates to SP Lists
• Archive SharePoint data to Excel or DB
• Move or copy data between SharePoint versions, or tenets

Now you can use Excel as your SharePoint data management power tool!  SP Data Manager allows you to map and load data into a SharePoint list, as well as pull data from SharePoint list for movement to other SharePoint sites, collections and domains. It handles complex field types like lookups, users, choice.

SP Data Manager is an Excel add-in that leverages Excel's powerful data modification features like find/replace, and fx functions to perform modifications to columns (SP list fields) and rows (SP LIst Items).   It also uses Excel's powerful connectivity to pull data from DBs, CSV files and other data sources.  Use commonly available third party exports to get your data, and use SP Data Manager to "map" the data to the target SharePoint list.

Purchasing our Workplace Solutions and need to easily migrate legacy data to it?   Need to bring historic tickets into our help desk?  Need to populate Assets?  Want to bring in Employee Docs?  Existing Policy Docs?    

Moving from SharePoint on-premise to SharePoint Online?  Need to migrate content and data to your new portals?  SP Data Manager can do it!  Connect to the SharePoint List or library in Excel, import the data, map it using the tool and push it into your target list or library in SharePoint Online.

---

Have you made a change to the status drop down in a list and realized you know have to convert the 2000 items to the new status'?  How do you do that?  Need to merge first name and last name fields into full name in a new field in the list?  How do you do that?  

Now you can.  SP Data Manager allows you to do update in place operation on list items.  Import your list items into Excel, make the find/replace changes to the existing status fields, select "update in place" and upload the changes.  Done!

Has your Help Desk ticket list gotten bloated with to many old tickets?   Need to clean out your assets list, but don't want to delete the items for historical purposes?  Now you can use SP Data Manager to select (through a list view) the items you want to archive (or archive and delete), download them to Excel or out to other storage.