---
title: Data Sheet - Introduction
description: Entering and viewing detailed data
---

[Skip to content](https://community.budgyt.com/trials/knowledge/data-sheet-introduction#main-content)

[More support](https://community.budgyt.com/trials/kb-tickets/new) [Customer Portal](https://community.budgyt.com/customer-portal)

![](https://community.budgyt.com/hubfs/budgyt%20logo%20stacked%20white.svg)

Open main navigation

Close main navigation

- [More support](https://community.budgyt.com/trials/kb-tickets/new)
- [Customer Portal](https://community.budgyt.com/customer-portal)

 Helping you with what's needed next

- There are no suggestions because the search field is empty.

1. [Knowledge-Base | Trials](https://community.budgyt.com/trials)
2. [Regular Users](https://community.budgyt.com/trials/regular-users)
3. [Data Sheet](https://community.budgyt.com/trials/regular-users#data-sheet)

# Data Sheet - Introduction

## Entering and viewing detailed data

The **Data Sheet** is where you can control all the numbers in your budget.  All data entry occurs on the data sheet.  

The Data sheet allows you to see **Group**, **Category,** or **Sub-Category** level data across one or more of your departments.  This page has many features that are very powerful and would take days and hours to recreate in Excel.  

- **Scenarios** - at the top of the page we see the Scenario and Year in Red Font with a pencil icon next to each.  You can switch between any active budget or year here.
- **Groups/Categories** - At the top left we have the Group/Category drop down menu where all categories and groups are organized by the COA hierarchy set in Budgyt. Non-Financial categories are also included in this list. Selecting a Category or Group (name in bold) will display that category or group of categories.
- **Departments** - the drop down at the top right allows you to choose which of your departments you wish to display.
- **Refresh** - hit the refresh button (top right) after changing the Department drop down to populate the data sheet with the new information.
- **Excel** (top right) - the excel icon allows you to export data sheet information to Excel for further analysis. The export contains the Code for the categories exported and can be a useful shortcut to help import data. To learn more about importing data click **[here](https://community.budgyt.com/knowledge/importing-data)**.
- **$/% buttons** (top right) - by default the data sheet shows information in $, clicking the % button converts all data to a percentage of net sales of the department to which that data belongs. The $ button returns the data to $.
- **Editing** - to learn how to enter data in the data sheet page click [**here**](https://community.budgyt.com/knowledge/data-sheet-editing)

![](https://community.budgyt.com/hubfs/Knowledge%20Base%20Import/budgyt_zendesk_comhcarticle_attachments115004597251datasheet_simple-4-4-1.png)

- [Admins](https://community.budgyt.com/trials/admins#main-content)

    - [Multi-Currency](https://community.budgyt.com/trials/admins#multi-currency)
    - [Scenarios (Budgets)](https://community.budgyt.com/trials/admins#scenarios-budgets)
    - [Settings & Configuration](https://community.budgyt.com/trials/admins#settings-configuration)
    - [Reports & Visualizations](https://community.budgyt.com/trials/admins#reports-visualizations)
    - [Dimensions](https://community.budgyt.com/trials/admins#dimensions)
    - [Payroll (Employees)](https://community.budgyt.com/trials/admins#payroll-employees)
    - [Data/Formula](https://community.budgyt.com/trials/admins#data-formula)
    - [Balance Sheet and Cash Flow](https://community.budgyt.com/trials/admins#balance-sheet-and-cash-flow)
- [Regular Users](https://community.budgyt.com/trials/regular-users#main-content)

    - [Troubleshooting](https://community.budgyt.com/trials/regular-users#troubleshooting)
    - [Data Sheet](https://community.budgyt.com/trials/regular-users#data-sheet)
    - [Getting Started](https://community.budgyt.com/trials/regular-users#getting-started)
    - [Payroll (Employees)](https://community.budgyt.com/trials/regular-users#payroll-employees)
    - [Multi-Currency](https://community.budgyt.com/trials/regular-users#multi-currency)
    - [Dashboards](https://community.budgyt.com/trials/regular-users#dashboards)
    - [Approvals](https://community.budgyt.com/trials/regular-users#approvals)
    - [Scenarios (Budgets)](https://community.budgyt.com/trials/regular-users#scenarios-budgets)
- [FAQ](https://community.budgyt.com/trials/faq#main-content)

    - [Dashboards](https://community.budgyt.com/trials/faq#dashboards)
    - [Departments](https://community.budgyt.com/trials/faq#departments)
    - [Settings & Configuration](https://community.budgyt.com/trials/faq#settings-configuration)
    - [Approvals](https://community.budgyt.com/trials/faq#approvals)
    - [Scenarios (Budgets)](https://community.budgyt.com/trials/faq#scenarios-budgets)
    - [Categories](https://community.budgyt.com/trials/faq#categories)
    - [Navigation & User Interface](https://community.budgyt.com/trials/faq#navigation-user-interface)
    - [Reports](https://community.budgyt.com/trials/faq#reports)
    - [Data Sheet](https://community.budgyt.com/trials/faq#data-sheet)
    - [Setup & Onboarding](https://community.budgyt.com/trials/faq#setup-onboarding)
- [Features and Capabilities](https://community.budgyt.com/trials/features-and-capabilities#main-content)

    - [Approvals](https://community.budgyt.com/trials/features-and-capabilities#approvals)
    - [Multi-Currency](https://community.budgyt.com/trials/features-and-capabilities#multi-currency)
    - [Departments](https://community.budgyt.com/trials/features-and-capabilities#departments)
    - [Multi-Entity](https://community.budgyt.com/trials/features-and-capabilities#multi-entity)
    - [Balance Sheet and Cash Flow](https://community.budgyt.com/trials/features-and-capabilities#balance-sheet-and-cash-flow)
    - [General](https://community.budgyt.com/trials/features-and-capabilities#general)
- [Video Library](https://community.budgyt.com/trials/video-library#main-content)

    - [Getting Started](https://community.budgyt.com/trials/video-library#getting-started)
    - [Payroll (Employees)](https://community.budgyt.com/trials/video-library#payroll-employees)
    - [Formulas (C2C's & FOAs)](https://community.budgyt.com/trials/video-library#formulas-c2cs-foas)
    - [Dashboards](https://community.budgyt.com/trials/video-library#dashboards)
    - [Data Sheet](https://community.budgyt.com/trials/video-library#data-sheet)
    - [Reports & Visualizations](https://community.budgyt.com/trials/video-library#reports-visualizations)
- [Tips](https://community.budgyt.com/trials/tips#main-content)

    - [Free Trial Tips](https://community.budgyt.com/trials/tips#free-trial-tips)
    - [Top Tips](https://community.budgyt.com/trials/tips#top-tips)
- [Release Notes](https://community.budgyt.com/trials/release-notes#main-content)

    - [2023](https://community.budgyt.com/trials/release-notes#2023)
    - [2021](https://community.budgyt.com/trials/release-notes#2021)
    - [2022](https://community.budgyt.com/trials/release-notes#2022)
    - [2020](https://community.budgyt.com/trials/release-notes#2020)

[![Chill listening crop-3](https://community.budgyt.com/hs-fs/hubfs/budgyt-logo-blue-text.png?width=79&height=29&name=budgyt-logo-blue-text.png "Chill listening crop-3")](http://budgyt.com)

<https://www.facebook.com/> <https://www.twitter.com/> <https://www.instagram.com/> <https://podcasts.apple.com/> [mailto:email@email.com](mailto:email@email.com)

Copyright © 2025, Budgyt Inc