Zoho Analytics can pull data directly from the most widely used cloud storage services, removing the need to download files locally before importing. This guide covers the supported platforms, file types, and key features of cloud storage imports.
Files stored in cloud platforms can be imported in the following formats: CSV, TSV, Excel (.xls and .xlsx), HTML, JSON, XML, and zipped versions of these file types.
Cloud storage imports support up to 1,000,000 rows or 100 MB per file, whichever limit is reached first. For larger datasets, use the Zoho Databridge utility to handle the import in chunks.
Zoho Analytics supports authenticating multiple accounts for each cloud storage service. This means you can connect to files across different personal and business accounts on the same platform without repeatedly signing in.
Set up automated, periodic imports from your cloud storage to keep your Zoho Analytics tables up to date. This is particularly useful for teams who regularly update shared spreadsheets stored in Google Drive, OneDrive, or SharePoint.
In addition to cloud storage, Zoho Analytics supports data import from local files, FTP servers, web-based feeds and URLs, cloud databases, and direct application connectors. Each method uses the same guided import wizard.