# Uploading data and the spreadsheet

> Open your data in the spreadsheet on the Analysis tab, have numbers with a decimal comma read correctly, and fix problems with Check & clean.

Grongy Guide · https://docs.grongy.co/uploading-data-spreadsheet/ · All pages: https://docs.grongy.co/llms.txt

You open your data in the spreadsheet on the document's **Analysis** tab; Grongy calculates statistics and charts from this sheet. It opens and saves .xlsx files, and you don't need to write any code.

*(Screenshot: The spreadsheet on the Analysis tab: a ribbon of tabs, the formula bar and sample data for 120 participants)*

The ribbon at the top has these tabs: **Home, Insert, Page layout, Formulas, Data, Statistics, Charts, Review, View, Help**. Each sheet tab at the bottom is a separate dataset. The data in the screenshot is available with English column names as [sample-data.csv](https://docs.grongy.co/indir/sample-data.csv); the [Sample files](https://docs.grongy.co/sample-files/) page explains its columns.

## Where the Analysis tab is

The **Analysis** tab sits on the left edge of the document, marked BETA. It appears only for document types that can have data of their own: **Thesis / dissertation**, **Research paper**, **Case study** and **Report**.

The tab opens on the chat: drop your file in the box and write what you want done. Tests and charts run inside the message, and changes such as a new column or a clean-up go into the table and can be undone in one click.

The buttons at the top right of the tab switch the view: **Chat**, **Spreadsheet** to work by hand, **Qualitative** for interview transcripts. If you pick the spreadsheet, the tab opens there next time. The [Qualitative analysis](https://docs.grongy.co/qualitative-analysis/) page covers the qualitative side.

The **Upload data** and **Check & clean** buttons on the editor's **Analysis** ribbon also bring you here. In a document without an Analysis tab, such as an essay, the same buttons open a small data panel beside the page.

## Opening a file

1. Open the **Analysis** tab, with **Spreadsheet** selected.
2. Switch to the **Data** tab on the ribbon and click **Open a file** in the **Get data** group.
3. Choose your file: .csv, .tsv, .txt, .xlsx, .xls, .ods (LibreOffice), .sav, .zsav or .por (SPSS), .dta (Stata), or .sas7bdat or .xpt (SAS). Grongy reads the file in your browser.
4. Each sheet in the workbook opens as its own tab at the bottom. Each tab is a separate dataset, and Grongy calculates statistics from whichever tab is selected.

*(Screenshot: The Data ribbon: Open a file, New sheet, sort and filter, Data tools)*

You can also type data straight into the cells or paste it in from elsewhere. The **+** button at the bottom opens an empty **New sheet**. With a very large file, Grongy reads only the first 20,000 rows and tells you so in a note.

> **Tip:** If you are signed in, your datasets also sync to your account; when you open the same document on another device, your data is there too.

## Numbers with a decimal comma

A decimal comma, as Turkish uses it, causes no trouble: Grongy reads `3,5` as 3.5 and `1.250,75` as 1250.75. For a value like `1.250`, which can be read two ways, it decides by looking at the rest of the column. Every calculation uses the same reading; a cell never counts as 3.5 in one place and 35 in another.

With the interface in Turkish, you separate a formula's arguments with `;` and use Turkish names such as `TOPLA` (SUM), `ORTALAMA` (AVERAGE) and `EĞER` (IF). English names work too.

## Check & clean

Before you start the analysis, find and fix the problems in your data.

1. On the **Data** tab, click **Check & clean** in the **Prepare** group.
2. The **What the data looks like** section lists the findings, such as duplicate rows, missing or outlying values, mixed decimal marks and inconsistently written labels. Grongy calculates these numbers from your file; it does not guess.
3. Fix a finding with one click, or get a **Suggested steps** list with **Ask the AI for advice**. Nothing is applied unless you tick it; you apply the steps you chose with **Apply selected**.
4. What you apply builds up in the **What was done** list. **Insert this into my methods section** writes these cleaning steps into your document.

*(Screenshot: What the data looks like: values outside the 1.5×IQR fences in two columns and the “Set these outliers to missing” fix)*

Your original file is kept as it was; **Undo all cleaning** returns everything to its first state.

## Your data is ready

When you open a file, a **Your data is ready** card appears on the **Statistics** tab. The card shows the number of rows and columns, how many numeric and grouping variables you have and, if there is one, a point you should check. Below it, the analyses that fit the structure of your columns are listed, each with a **Run it** button. The analyses are covered in detail on the [Statistics](https://docs.grongy.co/statistical-analyses/) page.

*(Screenshot: The Statistics tab: the Your data is ready card, suggested analyses and the analysis list)*

## Defining variables

On the **View** tab, switch to **Variable view**. Here you enter, for each column:

- a **Label**,
- the **Measure**: **Nominal**, **Ordinal** or **Scale**,
- **Value labels (1=Female; 2=Male)**,
- **Missing codes**, for example 99.

Codes you mark as missing do not enter calculations as numbers. Value labels appear in tables in place of the codes. The values in the data themselves do not change here.

*(Screenshot: Variable view: Label, Measure, Value labels and Missing codes for each column)*

## AI assistant

The **AI assistant** button at the bottom right of the sheet opens a chat. Ask for a change, a chart or an analysis in your own words, and the assistant does it right away. The AI only decides what to do; the sheet calculates the numbers. You undo a change you don't like with Ctrl+Z.

*(Screenshot: The AI assistant panel: suggested questions and the “Ask about this data…” box)*
