# Excel Examples The SpecFlow+ Excel plugin allows you to extend scenario outlines in plain text with Excel tables. Add the Excel files containing these test examples to your project so that the examples can be used by your executable tests. See [SpecFlow+ Excel Getting Started](http://www.specflow.org/plus/excel/getting-started/) for a quick introduction. The sample [feature file](http://www.specflow.org/media/sfp_excel/Sample-ExcelExamples.feature) and the related [Excel file](http://www.specflow.org/media/sfp_excel/Sample-ExcelExamples.xlsx) include additional examples. ## Using the Same Excel File to Describe Multiple Example Sets One Excel examples file can be used to describe multiple example sets or even multiple scenario outlines. In this case, each worksheet should contain a single example set. In general, you should create an Excel examples file for each feature file. You can specify the name of the Excel sheet explicitly in the feature file, but this is not necessary if you name your sheets the same as your scenario outline titles. For more details, see [Prepare Feature Files for External Examples](Excel-Examples.html#Prepare-Feature-Files-for-external-Examples). ## Converting Excel Cell Values Cell values, in particular non-string values like dates or numbers, are converted using a specific culture when executing tests. Cell formatting options in Excel (e.g. number of decimal places, rounding, currency signs, date formats) are ignored. See [Converting Excel Cells](Converting-Excel-Cells.md) for more details. ## Prepare Feature Files for external Examples In order to use SpecFlow+ Excel to extend your scenario outlines with additional examples, you need to extend the scenario outline examples blocks with a special `@source` tag as follows: ``` @source:excel-file-path[:sheet-name] ``` The `excel-file-path` is the path to the Excel file, relative to the feature file itself. The `sheet-name` is optional. If no worksheet name is specified, the plugin uses the Excel sheet with the same name as the scenario outline, or the first worksheet in the file if there is no worksheet with a matching name. The `Examples` block must contain a header row. The header row needs to match in both the feature file and the Excel file (same columns, same order). You can also define concrete examples in the feature file. In this case, the examples from the Excel file are merged with the examples defined in the feature file. This sample [feature file](http://www.specflow.org/media/sfp_excel/Sample-ExcelExamples.feature) is extended with additional examples by this [Excel file](http://www.specflow.org/media/sfp_excel/Sample-ExcelExamples.xlsx). ```gherkin Feature: Calculator Scenario Outline: Add two numbers Given I have entered into the calculator And I have entered into the calculator When I press add Then the result should be on the screen @source:CalculatorExamples.xlsx Examples: | case | a | b | result | ```