# How create a recipe used igintion **URL:** \ **Category:** Ignition\ **Created:** [August 7, 2023, 1:35pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517 "2023-08-07T13:35:26Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![nabil\_hocini](https://avatars.discourse-cdn.com/v4/letter/n/779978/32.png) [@nabil\_hocini](https://forum.inductiveautomation.com/u/nabil_hocini)\ **Post date:** [August 7, 2023, 1:35pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/1 "2023-08-07T13:35:26Z")
Hello everyone, I am beginning in ignition let me ask you about the way that I could create the recipe in ignition, please ---
**Author:** ![Tim\_Carlton](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tim_carlton/32/52835_2.png) [@Tim\_Carlton](https://forum.inductiveautomation.com/u/Tim_Carlton)\ **Post date:** [August 7, 2023, 1:41pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/2 "2023-08-07T13:41:05Z")
How would you create a recipe on paper or in a spreadsheet? What pieces of information would you need? Where (who) would they come from? How would those pieces of information be grouped (things that always belong together, things that sometimes belong together, things that can vary independently of each other)? Is there a single source of truth for approved recipes? Can recipe settings be changed during production? If so, by whom? Do you need to keep the recipe settings that were used in an audit log? ---
**Author:** ![nabil\_hocini](https://avatars.discourse-cdn.com/v4/letter/n/779978/32.png) [@nabil\_hocini](https://forum.inductiveautomation.com/u/nabil_hocini)\ **Post date:** [August 7, 2023, 1:47pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/3 "2023-08-07T13:47:41Z")
> [@Tim\_Carlton](#): > > y whom? > D I need to create it from the Excel sheet ---
**Author:** ![Tim\_Carlton](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/tim_carlton/32/52835_2.png) [@Tim\_Carlton](https://forum.inductiveautomation.com/u/Tim_Carlton)\ **Post date:** [August 7, 2023, 1:52pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/4 "2023-08-07T13:52:33Z")
What is a recipe? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [August 7, 2023, 1:53pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/5 "2023-08-07T13:53:23Z")
> [@nabil\_hocini](#): > > I need to create it from the Excel sheet What have you tried? We don't know what shape any of your information takes. What does "create" mean to you? I would recommend that you try something and then come back with what you tried and what went wrong. Perhaps start here: > [@Copying an Excel file to a table's dataset](https://forum.inductiveautomation.com/t/copying-a-excel-file-to-a-tables-dataset/34942/7): > > The [Apache POI](https://poi.apache.org/apidocs/4.1/index.html) libraries are included with Ignition. At the time I was only needing to read files, so xlrd was all that was necessary. I'm just starting to dig into POI, myself, but here's a start: EDIT 2021-08-23: Updated to allow JsonDataSets. Changed to allow for a ByteArray output instead of writing to a file. EDIT 2023-01-20: Added option for date formats. Default is 'yyyy-MM-dd hh:mm:ss'. EDIT 2023-05-12: Added options for first row and column, if needed to offset from A1 def datasetT… ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [August 7, 2023, 2:00pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/6 "2023-08-07T14:00:51Z")
A few from Mr. Google: [https://docs.inductiveautomation.com/display/DOC80/Recipe+Group](https://docs.inductiveautomation.com/display/DOC80/Recipe+Group) [![](https://us1.discourse-cdn.com/inductiveautomation/original/3X/2/5/25debd213d40aa995ca47fd4b27f28cd3fd4c7fd.jpeg "Recipe Management with Configuration Demo") ](https://www.youtube.com/watch?v=k84SP1BBijk) ---
**Author:** ![nabil\_hocini](https://avatars.discourse-cdn.com/v4/letter/n/779978/32.png) [@nabil\_hocini](https://forum.inductiveautomation.com/u/nabil_hocini)\ **Post date:** [August 7, 2023, 2:03pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/7 "2023-08-07T14:03:52Z")
you know what, i have some recipes in the Excel sheet and I want to import this sheet in ignition? right now I ignore the way that i do it ---
**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\ **Post date:** [August 7, 2023, 2:09pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/8 "2023-08-07T14:09:31Z")
1. Have you got a database? 2. Have you created a recipe table? 3. Is there a field for each recipe setting? 4. Do you have some sort of user interface for the database? e.g. MySQLWorkbench for MySQL. 5. Can you paste the data in using that application? ---
**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\ **Post date:** [August 7, 2023, 2:23pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/9 "2023-08-07T14:23:14Z")
> [@nabil\_hocini](#): > > right now I ignore the way that i do it Okay, I'll just come right out and say it. If you're expecting us to do it for you, that isn't going to happen. > **[The Beginner's Guide to Asking Coding Questions Online](https://codewithandrea.com/articles/beginners-guide-coding-questions/)** > > Asking questions and receiving answers is a two-way street. Here's what to do when you need to ask a technical coding question. How are you doing it? You have to help us help you. You do that by providing information on what you're doing and why that isn't working. Hopefully that includes some properly formatted code. ---
**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\ **Post date:** [August 7, 2023, 2:37pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/10 "2023-08-07T14:37:08Z")
Also, > **[Learn Ignition at Your Own Pace](https://www.inductiveuniversity.com/)** > > Inductive University is a completely free online learning platform > to help you learn Ignition by Inductive Automation®, the most powerful SCADA software in the world You NEED to start there. Otherwise, nothing we can say or do will be of any help to you. ---
**Author:** ![nabil\_hocini](https://avatars.discourse-cdn.com/v4/letter/n/779978/32.png) [@nabil\_hocini](https://forum.inductiveautomation.com/u/nabil_hocini)\ **Post date:** [August 7, 2023, 2:55pm UTC](https://forum.inductiveautomation.com/t/how-create-a-recipe-used-igintion/77517/11 "2023-08-07T14:55:41Z")
> [@pascal.fragnoud](#): > > You NEED to start there. Otherwise, nothing we can say or do will be of any help to you. ok thanks!