Awesome

DuckDB Excel Extension

This extension adds support for the TEXT function for formatting numbers from Microsoft Excel.

Example usage:

SELECT text(1234567.897, '$#.##') AS result;
┌────────────┐
│   result   │
│  varchar   │
├────────────┤
│ $1234567.9 │
└────────────┘

Documentation

See the Excel page in the DuckDB documentation.