Formatting Problem | Export to Zoho Sheet View

Formatting Problem | Export to Zoho Sheet View

When I export data to Zoho Sheet View, ID columns are automatically formatted as scientific notation. Reformatting them to text changes the actual ID values. For example, 6557000335603071 becomes 6557000335603070.

I have attached screenshots showing this issue. Since I work extensively in Zoho Sheet View, I need a way to preserve the original ID values during export.

Is there a solution to prevent this formatting problem?


      • Sticky Posts

      • Meet the new Zoho Analytics: The Agentic Analytics platform

        Every major release of Zoho Analytics has changed what you can do with data. This one changes who does the work. For years, analytics meant a chain of hands. The engineer shaped the data, the analyst wrote the query, the designer built the dashboard,
      • [Virtual launch event] Experience the agentic analytics platform | A sneak peek into Zoho Analytics 7.0

        AI and agents are reshaping how businesses operate, and teams that can act on contextual, real-time intelligence are the ones best placed to adapt. Analytics platforms are evolving fast to meet that need. Join us for a live walkthrough of Zoho Analytics
      • What's New in Zoho Analytics - August 2026

        Hello Users! This month puts you in control of how your analytics moves: promote content safely between workspaces with Deployment Management, govern data access and sign-in more precisely, and make your forecasts smarter with external drivers. There's
      • What's New in Zoho Analytics - June 2026

        Hello Users! This month is about meeting your data wherever it lives: reaching it from AI assistants, bringing it in from more sources, and keeping it flowing with less manual effort. Here's what's new across Ask Zia and AI, data import, integrations,
      • What's New in Zoho Analytics - February 2026

        Hello Users! We're back with another round of updates for Zoho Analytics. This month's release focuses on giving you greater flexibility in how you visualize, manage, and act on your data - with new features like custom visualizations, remote MCP server,

        • Recent Topics

        • Global Constants / Variables

          It would be great if there were a Global Constant feature. The idea here is for managing constants that are used in multiple Flows and Subflows, but might change over time. The idea is that the change could be made in one place and cascade to all future
        • Deal Activity Tracking - By Time

          Hello, I am trying to figure out a way to implement a time tracking ability within the CRP that will provide a line item on the final invoice in books. Would the Cases module be of good to use in this scenario? Want to integrate into Books as well. I
        • time tracking on zoho crm cases

          Is there a time tracking feature in zoho crm cases? I need calculate time spent in calls, tasks and events Thanks in Advance  
        • Time Card Tracking For Employees

          Does ZOHO have an add-on or app that my employees can use to clock in & out on a daily basis. In the past we had used a third party solution, but it was hard to use and pricey. We would really like to use your time tracking feature if you have one......if
        • Logging time within Time Tracking

          At the moment I use the call logging feature of CRM to log time spent on clients work. Its nice to be able to start, stop and pause the timer and record how many hours I need to bill the client. Any chance of implementing this in Zoho Invoice's time tracking feature The same interface as CRM would be great or a simple start/stop/pause/restart timer.
        • 3rd Party/Easy Time Tracking Integration with Zoho

          We are new customers using Zoho One with Zoho Project/CRM/Desk being the 3 big applications we will use. The majority of our work is done in the field and we need accurate and easy time tracking for our workers on mobile phones. aka TSheets type functionality. but tied to Zoho. Zoho is outstanding overall so I am surprised at how laborious, inefficient and disconnected time tracking is mobile devices. Adding time to a project task on a mobile phone can be a 10+ click task and that's not an exaggeration!
        • TrueSync for Windows 5.16+ breaks Excel save in "Shared with Me" (temp file writes fail) – workaround: pin 5.15.1

          Hi all, After TrueSync for Windows auto-updated past 5.15.1, some of our users can no longer save Excel files that live under "Shared with Me". We isolated it to a client-side regression and found a workaround. Sharing in case it saves someone a few hours
        • Introducing PRM: Build, manage, and scale your partner ecosystem

          Growing a partner ecosystem is a good problem to have. What starts as a handful of partners can quickly turn into a maze of spreadsheets, emails, and disconnected processes. More partners mean more opportunities, greater reach, and new ways to grow
        • Purchase Requisition in Zoho Books

          I want to understand if Zoho Books is having the following workflow: PR ( Purchase Requisition ) >> PO ( Purchase order) >>  GRN/SRN ( Goods/Services receipt note) >> Bill
        • Enhancement Request: Preserve Canceled Zoho Bookings Meetings in CRM

          I recently worked with Zoho Support on ticket 170383788 regarding what happens in Zoho CRM when an appointment is canceled in Zoho Bookings. Support confirmed that the current behavior is intentional: when a Bookings appointment is canceled, the corresponding
        • Introducing the Markdown editor in Zoho Learn

          Hello everyone, We're excited to announce the release of the Markdown editor in Zoho Learn. With Markdown editor, you can create and import articles as Markdown. You can write content using simple Markdown syntax and see how it looks with the built-in
        • When will Bigin's latest AI features be available in Europe?

          Hi, As I previously raised this question in the post “Introducing Bigin's latest AI features, built for the way you work!”, but received no response, I am bringing it up again here. It has now been five months since the announcement, and these AI features
        • Function #50: Send Mass emails to your customers

          Hello everyone, and welcome back to our series! We have reached a milestone of 50 Functions, which means that we have automated 50 different tasks in Zoho Books. Every Friday, we have shared a nifty function aimed at either automating a task or streamlining
        • Time tracking

          Hi there We are looking for a simple, intuitive but powerful time track application. We bill our clients by the time we spend, and so need to link Clients<>Projects<>Tasks or Activities<> Time spent. Is there an app in Zoho we could use? Many thanks.. Morri
        • Staff Tracking in

          Hi , I would like to see what activity my staff does over Zoho CRM and over Zoho Mail . I need to know which deals in CRM haven't been touched or had an activity on by a particular staff member . Basically need to establish what work.gets done by WFH
        • Zoho Projects connector with Zoho CRM (Related List module) features

          Hi community, I use Zoho Projects connected to Zoho CRM, where we associate Projects with Deals, clients, etc.. I am looking to change/edit the fields that are available in the integration. Currently it shows Project Status, Project Completion, Milestones,
        • Report: avg time to visit each lead

          We are on zoho one. our sales team visits leads using the ZohoCRM app. They track their hours using the zoho books timer. So the results in zoho books look like this: -total hours worked: 8 In ZohoCRM we have a custom date/time field in each lead record
        • Creating a Stop Start Timer for Custom Moduel

          Hello, I am trying to track Maintenance of internal Assets through Zoho CRM (I have tried the FSM, Projects, Inventory apps nothing is working the way I need it to). I have it all built in the CRM where I have internal work orders where i can keep track
        • Logging time to a Sales Lead in CRM

          Hi, Is there a way to log time against a Sales Lead / Deal in CRM before it is won and becomes a project? Our employees often do work for sales opportunities and need to log time against them at any point of the sales cycle, before it is won. Thanks, Atif
        • Hourly Billing in Zoho CRM Deals, Books, and Projects?

          We bill on an hourly basis and need that time added into a client's invoice in Books. A client might have multiple deals open with us that we are working on, and billing separately, and thus need separate invoices for each. The functionality of Projects
        • Time taken on a task

          I notice that you can record the length of a call, but not an event or a task. When a potential progresses from beginning to end it is just a series of tasks/calls/events in a process.  I have most of it automated depending on the type of sale and triggered by updating the sales cycle field. It follows that you should be able monitor the time of each of them so that you actually know how much time you spend on each potential. This gives an idea of profitability of each potential. I would think this
        • Timesheets from Deals

          Hi Guys, new Zoho One customer here with only a few employees. I run a small software company and currently our small number of employees are creating manual timesheets in excel. There is a column for a job number (that relates to a Zoho Deal) and they just put in the time taken to perform the work. As an example, they might spend 1 hour running some barcodes for a particular client (and deal). Then they may do a support all for another client and that takes 2 hours (This client would have a yearly
        • Timesheet option in zoho crm

          Recording a timesheet against a job is very crucial for every business because it will help them in billing the client accordingly and also it keeps a track on how much time a user is exactly taking in marking the job as cloed. Currently in crm there
        • Portal access is now available in the Zoho CRM mobile app

          Hello everyone, Zoho CRM Portals provide a secure space for sharing selected records with people outside your organization. These portal users can include customers, vendors, partners, or anyone who needs access to specific CRM data. Previously, portal
        • Field of Lookup - 5 Field Association Limit.

          This query relates to the post at: https://help.zoho.com/portal/en/community/topic/introducing-the-field-of-lookup-in-crm-public-early-access-2023 My simple (and common) scenario: I select an account / customer lookup and want their address pulled into
        • Zoho Forms API

          Is there any way to get all form entry list using API? Looking forward to hear from you
        • Multiple locations

          I have many customers (accounts) that have multiple locations, like bank branches. How can I manage them under one account?
        • Calendar won't load

          I run into this problem about once a week, where I try to open my Zoho calendar in a web browser, and it just gets stuck, waiting forever to load (see attached screenshot). I'm usually using Edge or Duck-Duck-Go browser. Sometimes it loads just fine,
        • Feature Request: Enhance Zoho Books Customer Approvals with WhatsApp, Multiple Approvers, Automated Reminders, and Workflow Automation

          Product: Zoho Books Module: Time Tracking → Customer Approvals Category: Feature Enhancement / Workflow Automation / Omnichannel Communication Description I would like to suggest several improvements to the Customer Approvals module in Zoho Books, particularly
        • Feature Request: Extend Zoho Books Customer Approvals API and MCP Support

          Product: Zoho Books Category: API Enhancement / OAuth Scopes / MCP Integration Feature: Customer Approvals (Timesheet Approvals) Description I would like to suggest an enhancement to the integration and automation capabilities of Zoho Books, specifically
        • Tip: #14 Save words and phrases in Writer for faster writing!

          As you start working with more documents everyday, you'd find yourself using certain words and phrases across documents quite often. In this week's tip, let's discuss two easy ways to train Writer to remember your commonly used words—equipping you to
        • Zoho ERP | Product updates | October 2026

          Hello users, A new month, a fresh set of updates in Zoho ERP. This month brings Netting, enhancements across our verticals, and more updates to help streamline your everyday work. Explore this month’s updates and see what’s new. Compliance with Revised
        • Zoho Forms - Feature Request - Embed iFrame or Dynaic URLs in Description fields

          Hi Zoho Forms team, I'm working with a client who uses Zoho Forms internally to collect information over the phone from potential work placement candidates. At the end of the form, the candidate needs to be booked in for an induction, which we've configured
        • BANK FEED - MAYBANK , provider from YODLEE IS NOT WORKING

          As per topic, the provider YODLEE is not working for the BANK FEED. It have been reported since 2023 Q3, and second report on 2023 Q4. now almost end of 2024 Q1, and coming to 2024 Q2. Malaysia Bank Maybank is NOT working. can anyone check on this issue?
        • Digest Octobre - Un résumé de ce qui s'est passé le mois dernier sur Community

          Bonjour chers utilisateurs, Bienvenue dans ce nouveau digest de la communauté Zoho France ! Vous y trouverez les discussions marquantes, les nouveautés produits, les conseils pratiques partagés et bien sûr les événements à venir. Le mois dernier, nous
        • Bank feeds - still a problem

          I'm really frustrated that the bank feeds only "sometimes" work.  I raised this problem once before and was advised that Zoho used Yodlee and feeds were only updated once a day.  That's fine but it only "sometimes" seems to work.  Eventually transactions appear but they sometimes seem to take days.  I know of other programs (Xero) that another business I am involved with uses Yodlee and they do not have this issue. My bank feeds are active,  I tried to manually refresh however Zoho tells me that
        • this is getting ridiculous

          My checking account bank feeds haven't worked since 6/4/21.  Multiple emails to Zoho since 6/10, and all they tell me is they have re-escalated my problem to their banking service provider team.  14 days and nothing is fixed. I'm just about ready to bail
        • No feedback from Zoho Books regarding Yodlee feeds for Investec

          I reported on 6 Feb 2025 that the Bank Feeds for Investec bank via Yodlee are not working. To date there has been no resolution. You are charging us for a suite of products where the functionality does not work. Please advise how you will refund me for
        • ongoing bank sync problems

          My bank feed broke May 14th 2021 Since then I just get an endless stream of we are working on it, "Kindly bear with us for sometime" from support Multiple times I have asked to speak to managers and half the time they don't call at all. If they do call
        • We must admit - Yodlee is an unreliable partner!

          Hello Zoho, Our Yes Bank account intergration is messed up since the beginning and the problem has not been addressed yet. With bad synchronization, poor categorization of transactions, duplicate/unknown copies of accounts, no support, geared at income/expenses,
        • Next Page