How to Enter Data Directly into Zoho Analytics Tables

Entering Data Directly into Zoho Analytics

Zoho Analytics includes a spreadsheet-style interface that lets you type data directly into a table without needing to prepare or upload a file first. This is ideal for small datasets, testing, or exploratory analysis where you want to get started immediately.

Creating a New Workspace with Direct Data Entry

  1. Log in and go to Import Your Data. From the Zoho Analytics home page, select Import Your Data.
  2. Choose Enter Data Right Away. Select this option from the available import methods.
  3. Name your workspace. Enter a unique workspace name in the dialogue that appears, then click Create. A blank editable table opens automatically.

Entering Data

The table opens with default column labels (Column1, Column2, etc.). Click any cell and begin typing to enter values. You can:

  • Double-click a column header to rename it to a meaningful name (column names must be unique within the table).
  • Add more rows and columns as needed while entering data.
  • Use the Tab key or arrow keys to navigate between cells.

Saving the Table

Once you have entered your data, click Save and provide a table name (required) and an optional description. Zoho Analytics will automatically detect appropriate data types for each column based on the values you entered.

Adjusting Data Types

If the automatically detected data type for a column is not correct, right-click the column header and select Change Data Type. Choose the appropriate type from the list that appears.

Adding Tables to an Existing Workspace

To add a manually entered table to a workspace that already exists, navigate to the workspace and go to Create > New Table / Import Data, then select Enter Data Right Away. Follow the same steps as above to enter, name, and save the table.

Need help? 1 Cloud Consultants can help you get started with Zoho Analytics, from setting up your first workspace to building dashboards from your data. Book a discovery call with 1 Cloud Consultants.