Security Question Regarding CSV Import

Morning All,

I'm working on a multi tenant app where they will require importing their customer databases via CSV.

First off all the thought of this gives me the heebee jeebies due to the level of risk in malicious data.

Having not done any CSV import validation before only image upload validation, i was wondering what the best practices are for validating against any malicious data maybe on a row by row basis.

I found the following https://laracasts.com/discuss/channels/livewire/per-row-validation-while-importing-csv-file but didn't know how current it still was as its a year old.

Any advice would be greatly appreciated.

Many thanks in advance.