CSV Guide

Introduction

Sheetloom provides a useful feature to upload a CSV file and convert it into a database table that can be queried like any other data source.

A CSV file and the database table it creates can be replaced or appended in future uploads.

When a CSV is uploaded into Sheetloom, a folder of the same name is created to store it. A database table with the same name as the CSV is created.

Custom Columns

During the initial CSV upload process, a custom column with a preassigned default value can optionally be added. At runtime the custom column name can be used as a parameter to permit filtering on an appended file using the default custom column default value supplied. See custom columns for further details.