Import timesheet from file | Imports | Zoho Sprints

Import timesheet from file

Easily recreate your time log entries by importing them into Zoho Sprints from a file. Zoho Sprints supports XLS, CSV, and JSON file formats, making it simple to migrate your offline time logs into a structured, trackable format.

Use case 

Managing work hours for billing can be a daunting task, especially when you have to maintain detailed logs manually. As a workspace owner, tracking each user's logged hours in a spreadsheet can quickly become overwhelming. Zoho Sprints' Timesheet module can simplify this process.

Zoho Sprints also allows you to import your existing time log entries into the Timesheet module seamlessly. With just three simple steps, you can easily upload your existing file and have all your existing time logs imported, ensuring no data is left behind.

Import Timesheet     

You can import your timesheet into Zoho Sprints just with three simple steps.
  1. Upload your file.
  2. Map data in the file.
  3. Initiate import.

Upload your file  

  1. Click in the top-right corner to navigate to the Settings page.
  2. Click Timesheet under Imports. (or)
  3. Navigate to the Timesheet module within a project.
  4. Select the ellipsis icon at the top and click Import.
  5. Click the Upload your file box to search and locate the file. 

  6. Click Upload to upload the file.
  7. Select the project to which the timesheet needs to be imported.
  8. Click the Import button. The file will be selected to import. Next, you will be redirected to data mapping.
 Note: Import of Meeting log hours isn't supported  

Field mapping 

The list of Timesheet fields will be displayed. This includes fields like Log type, Item name, Description, Log hours, Billing status, and more. A drop-down field will be displayed next to each of the fields, allowing you to pick data from the file you're importing. This enables you to map the file data with the sprint data format. When this mapping is done, your imported items will be in the proper sprint format.
 
You can test your import with the available sample XLS file.  Field mapping helps you transform your data into time logs. Map file fields to their corresponding fields in Sprints. 



 Note:  
  1.  It is mandatory to have the Log type, User, Log date, and Log time fields. 
  2.  Mismatched fields will have default values, while the rest will be unmapped in Zoho Sprints. 
 
During field mapping of Work item logs, if Item name and Item ID are missing in the project, the log will be added under the general log.

User mapping    

Use this option to map users in your file to the corresponding users in your project. Map the time log entries of the users to the corresponding users in Zoho Sprints. Once the users are mapped, click Continue.  


 

Initiate import

Once you've completed the mapping and you click Continue, the import is initiated. The process might take some time, but you will be notified via email once the import is complete. You can also check out the completion status in your feed and activity stream.
 
Note: If the import fails, you will receive an email notification with an attachment that details the reason for the failure.
 

      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 FormsRetailOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceForms for Solopreneurs
                              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
                              Forms for Government
                              Intake FormsLegal
                              Mobile App
                              Form DesignerHR
                              Mobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic FormsInsurance
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsWufoo alternativeEncrypted Forms
                              Accessible FormsTypeform alternativeSecure 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

                                                                  Use cases

                                                                  Make the most of Zoho Desk with the use cases.

                                                                   
                                                                    

                                                                  eBooks

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

                                                                   
                                                                    

                                                                  Videos

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

                                                                   
                                                                    

                                                                  Webinar

                                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                                   
                                                                    
                                                                  • Desk Community Learning Series


                                                                  • Meetups


                                                                  • Ask the Experts


                                                                  • Kbase


                                                                  • Resources


                                                                  • Glossary


                                                                  • Desk Marketplace


                                                                  • MVP Corner



                                                                    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

                                                                                                                            • About timesheet

                                                                                                                              Businesses primarily use timesheets to understand the time taken to complete tasks, estimate the cost of the work based on the hours invested, monitor the number of hours employees log in, and ensure time is used productively. Timesheets help record ...
                                                                                                                            • Can I import work items from excel?

                                                                                                                              Yes, you can import wok items from an excel file to Zoho Sprints. The supported file formats for import are XLS, XLSX, CSV, and JSON. Learn how to import data from file. You can import work items from Zoho Projects and Jira as well.
                                                                                                                            • Filter and export timesheet

                                                                                                                              The filter and export capabilities of Zoho Sprints enables you to efficiently view and use the logged timesheet data. You can: Filter the log hours to view select data. Export the log details as a file. Copy data to clipboard and paste in on a sheet ...
                                                                                                                            • Import data from file

                                                                                                                              Importing work items from a file allows you to easily recreate existing data within Zoho Sprints. Example Let's assume you have a customer issue tracking system in which all the issues filed by your customer are monitored. You need to transform those ...
                                                                                                                            • Timesheet in kanban

                                                                                                                              Businesses primarily use timesheets to understand the time taken to complete tasks, estimate the cost of the work based on the hours invested, monitor the number of hours employees log in, and ensure time is used productively. Timesheets help record ...
                                                                                                                              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