Importing data from Spreadsheet.com

Importing data from Spreadsheet.com

With Zoho Tables, importing data from your Spreadsheet.com account becomes seamless and simple. You can streamline your workflow with a simplified migration process and pick up your work from right where you left off.

To import data from a Spreadsheet.com account:

  1. Click + ADD BASE at the top of the Bases Listing page, where all the bases in your workspace appear.

  2. From the list of options, choose Spreadsheet.com.

  1. You’ll be shown a confirmation to connect your Spreadsheet.com account with Zoho Tables. Click CONTINUE.








  1. After confirmation, you'll be redirected to the Authentication page, where you'll need to enter the API key from Spreadsheet.com.


  1. To obtain the API key, log in to your Spreadsheet.com account. Click on your profile and go to Personal Settings.

  2. On the Personal Settings page, go to the API Keys section.

  3. Click the Generate API key button at the top right. A pop-up window will then show you the generated API key.

  4. Copy the API key and paste it on the Zoho Tables Authentication page, in the format Bearer<space>API key (Eg. Bearer 9adj4inasdfi4). Click Connect.

  5. Once authenticated, click Choose Workspace from the Import Base pop-up window. From the dropdown menu, choose the workspace from which you wish to import. Then, click Choose Base.

  6. The bases in the chosen workspace will be listed in the dropdown menu for you to choose from. Once you've chosen the workspace and the base you want to import, click NEXT.

  

  1. You’ll see a list of modules configured from your Spreadsheet.com account in the floating window in Zoho Tables. Choose the desired modules. 

  2. From the chosen modules, choose the fields that you want to import to Zoho Tables. Each field from Spreadsheet.com will automatically be detected and matched to the fields in Zoho Tables.

  3. After choosing the desired modules and fields, click Import. This will import the selected fields from every module in Spreadsheet.com to a new base in Zoho Tables.

Some field types might not import in the same format as in Spreadsheet.com, and will be stored as text fields. You can always change them to the desired field types available in Zoho Tables.

  

  1. The importing status can be viewed from the pop-up in the bottom right corner. Once complete, you can click OPEN BASE to view the imported data.



    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 CRM Training
        Redefine the way you work
        with Zoho Workplace

          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 CRM Training

            Create, share, and deliver

            beautiful slides from anywhere.

            Get Started Now


              Zoho Sign now offers specialized one-on-one training for both administrators and developers.

              BOOK A SESSION









                                            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.




                                                Manage your brands on social media

                                                  Zoho Desk Resources

                                                  • Desk Community Learning Series


                                                  • Digest


                                                  • Functions


                                                  • Meetups


                                                  • Kbase


                                                  • Resources


                                                  • Glossary


                                                  • Desk Marketplace


                                                  • MVP Corner


                                                  • Word of the Day


                                                    Zoho Marketing Automation

                                                      Zoho Sheet Resources

                                                       

                                                          Zoho Forms Resources


                                                            Secure your business
                                                            communication with Zoho Mail


                                                            Mail on the move with
                                                            Zoho Mail mobile application

                                                              Stay on top of your schedule
                                                              at all times


                                                              Carry your calendar with you
                                                              Anytime, anywhere




                                                                    Zoho Sign Resources

                                                                      Sign, Paperless!

                                                                      Sign and send business documents on the go!

                                                                      Get Started Now




                                                                              Zoho TeamInbox Resources



                                                                                      Zoho DataPrep Resources



                                                                                        Zoho DataPrep Demo

                                                                                        Get a personalized demo or POC

                                                                                        REGISTER NOW


                                                                                          Design. Discuss. Deliver.

                                                                                          Create visually engaging stories with Zoho Show.

                                                                                          Get Started Now









                                                                                                              • Related Articles

                                                                                                              • Importing data from Zoho CRM

                                                                                                                When building a base, you can either create from scratch or import from your local or cloud storage. But what if your data is stored in Zoho CRM? Zoho Tables lets you import data from your Zoho CRM account and pick up your work from right where you ...
                                                                                                              • The basics of importing a base

                                                                                                                When you choose to import your base, all your data is read and categorized into different fields in your table. But before you complete the importing process, you can customize the base using different configurations. Filtering: You can easily tailor ...
                                                                                                              • Duplicate a Table without Data

                                                                                                                You have the option of duplicating an entire table without the data. 1. Click the dropdown arrow next to the table name, and select the Duplicate without Data option. 2. You can see a table copy is created with the table name _copy. The process is ...
                                                                                                              • Grid View

                                                                                                                Grid view Grid view is the default tabular view of your data, consisting of records and fields. It is the view you will land upon once you create the base. Grid view makes adding information to the table easier by importing files or copying and ...
                                                                                                              • Frequently Asked Questions (FAQs)

                                                                                                                What is Zoho Tables? It's an easy-to-use no-code work management tool that seamlessly connects people, processes and information. Why should I use Zoho Tables? To experience work management at its best through powerful visualizations, real-time ...
                                                                                                                Wherever you are is as good as
                                                                                                                your workplace

                                                                                                                  Resources

                                                                                                                  Videos

                                                                                                                  Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.



                                                                                                                  eBooks

                                                                                                                  Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.



                                                                                                                  Webinars

                                                                                                                  Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.



                                                                                                                  CRM Tips

                                                                                                                  Make the most of Zoho CRM with these useful tips.



                                                                                                                    Zoho Show Resources