Name:
Save in folder:  
Description:
(Less than 250 characters)
 
  OK  
  Cancel  
   Create New Table :
     
Import from .XLS, .CSV, .HTML... files:
Create a table by importing data directly from Excel ,CSV and HTML files.
  Using Design View:
Create a table by specifying  the column names, data types and column properties
     
Enter Data Right Away:
Create a table by directly entering data. Zoho Reports will automatically create a table based on the data entered.
   Query Table:
Create a table using a SELECT Query(SQL) in any database dialect.
     
   Create New View  
     
Tabular View :
Tabular View provides you a way to list your values in a simple tabular format.
   Chart View:
Chart View allows you to create a graphical view using different types of charts.
     
Pivot View (Matrix View) :
Pivot View allows you to view data summarized in a grid both in horizontal and vertical columns.
   Summary View:
Summary View allows you to view data with grouping and subtotals.
 
Auto Generate Reports:
 
Similar to Another Table :
Will generate reports for the selected table, similar to what is available for another table in this database.
   With Auto Analysis :
Will auto generate reports for the selected table, by analyzing & applying advanced rules on the data in the table.
     

 
 
 Edit Design:   *
Save Refresh Delete Row(s)
 
Copy and Paste your CSV, TSV ... file content here!
(Supported file formats: .CSV, .TSV and other text files)

Note:
  • For other file formats, Choose the corresponding 'File Type' option above.
  • For large size CSV or TSV or Text file, we recommend to zip it and upload.
  • Zipped .CSV,.TSV or Text file can contain only one file in it.
(URL should provide a .CSV or .TSV file. It could also be a zipped file containing a .CSV or .TSV file.)

Click on the link below to import sample data(CSV) from the website
Copy and Paste your MS Excel (XLS), Open Office (SXC) ... file content here!
(Only .XLS files are supported)

Note:
  • For other file formats, Choose the corresponding 'File Type' option above.
  • For large size XLS file, we recommend to zip it and upload.
  • Zipped .XLS file can contain only one file in it.
(URL should provide a .XLS file. It could also be a zipped file containing a single .XLS file.)

Click on the link below to import sample data(XLS) from the website
Copy and Paste HTML File contents which contains atleast one HTML table in it
(Only HTML files are supported. It should contain atleast one HTML table in it)

Note:
  • For other file formats, Choose the corresponding 'File Type' option above.
  • For large size HTML file, we recommend to zip it and upload.
  • Zipped .HTML file can contain only one file in it.
(The URL should contain alteast one HTML table in it.)

Click on the link below to import sample HTML data from the website

File Name
  :
Export the   : 
Export Settings:
Column Seperator :   Include column headers
Record Seperator : Include hidden columns
Text Qualifier : Include record ID
 
 
To measure the input field width
To measure the cell height
 
  Rows: 0        
   
More Data Present - Goto First | Scroll Up
More Data Present - Goto Last | Scroll Down
Press "Page Down" or Click the page scroll to load rows Incrementally ->
 

  OK  
  Cancel  
 
 
Summary Functions
Sum
Average
Count Records
Min
Max
Standard Deviation
Variance
   Add Custom Formula  
Formula Column Name:   
 
Formula:  Allowed Operators:   +  -  *  /  ()
Click to Insert Functions: Click to Insert Columns:
Absolute Month Date Function
Absolute Quarter Date Function
Add Date Date Function
Current Date Date Function
Date Diff Date Function
Day Date Function
Day Of Week Date Function
Day Of Year Date Function
Hour Date Function
Minute Date Function
Month Date Function
Month Num Date Function
Quarter Date Function
Second Date Function
Week Day Date Function
Year Date Function
Abs Numeric Function
Acos Numeric Function
Asin Numeric Function
Atan Numeric Function
Atan2 Numeric Function
Ceil Numeric Function
Cos Numeric Function
Cot Numeric Function
Degrees Numeric Function
Exp Numeric Function
Floor Numeric Function
Greatest Numeric Function
Least Numeric Function
Ln Numeric Function
Log10 Numeric Function
Log2 Numeric Function
Mod Numeric Function
Pi Numeric Function
Power Numeric Function
Random Numeric Function
Radians Numeric Function
Round Numeric Function
Sign Numeric Function
Sin Numeric Function
Square Numeric Function
Square Root Numeric Function
Tan Numeric Function
Concat String Function
Insert String Function
Index Of String Function
Left String Function
Length String Function
Lowercase String Function
Locate String Function
Lpad String Function
Ltrim String Function
Replace String Function
Reverse String Function
Right String Function
Rpad String Function
Rtrim String Function
Strcmp String Function
Substring String Function
Trim String Function
Uppercase String Function
Ifnull General Function
 
 
  
 
Sum
Average
Count Records
Min
Max
Standard Deviation
Variance
Count Records
  Loading . . .
 
 
 
  Loading . . .
