Data Cleaning preview
Pivot Table
Click here to start building a pivot table
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
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
Monochromatic
Custom
Location
Cell Reference:
Choose the data range for the table:
Choose the location for the table:
Range Size
Fill Color
Text Color
PROJECT STATUS
BUG STATUS
REVIEW
Priority
DECISION
BOOLEAN
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
Contextual side panels for uninterrupted work. - Learn More
Zia—artificial intelligence to analyze data with appropriate insights. - Learn More
Data cleaning tool to remove duplicate rows and data inconsistencies. - Learn More
Custom functions for your every need, powered by Deluge. - Learn More
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
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...
