Querying CSV in a like SQL way from VBA

This page summarizes the projects mentioned and recommended in the original post on reddit.com/r/excel

Our great sponsors
  • Scout APM - Less time debugging, more time building
  • OPS - Build and Run Open Source Unikernels
  • SonarQube - Static code analysis for 29 languages.
  • QueryCsvToExcel

    Provides VBA code for executing a SQL query on a CSV file to import data into a worksheet in Excel

  • VBA-CSV-interface

    The most powerful and comprehensive CSV/TSV/DSV data management library for VBA, providing parsing/writing capabilities compliant with RFC-4180 specifications and a complete set of tools for manipulating records and fields.

    This can be great! here you can download some CSV samples.

  • Scout APM

    Less time debugging, more time building. Scout APM allows you to find and fix performance issues with no hassle. Now with error monitoring and external services monitoring, Scout is a developer's best friend when it comes to application development.

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