Small Excel sample data is a short, clearly labeled set of rows you can paste into a worksheet to practice sorting, formulas, charts, or other spreadsheet tasks. Start with the sample below: copy the header and eight order records, then paste them into cell A1 in Excel.
Copyable small Excel sample data
This example represents a simple shop order list. It has one header row and eight records, with dates, product details, quantities, prices, and sales totals. The figures are illustrative rather than real business records.
Date Order ID Product Category Units Unit Price Sales
2026-01-05 O-1001 Notebook Stationery 3 2.50 7.50
2026-01-06 O-1002 Pen Stationery 10 0.80 8.00
2026-01-07 O-1003 Mug Home 2 8.00 16.00
2026-01-08 O-1004 Notebook Stationery 5 2.50 12.50
2026-01-09 O-1005 Cable Electronics 1 12.00 12.00
2026-01-10 O-1006 Mug Home 1 8.00 8.00
2026-01-11 O-1007 Pen Stationery 6 0.80 4.80
2026-01-12 O-1008 Cable Electronics 2 12.00 24.00
Each field belongs in its own column, and each order occupies one row. The Sales values are already calculated so you can immediately practice summaries; in a real workbook, you might instead calculate them from Units and Unit Price. The dataset is deliberately small enough to inspect without scrolling, but includes repeated products and categories so filters and summaries have something to work with.
How to paste and set up the data
In Excel for Microsoft 365 on Windows, select and copy the sample text, click cell A1, and press Ctrl+V. The tab separators should place the fields in separate columns. On a Mac, paste with Command+V. If the copied text appears entirely in column A, select that column and use Data > Text to Columns, choose Delimited, select Tab, and complete the wizard. This is a useful fallback when text copied from a webpage does not split automatically.
After pasting, make the range easier to work with by turning it into an Excel table:
- Click a cell within the pasted range.
- Select Insert > Table.
- Check that the range includes all seven columns and all eight records.
- Confirm that My table has headers is selected, then choose OK.
A table gives the dataset filter buttons and helps keep formatting consistent as you add rows. The date strings use the year-month-day order, which is commonly understood by spreadsheet software, but Excel’s interpretation can still depend on regional settings. Check that the Date column behaves like dates—for example, you can change its number format—and not like ordinary text. Format Unit Price and Sales as currency or numbers with two decimal places, and keep Units as whole numbers.
What makes sample data useful
Sample data is practice material, not just a collection of random values. A useful miniature dataset resembles the structure of the task you want to learn: a clear header row, consistent types of values in each column, and enough repeated values to reveal patterns. For instance, this order list repeats product names and categories, making it possible to filter for Stationery or compare sales by product.
Small samples are especially useful when learning an unfamiliar feature because the source rows remain easy to check. If a total looks wrong, you can trace it back to a handful of records. They also make convenient examples for class exercises, demonstrations, formula troubleshooting, and testing workbook layouts before you import a larger file. However, a tiny sample cannot represent every complication that might appear in a large real-world dataset, such as inconsistent spelling, missing values, or unusual dates.
Keep the distinction between a sample and actual operational data clear. These rows are invented for demonstration and should not be treated as evidence about a real store’s sales, prices, or performance. If you need examples for a report, label them as illustrative so that someone reading the workbook does not mistake them for measured results.
Try basic formulas with the example
Because the sample’s Sales figures are in column G, you can calculate the total by adding that column. With Sales in G2:G9, enter =SUM(G2:G9) in an empty cell. The result is 92.80: adding 7.50, 8.00, 16.00, 12.50, 12.00, 8.00, 4.80, and 24.00 gives 92.80.
You can also add sales for a single category. With category names in D2:D9 and sales amounts in G2:G9, enter =SUMIF(D2:D9,"Stationery",G2:G9) in an empty cell. It returns 32.80, the sum of the four Stationery orders. The quoted category text must match the entries in the Category column. If you change the category spelling in the data, adjust the formula’s criterion to match.
These examples also show why consistent columns matter. SUM adds numeric cells, while SUMIF checks a criteria range and totals corresponding values from a sum range. If values that look like prices were pasted as text, a formula may not treat them as expected. Use number formatting to change how numeric values appear; formatting alone does not convert every text value into a number. Inspect a problem cell or re-import the data with the correct delimiter and data types.
Choose a dataset for the task
The best small dataset depends on what you want to practice. A sales list works well for totals, category comparisons, and charts. For other exercises, choose columns that fit the skill rather than adding irrelevant detail. Examples include:
- Sorting and filtering: a reading log with title, author, genre, date started, and rating.
- Basic formulas: a household expense list with date, expense type, description, and amount. Use fictional figures for practice.
- Inventory: item name, category, quantity on hand, and reorder level, with a few items in each category.
- Scheduling: task, owner, start date, due date, and status, using consistent date and status values.
- Charts: a short monthly summary with one date or month column and one or more numeric series.
Choose a manageable number of fields and include enough records to test the intended feature. For a filter demonstration, several rows with repeated categories are more revealing than rows where every category is unique. For a chart, a sequence of dates or months and numeric values is usually easier to interpret than unrelated text labels. Avoid making the data so small that a chart or summary shows only one possible outcome.
Prepare rows for sorting, charts, and PivotTables
Keep one type of information per column: do not put a product name and its category together in the same cell if you will want to analyze those separately. Use one row per order, one header per column, and a single, descriptive header row. Avoid blank rows inside the dataset, merged cells in the data range, and extra titles embedded above the headers. Such layout choices can make it harder for Excel to identify the full range when you sort or summarize it.
For a basic chart, select a compact summary rather than charting every detail automatically. For example, create a small table with a category and its total sales, then select that summary and choose Insert > Recommended Charts. A chart of individual orders answers a different question from a chart of category totals, so decide what comparison you want readers to see. Excel may suggest chart types, but check that the labels and series make sense before using one.
A PivotTable can summarize the order list by category or product. Click inside the data table and choose Insert > PivotTable, then confirm the table or range and select where to place the PivotTable. Drag Category to Rows and Sales to Values to see category totals. If Excel counts the sales entries instead of summing them, the source values may be text or the value-field summary may need changing. The PivotTable is a summary of the source records; editing the source data does not always refresh the summary automatically, so use PivotTable Analyze > Refresh after changes.
Common sample-data problems
A common issue is every pasted field landing in one column. This usually means the tab separator was not preserved when copying. Use Data > Text to Columns and select Tab, or paste from a plain-text source that retains tab-separated columns. Another issue is dates displaying differently from the sample. Excel can show the same date using different regional formats; verify the underlying date value rather than assuming a display such as 01/05/2026 means the same thing in every locale.
Watch for inconsistent entries such as Stationery, stationery, and Stationery followed by a space. They may appear nearly identical but can be treated as different text values in filters or summaries. Similarly, a blank quantity is not the same as zero: blank means no value was entered, while zero is an explicit numeric value. Use whichever meaning fits the exercise, and do not silently replace missing information with zero if that would misrepresent it.
Finally, do not infer too much from a tiny dataset. Eight orders can help demonstrate a formula, but they cannot establish a reliable trend or describe a whole business. Small examples are for learning and checking mechanics; analysis intended to support real decisions requires suitable, sufficiently complete data and attention to how it was collected.
Where to find more practice data
You can create a short dataset yourself, use a workbook supplied with a class or tutorial, or look for sample workbooks from a reputable source. Excel also includes templates that can be opened and adapted, although a template may contain more structure than a beginner needs. When downloading a workbook, inspect the source and contents before enabling anything or entering information. A plain worksheet with clearly labeled columns is often a better starting point than a file with complicated formulas or macros.
For privacy, use fictional or suitably anonymized records when learning with customer, employee, health, or other sensitive information. Removing names alone may not make real records anonymous if other details can identify someone. Do not upload confidential data to a website just to obtain a practice example. A small invented table like the one above is enough for learning many core Excel skills without exposing personal information.
Frequently Asked Questions
How do I get sample data into Excel?
Copy the tab-separated sample, click A1 in a worksheet, and paste. Excel for Windows uses Ctrl+V; Excel for Mac uses Command+V. If the columns do not separate, use Data > Text to Columns and choose Tab as the delimiter.
Can I use this sample data to practice a PivotTable?
Yes. Convert the range to a table or select the data, then choose Insert > PivotTable. Put Category in Rows and Sales in Values to summarize the eight example orders by category.
Why are all my sample values in one Excel column?
The pasted text may have lost its tab separators. Select the affected column, choose Data > Text to Columns, select Delimited, and check Tab. Preview the result before finishing so each field lands in the intended column.
Is small sample data suitable for business decisions?
Usually not by itself. A small dataset can help you learn Excel or test a formula, but it may not represent a larger population or capture unusual cases. Use complete and appropriate source data for meaningful analysis.
Should I use zero or leave a sample-data cell blank?
Use zero when the value is known to be zero; leave a cell blank when the value is missing or not supplied. Formulas and summaries can treat blanks and zeros differently, so choose deliberately and document what the data means.
Related
- Excel Row Limit: How Many Rows Can a Sheet Hold?
- Excel Date Shortcut: Insert Today’s Date with Ctrl+;
- Data Excel Skills: What They Are and How to Build Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Conditional Formatting Greyed Out? Excel FixesIf Conditional Formatting is greyed out in Excel for Microsoft 365 on Windows, first check whether you are…
- Excel Goal Seek Cell Must Contain Value: Causes and FixesExcel Goal Seek needs a formula in the Set cell and an existing value in the By changing…
- How to Double Space a Paper in Word on Windows and MacTo double space a paper in Microsoft Word, select the text you want to change, then choose Home…
- Excel Basics for Data Analysis: IBM Course GuideIBM’s Excel Basics for Data Analysis is a beginner-level course that introduces spreadsheet skills used to organize, calculate,…
- Add a Named Range in Excel: Steps, Uses, and Helpful TipsTo add a named range in Excel for Microsoft 365 on Windows, select the cell or range, click…
- Excel Text Upside Down: What Works and What Doesn’tIn Excel for Microsoft 365 on Windows, you cannot rotate text inside a worksheet cell a full 180…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.