Export data to SharePoint

Export data to SharePoint


 

Zoho DataPrep supports exporting data to SharePoint, a cloud storage service that allows users to store, organize, share, and access information from any device.

To export data to SharePoint  


1. Click the Export now option from the Export menu in the DataPrep Studio page.


 

 

2. You can choose the Cloud storage category and click SharePoint or type SharePoint in the search box.

 

 

NotesNote: If you had already added a SharePoint connection earlier, you can simply select the existing connection under the Saved connections section and proceed with exporting. To learn more about Saved connections, click here. 

3. If your data contains columns with personal data or ePHI data, you can choose to include or exclude them in the Columns section. You can also apply the required security methods to protect your data as follows.

 

A. Data masking    

Data masking hides original data with 'x' to protect personal information.

 

B. Data Tokenization  

Data tokenization replaces each distinct value in your data with a random value. Hence the output is statistically identical to the original data.

 

C. None

You can select none if you do not want to use any security method. You can choose whether to export these column using the corresponding check boxes.  

 

 


Notes

Note:

  1. Exporting datasets without securing personal data will be restricted if Secure data exports option is enabled in your organization's privacy settings. Click here to know more.

  1. Based on the Compliance settings of your organization, exporting datasets with ePHI data may be restricted or restricted without securing ePHI data with security measures or password protection. Click here to know more.

 

4. Click Next and if you have added a connection already, click the existing connection and start exporting data.




NotesNote: Click the Add new link to add a new SharePoint account. You can create as many SharePoint connections as required.

 

5. You will need to authenticate SharePoint when you try connecting to SharePoint for the first time. Click the Authenticate SharePoint button to authenticate your account with your credentials.


 


NotesNote: The connection configuration will be saved for exporting data to SharePoint in the future. Credentials are securely encrypted and stored.


6. You can choose to export the dataset in any of these supported file formats:
CSV, TSV, JSON, XLS, XLSX, and XML formats.

7. Select the required option from the File export option. You can choose to Add as new version or Add as new file during export.

8. Use the Compress file option to save your export as a .zip file.

9. You can also encrypt the file and protect it using a password before export.



10. You can also click the Advanced options link for the following options.

  • You can encode the file using character encoding methods like UTF-8 using the File encoding option.

  • You can use a Row Separator such as UNIX (Line Feed) or MAC (Carriage Return) to ensure the line endings are translated properly.

  • You can distinguish the point at which the content of a text field begins and ends using Text qualifiers such as Single Quote(') or Double Quote(").

  • You can separate out the data or split using a Delimiter such as a Comma(,) , Semicolon(;) , Space, Tab, or Custom.

11. Navigate to the folder you want to place the file in and click Export.

 

12. You can schedule the export by clicking the Configure schedule> link that appears after successful export.


SEE ALSO

How to import data from SharePoint into Zoho DataPrep?
What are the other cloud storage options available in Zoho DataPrep?

What other export options are available?

Learn about scheduling export.

How to export data to cloud database?


      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


        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







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsEnterpriseOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceAccessible Forms
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Intake FormsLegalMobile App
                              Form DesignerHRMobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic Forms
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsEncrypted Forms

                              Secure Forms

                              WCAG

                                      Create. Review. Publish.

                                      Write, edit, collaborate on, and publish documents to different content management platforms.

                                      Get Started Now






                                                        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


                                                              • Desk Community Learning Series


                                                              • Digest


                                                              • Functions


                                                              • Meetups


                                                              • Kbase


                                                              • Resources


                                                              • Glossary


                                                              • Desk Marketplace


                                                              • MVP Corner


                                                              • Word of the Day


                                                              • Ask the Experts


                                                                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 Demo

                                                                                                  Get a personalized demo or POC

                                                                                                  REGISTER NOW


                                                                                                    Design. Discuss. Deliver.

                                                                                                    Create visually engaging stories with Zoho Show.

                                                                                                    Get Started Now









                                                                                                                        • Related Articles

                                                                                                                        • Export data to Oracle Cloud

                                                                                                                          Zoho DataPrep allows you to export data to Oracle Cloud, a cloud computing service offered by Oracle Corporation. It provides servers, storage, network, applications and services through a global network of Oracle Corporation managed data centers. To ...
                                                                                                                        • Export data to cloud databases

                                                                                                                          You can export data to the following cloud databases. Amazon RDS - MySQL Amazon RDS - MS SQL Server Amazon RDS - Oracle Amazon RDS - PostgreSQL Amazon RDS - Maria DB Amazon RDS - Amazon Aurora MySQL Amazon RDS - Amazon Aurora PostgreSQL Amazon ...
                                                                                                                        • Export data to IBM Cloud-DB2

                                                                                                                          Zoho DataPrep allows you to export data to IBM Cloud, a cloud database. IBM Cloud database solutions offer a complete portfolio of managed services for data and analytics. To export data to IBM Cloud 1. Click the Export now option from the Export ...
                                                                                                                        • Export data to Google Cloud SQL - MySQL

                                                                                                                          Zoho DataPrep allows you to export data to Google Cloud SQL, a cloud database. It is a fully-managed database service that helps you set up, maintain, manage, and administer your relational databases on Google Cloud Platform. To export data to Google ...
                                                                                                                        • Export data to Rackspace Cloud MySQL

                                                                                                                          Zoho DataPrep allows you to export data to Rackspace Cloud MySQL, a standalone, API-based relational database service built on OpenStack® cloud that allows Rackspace customers to easily provision and manage multiple MySQL database instances. To ...
                                                                                                                          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