Our great sponsors
-
VBA-CSV-interface
The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV 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.
You can use the VBA CSV interface in a smart way. The first step would be to create a new CSV with only the desired columns, then you can filter the information or subset the created CSV data into individual pieces of meaningful information. In my test, an input file with 12 columns (191 MB) is converted to a 4-column CSV (68.9 MB) and only European sales are retrieved from this file. The good news is that there is only 2 MB of data in memory when creating the 4-column CSV. Here is the file used in my test, set to C:\csv's\ folder to run the test on your own. Here is a clip showing the code in action.