--- title: PRODUCTION TEMPLATES - Import description: Import Production Templates from an Excel spreadsheet, new Production Template, add Template, new Template --- [![company logo](https://cs.geminilogic.com/hs-fs/hubfs/Gemini-Logic-Logo%20(1).png?height=120&name=Gemini-Logic-Logo%20(1).png)](https://www.geminilogic.com/) [User Manual](https://cs.geminilogic.com/en/migrated/manual) - [Go to Gemini Logic](https://www.geminilogic.com/) - [New Ticket](https://cs.geminilogic.com/en/migrated/manual/kb-tickets/new) - [Go to Customer Portal](https://cs.geminilogic.com/tickets-view) Spire User Manual - Production Manager - [Spire Systems - General Knowledge Base](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base) - [Tips and Tricks](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#tips-and-tricks) - [Spire Administration - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-general-ledger) - [Spire Administration - Sales](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-sales) - [Spire Administration - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-inventory) - [Analytics for Spire](https://cs.geminilogic.com/en/migrated/manual/analytics-for-spire) - [Spire User Manual - System Overview](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-system-overview) - [Spire User Manual - User Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-settings) - [Spire User Manual - Vendors](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-vendors) - [Spire User Manual - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory) - [Pricing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory#pricing) - [Spire User Manual - Price Matrix](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-price-matrix) - [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-purchase-orders) - [Spire User Manual - Sales Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-sales-orders) - [Spire User Manual - Keyboard Shortcuts](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-keyboard-shortcuts) - [Spire User Manual - Company Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-company-settings) - [Spire User Manual - New Instal/Company Setup](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-new-instal-company-setup) - [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-general-ledger) - [Spire User Manual - Accounts Receivable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-receivable) - [Spire User Manual - Accounts Payable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-payable) - [Spire User Manual - Payroll](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-payroll) - [Spire User Manual - Production Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-production-manager) - [Spire User Manual - Service Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-service-manager) - [Spire User Manual - User Defined Fields](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-defined-fields) - [Spire User Manual - Job Costing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-job-costing) - [HubSpot](https://cs.geminilogic.com/en/migrated/manual/hubspot) - [Updates](https://cs.geminilogic.com/en/migrated/manual/hubspot#updates) - [Gemini Logic](https://cs.geminilogic.com/en/migrated/manual/gemini-logic) - [Shipping](https://cs.geminilogic.com/en/migrated/manual/shipping) - [Sales Taxes](https://cs.geminilogic.com/en/migrated/manual/sales-taxes) - [Spire User Manual](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual) - [Customers](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual#customers) [Back to home](https://cs.geminilogic.com/en/migrated/manual) 1. [User Manual](https://cs.geminilogic.com/en/migrated/manual) 2. Spire User Manual - Production Manager - [Spire Systems - General Knowledge Base](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base) - [Tips and Tricks](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#tips-and-tricks) - [Spire Administration - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-general-ledger) - [Spire Administration - Sales](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-sales) - [Spire Administration - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-systems-general-knowledge-base#spire-administration-inventory) - [Analytics for Spire](https://cs.geminilogic.com/en/migrated/manual/analytics-for-spire) - [Spire User Manual - System Overview](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-system-overview) - [Spire User Manual - User Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-settings) - [Spire User Manual - Vendors](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-vendors) - [Spire User Manual - Inventory](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory) - [Pricing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-inventory#pricing) - [Spire User Manual - Price Matrix](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-price-matrix) - [Spire User Manual - Purchase Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-purchase-orders) - [Spire User Manual - Sales Orders](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-sales-orders) - [Spire User Manual - Keyboard Shortcuts](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-keyboard-shortcuts) - [Spire User Manual - Company Settings](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-company-settings) - [Spire User Manual - New Instal/Company Setup](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-new-instal-company-setup) - [Spire User Manual - General Ledger](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-general-ledger) - [Spire User Manual - Accounts Receivable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-receivable) - [Spire User Manual - Accounts Payable](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-accounts-payable) - [Spire User Manual - Payroll](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-payroll) - [Spire User Manual - Production Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-production-manager) - [Spire User Manual - Service Manager](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-service-manager) - [Spire User Manual - User Defined Fields](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-user-defined-fields) - [Spire User Manual - Job Costing](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual-job-costing) - [HubSpot](https://cs.geminilogic.com/en/migrated/manual/hubspot) - [Updates](https://cs.geminilogic.com/en/migrated/manual/hubspot#updates) - [Gemini Logic](https://cs.geminilogic.com/en/migrated/manual/gemini-logic) - [Shipping](https://cs.geminilogic.com/en/migrated/manual/shipping) - [Sales Taxes](https://cs.geminilogic.com/en/migrated/manual/sales-taxes) - [Spire User Manual](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual) - [Customers](https://cs.geminilogic.com/en/migrated/manual/spire-user-manual#customers) # PRODUCTION TEMPLATES - Import **![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-May-07-2023-06-01-31-0337-PM.png?width=50&height=47&name=image-png-May-07-2023-06-01-31-0337-PM.png) Import Production Templates** from an Excel spreadsheet - **Access** - Tools > Import         ![ToolsTextMenuImport](https://cs.geminilogic.com/hs-fs/hubfs/ToolsTextMenuImport.png?width=218&height=169&name=ToolsTextMenuImport.png)  ![ProductionTemplateImport](https://cs.geminilogic.com/hs-fs/hubfs/ProductionTemplateImport.png?width=458&height=436&name=ProductionTemplateImport.png) 1. - option to open a previously saved import configuration / mapping  ![ImportOpenConfig](https://cs.geminilogic.com/hs-fs/hubfs/ImportOpenConfig.png?width=28&height=26&name=ImportOpenConfig.png) or continue as follows: - select the .xlsx or .csv file **Source **location using the **Browse Files…** if this is an unsaved Import or **Browse Folders…** button if this is a previously saved Import - accept or change **Date Format** if applicable - select **Production Order** Import **Type** - map fields (including [UDFs](https://cs.geminilogic.com/en/manual/user-defined-fields-add-edit-fields)): - select the field under **Import File** (ie: **Template No** from Excel) - select the corresponding field under **Spire Fields** (ie: **Template No**) - click the **Match** button - continue to **Match** all fields you want to import into Spire - matched items will transfer down to lower section, where you can then select the field and **Unmatch** if desired - note the ‘Group By’ field which is used to group lines on the spreadsheet to an individual order - option to select a **Destination** folder to move the successfully imported file to - option to select a **Failure** folder to move the unsuccessfully imported file to - determine if your spreadsheet ![CheckBoxCheckedBlue](https://cs.geminilogic.com/hs-fs/hubfs/CheckBoxCheckedBlue.png?width=16&height=16&name=CheckBoxCheckedBlue.png) **Has** **Header Row **(see top) - click on ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Dec-20-2022-08-09-14-0425-PM.png?width=19&height=19&name=image-png-Dec-20-2022-08-09-14-0425-PM.png) **Save config **/ ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Dec-20-2022-08-09-20-0482-PM.png?width=22&height=24&name=image-png-Dec-20-2022-08-09-20-0482-PM.png) **Save config as **to save the Source, Import Type, Field Mapping, Destination and Failure folders - Note the ![CheckBoxCheckedBlue](https://cs.geminilogic.com/hs-fs/hubfs/CheckBoxCheckedBlue.png?width=16&height=16&name=CheckBoxCheckedBlue.png) **Post Immediately** selection…this will post the imported Sales Orders into Sales History as Invoices rather than into Sales as open orders - click on ![](https://cs.geminilogic.com/hs-fs/hubfs/image-png-Dec-20-2022-08-09-32-7051-PM.png?width=24&height=23&name=image-png-Dec-20-2022-08-09-32-7051-PM.png) Import to finish and review the newly imported records in Spire [![company logo](https://cs.geminilogic.com/hs-fs/hubfs/Gemini%20Logic%20-%20Black-1.png?height=120&name=Gemini%20Logic%20-%20Black-1.png)](https://www.geminilogic.com/) Gemini Logic - [![linkedin_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/linkedin_circle_color.png)](https://www.linkedin.com/company/2460588) - [![youtube_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/youtube_circle_color.png)](https://www.youtube.com/user/GeminiLogicInc/featured) - [![twitter_social_link_icon_alt_text](https://static.hsstatic.net/TemplateAssets/static-1.329/img/hs_default_template_images/modules/Follow+Me+-+Email/twitter_circle_color.png)](https://twitter.com/gemini_logic) - [Go to Gemini Logic](https://www.geminilogic.com/) - [New Ticket](https://cs.geminilogic.com/en/migrated/manual/kb-tickets/new) - [Go to Customer Portal](https://cs.geminilogic.com/tickets-view)