As an ecommerce business owner, you’re probably managing data across inventory lists, customer orders, and marketing campaign performance. For decades, ...

In this video, we cover the new IMPORTCSV and IMPORTTEXT functions in Excel, which simplify importing data into the application. The IMPORTCSV function allows importing CSV files using just the file ...

Abstract: Brunei Darussalam’s annual labour-force census has historically required months of manual cleaning across ~150,000 records and 60 fields. We developed an Excel-native automation that ...

A lightweight, fast SQL query processor written in C that enables executing SQL queries directly on CSV files without requiring a database. For full documentation, see the /doc directory.

This VBA Excel application allows users to import a CSV file of credit card or bank transactions, and then generate basic pivot table reports for analysis. The application provides an easy-to-use ...

ASP.NET Core offers a simplified hosting model, called minimal APIs, that allows us to build lightweight APIs with minimal dependencies. We’ve discussed minimal APIs in several earlier posts here.

Have you ever found yourself staring at a sprawling Excel workbook, wondering if you’re using the right tool for the job? Between Power Query, Power Pivot, and VBA, it’s easy to feel like you’re ...