Skip to main content

Introduction

This guide is intended for use by Sheetloom administrators. Refer to the Sheetloom User Guide for user-specific instructions

Sheetloom is a Decision Intelligence engine that manufactures Excel spreadsheets, weaving live data from multiple sources into complex decision models.

Sheetloom automatically injects source data into an Excel template, saving time on copying and pasting, drastically reducing data manipulation, and eliminating error. Data can come from many sources including traditional databases, APIs, CSVs, and PDFs. Multiple spreadsheets can be built and updated from the same data source.

Sheetloom works by mapping an SQL query (called a Data Stitch) to a named range or worksheet in an Excel model template. On execution, the query connects to a configured data source and injects the results directly into the Excel named range or worksheet specified in the mapping.

The generated file is immediately available for download or distribution.

Configuration, operation, and user management in Sheetloom are designed to be straightforward. Full Instructions are detailed in this guide.  

View of Sheetloom Template Explorer

 

Sheetloom video tutorials can be viewed at video tutorials, or on the Sheetloom YouTube channel.

  1. Create a Template
  2. Create a Pattern
  3. Create a Data Stitch
  4. Weave and download the results.