-
CSVLint
CSV Lint plug-in for Notepad++ for syntax highlighting, csv validation, automatic column and datatype detecting, fixed width datasets, change datetime format, decimal separator, sort data, count unique values, convert to xml, json, sql etc. A plugin for data cleaning and working with messy data files.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
There's a CSV Lint for Notepad++ which is freeware. It cannot work with Excel files, but you can copy&paste the data as if it's CSV data. From there the plug-in can automatically detect column datatypes and generate `CREATE TABLE` and `INSERT INTO` scripts.