Input data validation prior to import

[etsanov]

Hello,

Is there a tool of some sort which can validate the CSV data prior to the import (e.g. look for whitespaces, incorrect syntax, etc.)? We will start a drop shipping service using Magmi, and we want our partners to send us CSV files with their product data. We want to import this data, but we need a tool that can validate the data prior to the import to avoid issues. It could return errors for affected products and remove them from the feed until fixed. Any ideas? Thank you.