# Excel Practice Files: 6 Free Workbooks to Download
> Download six free Excel practice files with real data: trout stocking, crops, wine, Apple revenue, Starbucks and indicators, each with a task and its answer.

- Web page: https://logicexcel.com/functions/excel-practice-files-download
- Language: en
- Updated: 2026-11-19
- Practice this in the browser: https://logicexcel.com/practice/60

LogicExcel has six real-data Excel practice files you can download free: New York trout stocking, world crop production, wine consumption, Apple's segment revenue, Starbucks locations and a country indicators table. Each is an ordinary .xlsx file. Below, each one has its size, where the data came from, a task to try and the answer formula.

Click a file name to download it. The same files are used in the marked lessons, so you can practise on your own first and then have your formulas checked as you type.

## The six files at a glance

| File | What it holds | Size | Best for |
| --- | --- | --- | --- |
| [NewYorkTrout.xlsx](https://logicexcel.com/NewYorkTrout.xlsx) | Trout stocked by county, town, waterbody and species | 1,504 rows, 5 columns | SUMIF, SUMIFS, COUNTIF, wildcards |
| [WorldCropProduction2018.xlsx](https://logicexcel.com/WorldCropProduction2018.xlsx) | Banana, coffee and avocado production by country, in tonnes | 127 countries | MAX, COUNT, INDEX and MATCH, VLOOKUP |
| [WDIDataTable.xlsx](https://logicexcel.com/WDIDataTable.xlsx) | Four indicators for 217 countries, 2000 to 2019 | 868 rows, 24 columns | SUMIFS, pivot tables, filters |
| [WineData.xlsx](https://logicexcel.com/WineData.xlsx) | Litres of wine per person, by country and year, 1980 to 2014 | 8,952 rows | SUMIFS, lookup keys, dashboards |
| [AppleSegmentRevenue.xlsx](https://logicexcel.com/AppleSegmentRevenue.xlsx) | Revenue by product segment, three years | 5 segments | SUM, percentages, charts |
| [sbuxLocations.xlsx](https://logicexcel.com/sbuxLocations.xlsx) | Starbucks locations in 81 countries | 81 rows, 2 columns | SUM, VLOOKUP, LARGE |

## New York trout stocking: SUMIF on 1,504 records

The data is from Data.gov: each row is one stocking, with County, Town, Waterbody, Number and Species Name in columns A to E.

**Task:** how many trout were stocked in Albany county, and how many records are Brown Trout?

```
=SUMIF(A:A,"Albany",D:D)
=COUNTIF(E:E,"Brown Trout")
```

The answers are 6,399 trout and 1,101 records. The [SUMIF practice](https://logicexcel.com/practice/60), the [SUMIFS practice](https://logicexcel.com/practice/61) and the [text functions practice](https://logicexcel.com/practice/62) all use this file.

## World crop production 2018: find the biggest producer

The numbers are FAOSTAT's 2018 production in tonnes, with a column each for Banana, Coffee Bean and Avocado. Where a country has no figure, the cell says "No Data", which is text, so MAX and COUNT skip it.

**Task:** which country produced the most bananas, and how many countries have a coffee figure?

```
=INDEX(A2:A128,MATCH(MAX(B2:B128),B2:B128,0))
=COUNT(C2:C128)
```

The answers are India, at 30,808,000 tonnes, and 77 countries. The same file drives the [COUNT practice](https://logicexcel.com/practice/56), [MIN, MAX, LARGE and SMALL practice](https://logicexcel.com/practice/57), [VLOOKUP practice](https://logicexcel.com/practice/58) and [INDEX MATCH practice](https://logicexcel.com/practice/59).

## Country indicators: South Asia included

Each country has four indicators (GDP in constant 2010 US dollars, access to electricity, tourist arrivals and military spending) for every year from 2000 to 2019, plus its region and currency. India, Pakistan, Bangladesh, Sri Lanka, Nepal, Bhutan, the Maldives and Afghanistan are in the South Asia region.

**Task:** how many rows belong to South Asia, and what share of India's population had access to electricity in 2018? The 2018 values are in column W.

```
=COUNTIF(B:B,"South Asia")
=SUMIFS(W:W,A:A,"India",D:D,"Access to electricity (% of population)")
```

The answers are 32 rows (eight countries and four indicators) and 95.2 per cent. Build a pivot table of the same data next, as in [Pivot Tables 1](https://logicexcel.com/practice/37) and [Pivot Tables 2](https://logicexcel.com/practice/38).

## Wine consumption: one country, one year

The file has two sheets. WinePerPerson lists Country, Year and litres of wine per person aged 15 and over, from Our World in Data, for 1980 to 2014. The Dashboard sheet is the starting point of the [wine dashboard lesson](https://logicexcel.com/practice/54), which builds country and year lookups with a joined lookup key.

**Task:** how many litres per person were drunk in France in 2010?

```
=SUMIFS(C:C,A:A,"France",B:B,2010)
```

The answer is 6.6. SUMIFS works here because only one row matches; to average over several years, use AVERAGEIFS with the same criteria.

## Apple segment revenue: totals and shares

The sheet is called Sales and holds Apple Inc.'s revenue by segment from its annual report, in millions of dollars, for 2018, 2019 and 2020. The Total row is empty on purpose, ready for your formula.

**Task:** work out the 2020 total, then Services as a share of it. The 2020 figures are in E5:E9.

```
E10: =SUM(E5:E9)
=E9/E10
```

The total is 274,515 and Services is 19.6% of it (format the cell as a percentage). This is the file of the [SUM function lesson 55](https://logicexcel.com/practice/55). Add a pie chart of the five segments for a first chart.

## Starbucks locations: a lookup in 81 rows

Column A has the country and column B the number of locations. The US is the largest at 13,352.

**Task:** how many locations are there in India, and how many in total?

```
=VLOOKUP("India",A2:B82,2,FALSE)
=SUM(B2:B82)
```

The answers are 196 and 27,885. Replace "India" with a country name typed in a cell and the lookup works for any of the 81. The [conditional formatting lesson](https://logicexcel.com/practice/46) uses this file to highlight countries by their number of locations.

## Where to go next

Files give you data; marking tells you whether your formula is right. On LogicExcel you type formulas into a live grid and are marked on the result as you type, in your browser. The [Excel practice exercises](https://logicexcel.com/practice/excel-exercises) list every lesson and the workbook each uses. For ready-made tasks without a file, see [Excel assignments for practice](https://logicexcel.com/functions/excel-assignments-for-practice), and for outside datasets see [Excel sample data for practice](https://logicexcel.com/functions/excel-sample-data-for-practice). To follow a path, the [Excel courses](https://logicexcel.com/learn/excel-courses) start free, and each one ends in a marked exam.

## FAQ

### Where can I download Excel practice files for free?

LogicExcel has six real-data practice workbooks you can download from this page as .xlsx files: trout stocking, crop production, country indicators, wine consumption, Apple revenue and Starbucks locations. For larger public datasets, sites such as Kaggle and Data.gov also offer free files.

### How do I use an Excel practice file?

Download it, open it in Excel and read the headings first. Then write formulas to answer a question about the data, such as a total, a count or a lookup, and compare the result with the answer on this page. Repeat with a new question until you do not need to look anything up.

### What is a good practice file for pivot tables?

The country indicators file has regions, countries, indicators and 20 years of data, which gives a pivot table real choices of rows, columns and values. The trout stocking file works too: counties in Rows, species in Columns and Number in Values.

### Do I need to sign up to download the files?

No. Each file name on this page is a direct download link to a file on logicexcel.com, so you can open it in Excel straight away.
