One of the most frustrating things is trying to import a massive CSV file to a collection when the data has errors that will cause entire fields not to map correctly.
I ran into this today with URLs and found a data validation option in Google Sheets to validate or only allow valid URLs to exist in your sheet.
Here’s where I found the URL validation function: ISURL Function in Google Sheets - Check/Highlight/Validate URLs