https://datafetcher.io/
Python + Pandas would be my choice to develop something.
Ask HN: How to efficiently import Excel/CSV files
11–13 of 13 posts
Re: Ask HN: How to efficiently import Excel/CSV files
#12I’m not sure I understand the problem space here, but consider AWK. It really changed how I think about any problem involving tabular data parsing.
Re: Ask HN: How to efficiently import Excel/CSV files
#131. Come to an agreed upon format with clients
2. SSIS