Column Name:
Datatype:
Alignment:
Currency Symbol:
Decimal places:
Negative Number Display:
Show 1000 Separator
Column Name:
Datatype:
Alignment:
Column Name:
Datatype:
Alignment:
Show 1000 Separator
Column Name:
Datatype:
Alignment:
Decimal places:
Show 1000 Separator
Column Name:
Datatype:
Alignment:
Enter your date format if it is not listed above:(Help)
Column Name:
Datatype:
Alignment:
Decimal places:
Show 1000 Separator Show Percentage Symbol
SignUp to create your own reports on this database
 
Summer Olympics Summer Olympics
Alert Message Here
  Loading . . .
New
Create a new table/ tabular view/ chart view/
pivot view/ summary view/ query table
Save(Ctrl + S)
Save the table
Refresh
Refresh the table and fetch the latest
from the server
Edit Table Design
Edit the structure(column name, data type, and
other column properties) of the table
Import
Import data into this table from
a CSV/XLS/TSV/HTML file
Export
Export data from this table as a CSV / PDF file
Export as CSV
Export data from this table as a CSV file
Export as PDF (Print ready)
Export the data from this table as a Printer friendly PDF file
Share
Share this view(table/report) to your friend(s) or colleague(s)
to view/edit the data
Publish
Embed this table into your website/blog
Save(Ctrl + S)
Save the design changes
Refresh
Refresh the design
Delete Row(s)(Del)
Delete the column corresponding to the row selected
sort
Sort the selected column in ascending/
descending order
Filter
Filter the data in the table providing the necessary criteria.
Click dropdown icon to view the saved filter(s)
Show/Hide/Reorder Column(s)
Show or hide the column in the view.
You could also reorder the columns
in the view with this option.
Freeze
Freeze the columns selected. All the columns from the start
till the selected one will be frozen(non scrollable).
Add Row/Column
Add a new row/ new column/ derived column
using a formula
Delete Row/Column
Delete selected row(s)/column(s)
New
Create a new table/ tabular view/ chart view/
pivot view/ summary view/ query table
Save(Ctrl + S)
Save the view
Refresh
Refresh the view and fetch the latest
from the server
Export
Export the data from this view as a CSV / PDF file
Share
Share this view to your friend(s) or colleague(s)
to view/edit the data
Publish
Embed this view into your website/blog
Sort
Sort the selected column in ascending/
descending order
Group
Group the selected column based on
the values present
Show/Hide/Reorder Column(s)
Show or hide the column in the view.
You could also reorder the columns
in the view with this option.
Freeze
Freeze the columns selected. All the columns from the start
till the selected one will be frozen(non scrollable).
Summary
Apply Summary Function(s) on the column(s) selected
Add
Add a dervied column based on a formula
New
Create a new table/ tabular view/ chart view/
pivot view/ summary view/ query table
Save
Save the view
Refresh
Refresh the view and fetch the latest
from the server
View Mode
Switch to view mode(display mode)
Edit Design
Switch to 'Edit Design' where you
can edit the view design
Export
Export this view as a CSV,PDF or Image file
Export
Export data from this view as a CSV/PDF file
Export as CSV
Export data from this view as a CSV file
Export as PDF (Print ready)
Export this view as a Printer friendly PDF file
Export as Image
Export this view as an Image
Export Multiple Views (Print ready)
Export multiple views in a single PDF file
Share
Share this view to your friend(s) or colleague(s)
to view the data
Publish
Embed this view into your website/blog
Settings
Edit the settings of the chart (display name,
description, axis labels etc.,)
Pie Chart
Change the chart type to Pie chart
Bar Chart
Change the chart type to Bar chart
Stacked Bar
Change the chart type to Stacked Bar chart
Scatter Chart
Change the chart type to Scatter plot
Line Chart
Change the chart type to Line chart
Table Chart
Change the chart type to Table chart
Other Charts
Change to other chart types
Split Axis
Split the combined Y axes into separate axes.
Each Y column in the chart will have a separate axis
Merge Axis
Merge multiple Y axis into one
View Underlying Data
View the underlying data for which
the chart is displayed.
Refresh
Refresh the view and fetch the latest
from the server
Setting
Edit the settings of the pivot (display name,
description)
Underlying Data
View the underlying data for which
the pivot is displayed.
Refresh
Refresh the view and fetch the latest
from the server
Setting
Edit the settings of the summary view (display name,
description)
Underlying Data
View the underlying data for which
the summary view is displayed.
New Table
Create a new table
New Tabular View
Create a new tabular view for this table
New Chart View
Create a new chart view for this table
New Pivot View
Create a new pivot view for this table
New Summary View
Create a new summary view for this table
With Auto Analysis
Auto Generates reports for this table, by analyzing & applying advanced rules on the data in the table.
From Templates
Generates reports for the selected table using the templates available in this database.
Similar to Another Table
Generates reports for the selected table, similar to what is available for another table in this database.
New Query Table
Create a new query table using a SQL Select query
Make As Template
Make this view as template for Auto Analysis
Remove As Template
Remove this view as template, If you don't want Auto Analysis for this view
Save(Ctrl + S)
Save this view
Save As
Save a copy of this view
Save As
Save a copy of this view
Delete Row(s)(Del)
Delete this row from the table
Delete Column(s)
Delete this column from the table
Delete All Rows
Delete all the rows in this table
Group-Block
Group the unique values in the column
into columnar blocks
Group-Sectional
Group the unique values in this column as sections.
Data rows corresponding to each unique value will be
grouped under each section
Ungroup
Ungroup the selected column
Ungroup All
Remove all groups applied in this view
Sort Ascending
Sort values in the column from Smallest to Largest
Sort Descending
Sort values in the column from Largest to Smallest
Remove Sorting
Remove sorting for this column
New
Create a new table/ tabular view/ chart view/
pivot view/ summary view/ query table
Save
Save the Query Table. Click 'View Mode' to view the
complete data (result set) of this query
Refresh
Click 'Refresh' to (re)execute the query and
fetch the latest data from the corresponding
tables used in the query
View Mode
Click 'View Mode' to view the complete data
(result set) of this query
Edit Design
Click 'Edit Design' to view and edit the SQL Select query
used by this Query table
Export
Export data from this table as a CSV / PDF file
Share
Share this table to your friend(s) or colleague(s)
to view the data
Publish
Embed this table into your website/blog
Sort
Sort the selected column in ascending/
descending order
Show/Hide/Reorder Column(s)
Show or hide the column in the view.
You could also reorder the columns
in the view with this option.
Freeze
Freeze the columns selected. All the columns from the start
till the selected one will be frozen(non scrollable).
Add Row
Add a new row to this table
Add Column
Add a new column to this table
Add Lookup Column
Add a lookup column to this table
Add Formula Column
Add a new column based on a formula
Embed in Website/blog
Embed this table/view into your website/blog
URL for this view
Get a unique URL to access this view/table
alone from your browser
Public Settings For DB
Settings to make the database and the views
in it publicly accessible
Share this view
Share this view(table/report) to users
Share this database
Share this database to users
or group members
Edit Shared Details of this View
Edit shared details of this view(table/report)
Edit Shared Details by User
Edit shared details by users
Add/Edit Group Members
Add or Edit members in the database group
Share to Group
Share this view(table/report) to the database group members
Remove Group Sharing
Remove this view from being shared to the group
Go to First Record(Ctrl + Home)
Go to first record of this view
Go to Previous Page(Page Up)
Go to previous page of this view
Go to Next Page(Page Dn)
Go to next page of this view
Go to Last Record(Ctrl + End)
Go to last record of this view
Save
Save the table
Refresh
Refresh the table and fetch the latest
from the server
Add Row
Add a new row to this table
Delete Row
Delete this row from the table
Import into this table
Import data into this table from
CSV/TSV/XLS/HTML file
Import into a new table
Import data into a new table from
CSV/TSV/XLS/HTML file
Refetch/Schedule Import
Setup/Modify scheduled import (from URL) for this table.
Also you could (Re)Fetch data now into this table from the specified URL.
Last Import Details
View the status of the last data import
done for this table.
Save As
Save a copy of this view
Unfreeze
Unfreeze the frozen area
Date Format
Click here to choose date format from the pre-defined list
Date Format
If you are not sure of the format string, refer here for help documentation.
(It will open in a new tab/window)
Date field separators
You don't need to specify the date separators like -, ., /
Wed, 15-Jan-2006 is same as Wed 15 Jan 2006
Refer help for more information
Actual Values
All values in the column are listed.
(Each value is considered to be a individual category).
Count
Number of values in the column.
Year
All distinct year values present in the column.
E.g., 2003, 2004
Quarter
All distinct quarter values present in the column.
E.g., Q1 2003, Q2 2004
Month & Year
All distinct month values present in the column.
E.g., March 2004, March 2005.
Week
All distinct week values present in the column.
E.g., W1 2003, W2 2004
Full Date
All distinct dates present in the column Date.
E.g., 1/1/2000, 31/12/2000
Date & Time
All distinct date and time pairs present in the column

