Skip to main content

Files Overview

Working with files in Savant

Savant provides native read and write support for the most common file types and file systems used in enterprise data workflows. This article describes the supported file types, their read/write limits, and the file system connectors available for sourcing and storing files.


Supported file types

Savant supports the following file types as both input sources and output targets in workflows.

Flat files

Flat files are plain-text tabular formats, where each row is a record and each column is a field. Savant supports:

  • .csv – Comma-separated values

  • .tsv – Tab-separated values

  • .txt – Tab-separated values

Text blobs

A text blob is a plain-text file that Savant reads as a single block of content rather than row by row. This is useful when working with unstructured or semi-structured text – such as exported logs, raw API responses, or large freeform documents – where treating the content as a table doesn't make sense.

Spreadsheets

Savant supports both Excel and Google Sheets formats:

  • .xlsx, .xls, .xlsm, .xlsb – Microsoft Excel (all major versions)

  • Google Sheets – Connected via the Google Drive file system or Google Sheets direct connectors

PDF

Savant supports .pdf files for both read and write operations. PDF extraction capabilities depend on document structure; see PDF for details.

Parquet

.parquet files are supported for columnar data workloads. Parquet is the recommended format for large-scale dataset processing in Savant.


Read and write limits

The following table summarizes the read and write size limits by file type. Limits apply per file, per operation.

Extension

Type

Read limit

Write limit

.csv

Comma-separated flat file

1 GB

1 GB

.tsv

Tab-separated flat file

1 GB

1 GB

.txt

Flat file or text blob

1 GB

1 GB

.xlsx

Excel Spreadsheet (current)

1 GB

1 GB ¹

.xls

Excel Spreadsheet (legacy)

1 GB

1 GB ¹

.xlsm

Excel Spreadsheet with macro

1 GB

1 GB ¹

.xlsb

Excel Spreadsheet binary

1 GB

1 GB ¹

.gsheet

Google Sheets

1 GB

1 GB ¹

.pdf

PDF

1 GB

1 GB

.parquet

Parquet

1 GB

1 GB

¹ When writing spreadsheets via the Microsoft OneDrive or SharePoint connectors, the write limit is 250 MB. This constraint is imposed by the Microsoft Graph API and applies regardless of file format.


File system connectors

Savant integrates with all major enterprise file systems. Each connector is configured independently and supports its own authentication model, path conventions, and performance profile.

Connector

Description

Microsoft personal and business cloud storage

Microsoft SharePoint document libraries

Google cloud storage, including Google Sheets

Box enterprise cloud storage

Dropbox cloud storage

Secure and standard file transfer protocol servers

For setup instructions, authentication requirements, and connector-specific limits, refer to the individual connector guides.


Next steps

Review the file type guides for detailed configuration options, parsing behavior, and known limitations:

Did this answer your question?