Importing a table from cloud services
Importing from cloud services lets you bring files stored in your preferred cloud platform directly into Zoho Tables as a new base, without needing to download them to your device first. Zoho Tables supports a seamless transfer of data from a range of popular cloud storage providers.
Supported cloud services
Zoho WorkDrive
Google Drive
OneDrive
Dropbox
Box
What you'll need
An account with one of the supported cloud services.
A compatible file stored in that cloud service.
Access to the workspace where you want to create the base.
Supported file formats and limits
Parameter | Details |
Accepted file formats | .xls, .xlsx, .xlsm, .ods, .csv, .ics, .json, .tsv, .vcf |
Maximum file size | 20MB |
Maximum columns/fields per table | 500 |
Which plan has access?
Zoho Tables plan | Can import from cloud services? |
Free | Yes |
Professional | Yes |
Roles and permissions
User role | Access |
Owner | Can import from cloud services |
Manager and Editor | Can import from cloud services |
Data Maintainer, Commenter, and Viewer | Cannot import from cloud services |
How to import from a cloud service
Navigate to the base where you want to add the new table.
Click the + button in the base to add a new table, and choose Import from the options.
From the pop-up menu, choose Cloud Services.
On the left side of the pop-up, you'll see a list of supported cloud services. Choose the one you want to import from.
How you access your files depends on the cloud service you choose:
Zoho WorkDrive — If you have a valid Zoho WorkDrive account, your files will be accessible directly without any additional authentication.
Other cloud services — For Google Drive, OneDrive, Dropbox, and Box, you'll need to authenticate your account first:
Click the Authenticate button that appears in the pop-up.
You'll be redirected to the chosen service's sign-in page in a new pop-up window.
Sign in and grant the necessary permissions to connect your account.
Once your account is connected, you'll see a list of files available in supported formats. Choose the file you want to import and click Prepare.
All the fields and records from your file will then be listed in the pop-up window. Just customize your data, click IMPORT in the top-right corner of the pop-up window, and you're all set!
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Creating a table
Plan Free & Professional User Permissions Manager and Editor Platform Web, Android, & iOS A table is where you manage data with a collection of fields, records, and views. Creating a table from scratch To create a table, you need to click the plus ...Importing a table from Zoho CRM
Importing from Zoho CRM lets you bring your existing CRM data directly into Zoho Tables as a new base, so you can pick up right where you left off. When fields are imported, they're automatically matched to the appropriate field types in Zoho Tables, ...Importing a table from Smartsheet
Importing from Smartsheet lets you bring your existing Smartsheet data directly into Zoho Tables as a new table within a base, so you can pick up right where you left off. Each field from Smartsheet is automatically detected and matched to the ...Importing a table from a URL
Importing from a URL lets you bring in data from a file hosted online directly into Zoho Tables as a new table. As long as you have a direct download link to a compatible file, you can paste it in and import your data without needing to download the ...Importing a table from local storage
Importing a table from local storage lets you bring files saved on your device directly into Zoho Tables as a new table. Compatible files are highlighted automatically during the process, making it easy to find and choose the right data. What you'll ...