Spreadsheet Software

Lesson 3 of 8 · Software for Data Work 101 · Beginner

Spreadsheet software is the most widely used data tool in the world. From tracking budgets to analyzing survey results, spreadsheets handle an enormous range of tasks. Understanding what they do well — and where they fall short — helps you use them effectively and know when to reach for something else.

What Is a Spreadsheet?

A spreadsheet is a grid of rows and columns where you can enter data, write formulas, and perform calculations. Each cell in the grid can hold a number, text, a date, or a formula that calculates a value based on other cells.

Spreadsheets are flexible, visual, and relatively easy to learn. They work well for:

• Small to medium datasets (typically under 100,000 rows)
• Quick calculations and summaries
• Simple charts and visualizations
• Data entry and collection
• Sharing data in a familiar format

CSV Files and Spreadsheets

A CSV (Comma-Separated Values) file is a plain text format for storing tabular data. Each row is a line of text, and each column is separated by a comma. CSV files can be opened in spreadsheet software, but they do not support formulas, formatting, or multiple sheets.

CSV is the most common format for sharing data between systems. When you download data from a government open data portal, it is often in CSV format.

Formulas and Basic Analysis

Spreadsheet formulas allow you to calculate totals, averages, counts, and more. Common operations include:

• Summing a column of numbers
• Calculating averages and percentages
• Counting entries that meet a condition
• Looking up values from another table
• Sorting and filtering rows

Where Spreadsheets Fall Short

Spreadsheets have real limitations that become apparent as your data grows:

• Scale. Spreadsheets slow down significantly with very large datasets. They are not designed for millions of rows.
• Concurrent editing. Multiple people editing the same spreadsheet simultaneously can cause conflicts and data loss.
• Data integrity. Spreadsheets do not enforce data types or relationships. Anyone can type anything in any cell.
• Version control. Without careful file management, it is easy to lose track of which version of a spreadsheet is current.
• Automation. Spreadsheets are not designed for automated data pipelines or scheduled processing.

When these limitations become problems, it is usually time to consider database software.

Related learning: Data Cleaning 101 covers how to identify and fix common data quality issues in spreadsheets and other tools.