New ask Hacker News story: Ask HN: How to efficiently import Excel/CSV files
Ask HN: How to efficiently import Excel/CSV files 3 by leahcim | 2 comments on Hacker News. 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 database It'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 yet. Do you know of any API / widget that would allow me to offer this on my website with minimal code?