Skip to main content
Data Cleanse

Tips and tricks on how the data should be cleaned before loading it to the platform

Salma Talib avatar
Written by Salma Talib
Updated over a week ago

By using the bulk upload functionality, it speeds up the uploading of stakeholders. Typically this files are created by pulling data from different sources, different users adding the data etc.

To ensure that the data is loaded successfully into SSTK follow the below steps:

· Remove formatting – including merged cells/ highlighted

· Remove any non standard characters such as (), -/spaces in the phone number

· Remove double ups of phone numbers in 1 cell - such as mobile and landline

· Ensure you have correct data in the correct fields

· Split the landline and mobile phone number into 2 columns

· All records must have a first name - if they do not either add Unknown or . so it loads

· Split name into first name/last name – use text to columns

· Remove double ups of emails in 1 cell and add the second email into the about cell

· Remove duplicates

· Once cleaned the save the file in xls

Did this answer your question?