Ask HN: How to efficiently import Excel/CSV files
I have this recurring problem at my startup that I'd like to solve.Our clients give us an Excel/file and I need to 1) match the columns 2) clean up the data 3) return errors (if any) 4) import each row into my databaseIt's very difficult given that so many things could go wrong. I have already invested a lot of time in building a file parser with column matcher but the results aren't there...