Loading...
...
Custom
Recommendations
X Axis
Y Axis
Plotline Name
Plotline Value
Filter
Data Cleaning
Data Quality
Inconsistent Data
Resolve mismatches in spelling, capitalization, and spacing for consistency.
Missing Value(s)
Fill missing values in cells and avoid errors during analysis.
Duplicate Record(s)
Highlight or remove duplicate entries in your data.
Spelling Errors
Let us handle your spell errors.
Formula Errors
Let us handle your formula errors.
Column(s) with Multiple Data Types
Multiple data types in a column could lead to error during analysis.
Data Cleaning
Data Quality
Inconsistent Data
Resolve mismatches in spelling, capitalization, and spacing for consistency.
Missing Value(s)
Fill missing values in cells and avoid errors during analysis.
Duplicate Record(s)
Highlight or remove duplicate entries in your data.
Column(s) with Multiple Data Types
Multiple data types in a column could lead to error during analysis.
Spelling Errors
Let us handle your spell errors.
Formula Errors
Let us handle your formula errors.
Classic
Classic formats can be used to highlight data based on a single criterion within a single interval.
Color Scale
Color Scales can be used to visualize the gradual changes in a data trend using cell fill colors.
Icon Set
Icon Sets can be used to distinguish the data values in a range using contextual icons.
Data Bar
Data Bars can be used to visually compare values in a given range using bars.
Picklist
Create quick dropdown lists using values, from a column with customized formats.
Checkbox
Add checkbox to your spreadsheet and make it interactive. All cells with values will be replaced with a ticked checkbox.
Insights
Options
From :
To :
All Workflows
Is your word flagged during spell check? Add them to your personal dictionary to avoid them being misspelled
Language
Add Word
Custom List
Spell Check Options
Column Name
Match Type
Options
Actions
2
View Rules for:
Minimum
Midpoint
Maximum
Options
Options
Display Icon
Types
Rules and >
Values
Display Icon
Sheet1: A2
Rule type
Minimum
Maximum
Fills
Positive
Negative
Borders
Positive
Negative
Axis color
Options
Name
Scope
Scope refers to the location within which the name is recognized.
Refers To
Comment
Monochromatic
Custom
Location
Cell Reference:
Choose the data range for the table:
Choose the location for the table:
Range Size
Fill Color
Text Color
List
PROJECT STATUS
BUG STATUS
REVIEW
Priority
DECISION
BOOLEAN
View Rules for:
Color options
Options
Arrange items in the cell
Commonly used
People
Nature
Objects
Places
Symbols
Public Options
Embed Code
Removing the public mode for this spreadsheet will make it inaccessible wherever it is embedded (i.e., websites and blogs).
Publish
Public Options
Email Published URL
Published
Data Range
Combine Range
Sort By
Order
CHART TYPE
Chart Type
Series In
Label
Position
Format
Animation Duration
Format
Display By
Decimal Places
Handle Blank Cells
Position
Format
Format
Format
Axis
Legend
Color Schemes
Font
Background Color
Border Color
Transparency
Others
Format
Slant Label
Stagger Lines
Format
Selected Axis
Format
Base Value
Gridlines
Line Type
Line Color
Line Type
Line Color
Value
Series Color
Degree
Period
Apply To
Series Color
Chart Type
Line Type
Transparency
Outliers Color
Mean Color
Whiskers Color
Median Color
Area Transparency
Border Color
Starting Angle of first slice
Markers
Shape
Size
Fill Color
Border Color
Start Angle
End Angle
Create checkbox tracker in your spreadsheet
Spreadsheets can be used to handle a variety of tasks, but ever tried using checkboxes to track the progress of your action items dynamically?...
6 Trendlines and when to use them in your spreadsheet data?
Charts are a great tool for visualizing and interpreting large chunks of data in spreadsheets...
Easily share spreadsheets
with non-Zoho account users
With efficient, collaboration-friendly options, Zoho Sheet is a popular choice among users. Sheet's external share links help you collaborate...
Ask Zia your data-related questions and get powerful insights
Zoho Sheet provides a variety of tools and functionalities to help you analyze your data from end to end...
Stop guessing and start estimating with Zoho Sheet's Goal Seek
Goal Seek is an ideal spreadsheet tool for devising estimates, as it helps you retrieve your desired...
Crunch your spreadsheet data better with 7 new Zoho Sheet functions
Spreadsheet functions help you quickly compute, analyze, and visualize data. Zoho Sheet...
5 Zoho Sheet features that make collaboration easy
The world has indeed become small, with teams and organizations now spread across the globe. So why should data be kept in offline...
3 important chart customizations to make them more readable
Charts are great tools for representing data. Visualizing can give you a new perspective, and...
What is Version History and how is it useful? | Revise, revisit, and restore.
Online spreadsheets spare you the hassle of creating a new spreadsheet file each time you edit your data...
Building spreadsheet dashboards 101
If skimming is the new reading, then dashboards are the new data set. People want to zero in on small slices of information, rather than...
3 helpful ways to use data validation in your spreadsheet
Data validation in spreadsheets makes data entry processes more efficient, while helping reduce inconsistencies and errors in your...
5 common spreadsheet errors and how to solve them
Functions can help you automate your calculations and pull important insights from your data set. However, if something goes...
Using RAND functions to generate random data sets
Have you ever spent hours working on a sample data record for a demonstration? We're here to show you how to do it in less time...
Four things you can do with Conditional Formatting
Conditional formatting helps you highlight and visualize data in your spreadsheet based on provided rules. Zoho Sheet offers three...
What are aggregated charts? How do they improve visualizations?
Charts, as we know, are vital data visualization tools. Pivot tables, on the other hand, are useful for giving...
How naming ranges, constants, formula can simplify things for you
Defining names for ranges, constant values and formulas helps make your spreadsheets clear, eliminates...
Five important statistical functions and when to use them
The sample mean is probably the easiest piece of information one can extract from a data set. To calculate sample mean in Zoho Sheet...
Owner
Rename
Location
Browse (or) Drop Your File
Supported file formats jpeg, png, tiff, bmp, webp, and hiec
Maximum file size allowed is 10MB.
Choose Format
Set Password
Confirm Password
Enter Password:
This chart has been published.
Default width: 100 Pixels
Minimum
Midpoint
Maximum
Options
Preview
Description:
(Optional)Description:
(Optional)Are you sure you want to delete this version?
Add New
(Hint: dd/mm/yy hh:mm - 29/12/2010 19:07)
Manage Formats
Contextual Help
Date:
d
dddd
m
mmmm
Y
- Day
- Display the days' full names
- Month
- Display the months' full names
- Year
Time:
h
m
s
- Hours
- Minutes
- Seconds
Number & Text:
#
@
- Number
- Text
Click here for more format codes
Publishing this form will allow anyone to view and access the form without authentication.
Choose how you would like to receive your email notifications:
Send notifications
Comments in this document
Edits in this document
Attach as:
To:
Subject:
Message:
Options
Browse (or) Drop Your File
Supported file formats are .xls, .xlsx, .xlsm, .xltx, .sxc, .ods, .csv, .tsv and .txt.
Import Options
Select URL Type:
Note:Once cells are locked, they remain locked for new shared users.
Owner
Type
Scope
To assign a new macro: Write Macro | Record Macro
You have no macros in this spreadsheet.
You have changed lock settings. Please click Save to apply.
Owner
Defined Names
Connect and analyze your Zoho CRM data.
Connect and analyze your Zoho Analytics data.
Connect and analyze your Zoho Creator data.
Connect and analyze your Zoho Books data.
Connect and analyze your Zoho Invoice data.
Connect and analyze your Zoho Projects data.
Connect and analyze your Zoho BugTracker data.
Connect and analyze your Zoho Expense data.
Connect and analyze your Zoho Inventory data.
Connect and analyze your Zoho Desk data.
Connect and analyze your Zoho Campaigns data.
Connect and analyze your Zoho Forms data.
Connect and analyze your Zoho Recruit data.
Connect and analyze your Zoho Sprints data.
Connect and analyze your Bigin data.
Connect and analyze your Zoho Billing data.
Connect and analyze your Zoho Survey data.
Connect and analyze your Zoho SalesIQ data.
Connect and analyze your Zoho Commerce data.
Connect and analyze your Zoho BackStage data.
Select URL Type
Choose where to place the Linked Data:
Re-Authenticate
Drag and drop the required fields.
Filter
Row
Column
Data
Enter New Name:
Version Description
Make sure to give it a suitable name for later reference!
Are you sure want to revert to the selected version?
Default height: 19 Pixels
Template Name:
Merge Template Name:
Location
Source:
Destination:
Note:
Please select a destination range that is equal to the source range.
Linked Spreadsheets
Source:
Note:The headers must remain in the same row and resulting table range must overlap the original table range.
Options
Styles
Custom
Subject to constraints
Solver has found a solution.
Optimized Value:
Delete this comment?
Note: This will permanently delete all comments, including drafts.
added a comment
...
resolved a comment
reopened a comment
replied
...
Options
Options
Filter
Column
Row
Data
Options
Add
Edit
Column
Selection
Sort
Connections
Edit
Styles
Layout
Title
Column Layout
Width
Height
Width
Height
Column
Time level
Connections
Edit
Current Version
Version Description:
Make sure to give it a suitable name for later reference!
Data Source
Merge Action
to view logs of your merge template activity.
Browse (or) Drop Your File
Supported file formats are .xlsx, .csv, and .tsv.
Maximum file size allowed is 10MB.
S. No. | Spreadsheet Name | Status |
---|---|---|
Job ID:
Assigned by:
Organization plan
Credits used so far
Remaining this month
Available limit per category today
Merge & email as attachment:
Merge & save as file(s):
Spreadsheet Name:
Location
Font
Themes
Default
Iterative Preferences
Lookup Preference
List Options
Orientation
{GroupLabel}
Templates shared across your organization will appear here. Currently there are no templates shared.
Delimiters
Options
Preview
Options
Actions
Please enter the value for the input arguments:
Description:
(Optional)Result Type:*
Arguments:
Error at line number: 1
To assign a new custom function:Write Custom Function
You have no custom function in this spreadsheet.
REPLACED
ADDED
DELETED
Manage permission
Santhosh
santhoshkumar.h@zohocorp.com
Rajin
Rajin.rajan@zohocorp.com
Untitled Spreadhseet
Created
Last Modified
Access Type
Shared with
Permalink
Choose Format
Enter Password
Connect and analyze your Zoho CRM data.
Connect and analyze your Zoho Analytics data.
Connect and analyze your Zoho Creator data.
Connect and analyze your Zoho Books data.
Connect and analyze your Zoho Invoice data.
Connect and analyze your Zoho Projects data.
Connect and analyze your Zoho BugTracker data.
Connect and analyze your Zoho Expense data.
Connect and analyze your Zoho Inventory data.
Connect and analyze your Zoho Desk data.
Connect and analyze your Zoho Campaigns data.
Connect and analyze your Zoho Forms data.
Connect and analyze your Zoho Recruit data.
Connect and analyze your Zoho Sprints data.
Connect and analyze your Bigin data.
Connect and analyze your Zoho Billing data.
Connect and analyze your Zoho Survey data.
Connect and analyze your Zoho SalesIQ data.
Connect and analyze your Zoho Commerce data.
Connect and analyze your Zoho BackStage data.
Select URL Type
Choose where to place the Linked Data:
Location
AI Bot
Ask and get answers to all your questions.
Formula Assistance
Generate formulas for the desired use cases, or ask Zia to explain a given formula.
VBA Macro Assistance
Generate VBA macro codes for desired use cases, or ask Zia to explain a given VBA code.
Table Generation
Create tables with sample data sets or real-world data instantly.
This is an external service based out of the USA.
{0} utilizes OpenAI's ChatGPT API, subject to OpenAI's Terms of Use. Only the data that is entered as a prompt in Ask Zia will be accessible to OpenAI.
Note: Please exercise discretion when using this service if your query to OpenAI contains confidential or personal information.
By clicking "I Understand", you accept that you have read and agree to the terms and conditions of this integration. For more information, refer to OpenAI's Terms of Use.