Spreadsheets come in different shapes, sizes, and formats. Sheetgo was built to support many spreadsheet formats from the most common, to those more specific. Each file format has its own structure that the Sheetgo workflows can empower.
Which file formats are supported by Sheetgo?
Currently, Sheetgo supports these formats:
Google Sheets
XLS
XLSX
CSV
TSV
BigQuery
JSON 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 review 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, only as a destination or step for automations.
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 automations can be affected by the size and content of your sheets, such as:
Cell size: The more data you have in a file, the longer Sheetgo will take to update the connection.
Formulas and formatting: The more formulas and formatting a spreadsheet has, the harder it is to read.
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.