E.g., 01 Jan 2000 00:00:07 hrs
Actual Values
Filter By Absolute period like
Exact year(2004, 2005),
Exact Month and Year(Mar 2004, Apr 2005),
Between two dates(7th Mar 2004 to 16th Mar 2004) etc.,
Seasonal
Filter By Seasonal Period like
Months(March, April)
Week Day(Saturday, Sunday)etc.,
Relative
Filter By Relative Period like
Last 3 Months, Last 5 Days, Last Week etc.,
Quarter
Helps identifying seasonal trend based on
Quarter across all years.
E.g., Q1, Q2 etc.,
Month
Helps identifying seasonal trend based on
months across all years.
E.g., January, February etc.,
Week
Helps identifying seasonal trend based on
week across all years.
E.g., Week 1 , Week 2 etc.,
Week Day
Helps identifying seasonal trend based on
Week Day across all dates.
E.g., Sunday, Monday, Tuesday etc.,
Day of Month
Helps identifying seasonal trend based on
Day of Month (1 ,2... 31) across all dates.
E.g., 1, 2, ... 31 of all months
Month
Helps identifying trend across hours in a day.
E.g., 0 to 23 hrs
Sum
Sum of the values in the column.
Maximum
Maximum value present in the column
Minimum
Minimum value present in the column.
Average
Average value of the column.
Standard Deviation
Standard Deviation of the column.
Count
Number of values in the column.
Measure (/continous)
Treat as a continuous number.
* The axis is divided into equal intervals on numerical scale.
Actual Values
Shows all the values as it is in the source table to the matched criteria.
Dimension (/Categorize).
Treat values as individual categorical items.
* All values will be plotted on the axis
with equal spacing irrespective of their numerical difference.
Range
Group values into ranges.
E.g., Profit between 10 Million to 20 Million
Column Properties
Rename the column/edit the data type of the column
and its formatting options
Change Datatype
Change the datatype of a column
Rename Column
Rename the column name of a column
Column Format
Change the format of the column
viz Alignment, Decimal places, Date format, etc
New
Create a new table/ report/ folder
New Report
Create a new report
New Folder
Create a new folder
Delete
Delete selected views
Rename
Rename selected view
Share
Share the selected view(s) to your friend(s) or colleague(s)
to view/edit the data
Share View(s) to new users
Share the selected view(s) to users
Share Views to Database Group
Share the selected view(s) to database group
Edit Shared Details by View
Edit shared details of the view selected
Edit Shared Details by Users
Edit shared details of users in this database
Remove Group Sharing
Remove the selected view(s) from being shared to the database group
Change Ownership to Database Owner
Change the ownership of the selected view(s) to database owner
Find and Replace
Find And Replace values in the selected column.
More Actions
Find And Replace, Show/Hide, Reorder and Freeze options
  New Table  
  New Report  
View by:
 
 
 
 Table Name *
Save Refresh Switch To Data Sheet View
Refresh Sort  Filter  More Actions 
       
Save Refresh Sort  Filter  Column Properties  More Actions 
Refresh Sort  Filter  More Actions 
Refresh View Mode Export Publish 
        Loading . . .       
aa
Sort Ascending
Sort Descending
Remove Sorting
Sort
Sort Ascending
Sort Descending
Remove Sorting
View Underlying Data
Sort Ascending
Sort Descending
Remove Sorting
View Underlying Data
        
Tables & Reports