Can Power Query's simple INNER JOIN CSV query be faster? [EXCEL]

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

Our great sponsors
  • WorkOS - The modern identity platform for B2B SaaS
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • SaaSHub - Software Alternatives and Reviews
  • VBA-CSV-interface

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

    On the one hand there is a recorded macro to execute two queries and perform an operation similar to SQL INNER JOIN. The macro also sorts the result in ascending order in the "Country" field. The other contender is a procedure that will perform the same operations using the VBA-CSV interface* library.

  • WorkOS

    The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.

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