function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
MeighanSFMeighanSF 

Over 1k Matching xls files to Cleanse

It is pre-Salesforce import, I have designed the Named Account structure inside Salesforce, and I have 1500 Hoover's D&B Family Trees with the same columns and headers in .xls form. What do I use to mass clean these files so we do not import bad data? Do I try a batch import of the folder via the dataloader but say in SF if column equals don't import so it errors via a VR? Do I clean else where? Access? Too many rows for excel... Batch import?  Use SharePoint?  Please help my data find a way home...
ShashankShashank (Salesforce Developers) 
You may want to take a look at data.com clean: https://help.salesforce.com/HTViewHelpDoc?id=data_dot_com_clean_clean_overview.htm&language=en_US