All Collections
Installation and setup
Which file formats are supported by Sheetgo?
Which file formats are supported by Sheetgo?

Learn what kind of file formats are supported by Sheetgo and their limitations.

Eugenia Langen avatar
Written by Eugenia Langen
Updated over a week ago

There are spreadsheets of different shapes, sizes, and formats. Sheetgo is a platform that was built to support many spreadsheet formats from the most common, to those more specific. Each file format has its own structure that can be empowered by the Sheetgo workflows.

Which file formats are supported by Sheetgo?

Currently, Sheetgo supports these formats:

  • Google Sheets

  • XLS

  • XLSX

  • CSV

  • TSV

  • BigQuery

  • API

What are the file format limitations?

Sheetgo-supported formats have their limitations when it comes to how they interact with each other. But what is the difference between them? Are there limitations around each? To answer those questions, let’s go through each file format and its limitations when using Sheetgo.

Please note: The file formats listed below are the only files you can use as source files when using Sheetgo. Whilst you can use Sheetgo to create PDFs, Google Docs, and even emails, they cannot be used as a source for a connection, only as a destination or step for a connection.

Google Sheets limitations

Google Sheets presents the least amount of limitations. It only offers limitations that are related to Google and are linked to file size and cells:

  • Cells: 10 million cell limit for spreadsheets that are created in or converted to Google Sheets.

  • Rows: 40,000 row limit at one time.

  • Columns: 18,278 column limit.

  • Tabs: 200 sheets (tabs) limit per Google Sheets file.

  • GoogleFinance formula: up to 1,000 GoogleFinance formulas in one file.

  • ImportRange formula: up to 50 cross-workbook reference formulas in one file.

  • ImportData, ImportHtml, ImportFeed, or ImportXml formula: up to 50 functions for external data in one file.

  • Strings: up to 50,000 characters.

Excel Limitations

When using Excel in Sheetgo, you will be able to use all tools except for:

  • Cell color filter.

  • Color cell and text formatting.

You can learn more about Excel file format limitations on the Microsoft Support Page.

CSV and TSV Limitations

When using CSV or TSV in Sheetgo, you will be able to use most tools except for:

  • Cell color filter.

  • Color cell and text formatting.

  • Number formatting.

  • Cell and text formatting.

CSV/TSV files are most commonly used to hold significant amounts of data due to how they keep track of it. However, this comes at the cost of customization and readability.

Other formats not supported by Sheetgo

Other commonly used formats currently unsupported by Sheetgo are:

  • XLSB - Excel Binary Workbook file

  • XLSM - Excel Macro-Enabled Workbook

It is also worth mentioning that a connection can be affected by the size and content of your sheets, such as:

  1. Cell size: The more data you have in a file, the longer Sheetgo will take to update the connection.

  2. Formulas and formatting: The more formulas and formatting a spreadsheet has, the harder it is to read.

  3. File size (Excel): The larger the file, the more resources Sheetgo must allocate to read the file. Please keep in mind that it may take more time to read a small file with many formulas and formatting than to open a larger file without any formatting.

Need more help?

Contact us via chat, on our email ([email protected]), or send us a ticket!

Visit our Community for help, tips, tricks, and feedback for Sheetgo.

Did this answer your question?