Meet a library member: CSVTextStream, the king of performance.

This page summarizes the projects mentioned and recommended in the original post on /r/CSVinterface

Our great sponsors
  • InfluxDB - Collect and Analyze Billions of Data Points in Real Time
  • Mergify - Updating dependencies is time-consuming.
  • SonarQube - Static code analysis for 29 languages.
  • VBA-CSV-interface

    The power you need to cleanse, filter, sort, reshape, manage and analyze data from CSV files.

    To prove that we are capable to unlocks some performance limitations from traditional file processing approach, I decided to develop the CSVTextStream to gain advantage over native VBA's I/O functionalities, boosting the efficiency of text file reading up to 2 GB in size by use a buffered text stream technique. You can download the latest version from here.

  • ECPTextStream

    ECPTextStream is a VBA text buffered reader designed to manage text streams in Microsoft Office applications, from VBA.

    The table below shows the overall performance for the read operations, you can download the test files from here. The test machine is running Win 10 Pro 64-bit, Intel® Core™ i7-4500U CPU N2600 @1.80 GHz - 2.40 GHz, 8 GB RAM.

  • InfluxDB

    Collect and Analyze Billions of Data Points in Real Time. Manage all types of time series data in a single, purpose-built database. Run at any scale in any environment in the cloud, on-premises, or at the edge.

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts