Why SCD? Do you ever find yourself spending too mch time tediously updating spreadsheets? You have your own spreadsheet with the data you need, formatted just the way you like it, but there are spreadsheets out there with more information, or more up-to-date information you would like included in your own spreadsheet. Or maybe you need multiple people to update your spreadsheet, so you email it to a dozen people and get a dozen emails back, each containing different updates that then must all be consolidated back into the original spreadsheet somehow.
Example Scenario In our example here, the source document has a complete list of twenty employee's with last and first name, along with their spouse's name and the date they were hired. In your document, the destination spreadsheet, you're missing spouse and hire date information, but you want them. Since there is no data point in the source spreadsheet to quickly filter down to the exact list of names in your own document, you would have to find and then copy/paste each individual cell, one at a time. Even worse, sometimes the data is not in the format you want, so you end up retyping to match your desired capitalization, or converting numbers and dates in string format to the correct format.
Scenario Continued... Simply add matching column headers to your destination document. Upload both your source and destination spreadsheets and SCD will analyze your files, determining what information should be copied over, and in what format. In less than a minute you'll be able to download the results.
Notice SCD updated Chris to Christopher, highlighted it yellow to identify the update, and maintained the uppercase format used in your destination file. Spouse and Hire date’s were filled in and highlighted green to indicate new data, and the hire dates that were originally stored as text, preventing you from correctly sorting the data by date, has been converted to a correct date format that allows for proper sorting.
Security All files uploaded to the service are encrypted both in transit and at rest. You will first need to create a user account as those login credentials are used to encrypt your data and ensure it remains isolated from other users on the system. Once you logout, all files (source, destination, and results) are immediately deleted from the servers. Your data is never retained nor used for any other purpose.
