{"id":50419,"date":"2020-05-04T03:35:08","date_gmt":"2020-05-04T10:35:08","guid":{"rendered":"http:\/\/www.technosolutions.com\/kb\/?p=50419"},"modified":"2020-05-04T03:40:00","modified_gmt":"2020-05-04T10:40:00","slug":"importing-requirements-from-the-clipboard-by-copying-from-an-excel-file","status":"publish","type":"post","link":"http:\/\/www.technosolutions.com\/kb\/50419\/importing-requirements-from-the-clipboard-by-copying-from-an-excel-file\/","title":{"rendered":"Importing Requirements from the clipboard by copying from an Excel file"},"content":{"rendered":"<p><!-- Start ScreenSteps Content --><\/p>\n<div class=\"LessonContent\">\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Overview<\/h3>\n<div class=\"StepInstructions\">\n<p>You can copy-paste requirements from your Excel files into <i>TopTeam<\/i> repository. A wizard will guide you through the steps of copying requirements from an Excel file.<\/p>\n<p>In this article, you will learn about how to import <i>Requirements<\/i> from the clipboard with the help of a wizard.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Who should read this?<\/h3>\n<div class=\"StepInstructions\">\n<ul>\n<li>TopTeam Users<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 1. Open the Excel file,from where you want to copy requirements<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/05\/media_1539781453797.png\" alt=\"media_1539781453797.png\" width=\"800\" height=\"561\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 2. In TopTeam, paste the requirements<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/05\/media_1588251014280.png\" alt=\"media_1588251014280.png\" width=\"778\" height=\"673\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>1. You can open either <i>Requirements Document Editor<\/i> or <i>Requirements Tree<\/i> editor for pasting requirements. Both these options can be opened from the <i>Requirements Document<\/i> detail editor.<br \/>\n2. Requirements will be pasted as child requirements of the requirement on which the cursor is placed. If no requirement is selected in the editor, requirements will be added as child requirements of the <i>Requirement Type<\/i> to which they belong.<\/p>\n<p>You can also use <strong>Ctrl+V <\/strong>or click <strong>Paste<\/strong> on the ribbon toolbar to paste the requirements.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Import Requirements from Clipboard Wizard opens<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/05\/media_1588251113929.png\" alt=\"media_1588251113929.png\" width=\"800\" height=\"643\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 3. Specify whether the first row of your data should be header<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/05\/media_1539782178608.png\" alt=\"media_1539782178608.png\" width=\"800\" height=\"643\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 4. Map fields between data file and TopTeam<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/05\/media_1539782232042.png\" alt=\"media_1539782232042.png\" width=\"800\" height=\"643\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 5. Specify Project and Requirements Document into which you want to copy requirements<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/05\/media_1588251344147.png\" alt=\"media_1588251344147.png\" width=\"800\" height=\"643\" \/><\/div>\n<div class=\"StepInstructions\">\n<p>By default, the current project and <i>Requirements Document<\/i> is selected. If you want to change both, you can change by selecting desired project and document from the drop-down lists.<br \/>\nYou can also create a new <i>Requirements Document<\/i> on this page.<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 6. View Action Summary and import the requirements<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/05\/media_1539782270145.png\" alt=\"media_1539782270145.png\" width=\"800\" height=\"643\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Step 6. Requirements have been imported successfully<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/05\/media_1588251458158.png\" alt=\"media_1588251458158.png\" width=\"800\" height=\"643\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">View the imported requirements<\/h3>\n<div class=\"StepImage\" style=\"margin: 10px 0px;\"><img loading=\"lazy\" decoding=\"async\" style=\"padding: 3px; border: 1px solid #ccc;\" src=\"data:image\/gif;base64,R0lGODlhAQABAAAAACH5BAEKAAEALAAAAAABAAEAAAICTAEAOw==\" data-layzr=\"http:\/\/www.technosolutions.com\/kb\/wp-content\/uploads\/2020\/05\/media_1588251540334.png\" alt=\"media_1588251540334.png\" width=\"756\" height=\"541\" \/><\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">Related Articles<\/h3>\n<div class=\"StepInstructions\">\n<p><a href=\"http:\/\/www.technosolutions.com\/kb\/4835\/how-do-i-import-requirements-from-excel\/\" target=\"_blank\" rel=\"noopener\">How do I import Requirements from Excel <\/a>using <strong>Import Requirements from File<\/strong> wizard<\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<h3 class=\"StepTitle\" style=\"font-size: 20px;\">See Also<\/h3>\n<div class=\"StepInstructions\">\n<p><a href=\" http:\/\/www.technosolutions.com\/kb\/50408\/importing-requirements-from-clipboard-by-copying-from-a-word-document\" target=\"_blank\" rel=\"noopener\">Importing Requirements from the Clipboard by copying from a Word document<\/a><br \/>\n<a href=\"http:\/\/www.technosolutions.com\/kb\/4869\/how-do-i-import-requirements-from-my-word-document\/\" target=\"_blank\" rel=\"noopener\">How do I import Requirements from my Word Document<\/a> using <strong>Import Requirements from Word Wizard<\/strong><br \/>\n<a href=\"http:\/\/www.technosolutions.com\/kb\/47356\/importing-records-from-reqif-file-using-wizard\/\" target=\"_blank\" rel=\"noopener\">Importing records from ReqIF File using Wizard<\/a><\/p>\n<\/div>\n<\/div>\n<div class=\"LessonStep top\">\n<div class=\"StepInstructions\">\n<p>Revised: May 4th, 2020<\/p>\n<\/div>\n<\/div>\n<\/div>\n<p><!-- End ScreenSteps Content --><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview You can copy-paste requirements from your Excel files into TopTeam repository. A wizard will guide you through the steps of copying requirements from an Excel file. In this article, you will learn about how to import Requirements from the clipboard with the help of a wizard. Who should read this? TopTeam Users Step 1. Open the Excel file,from where you want to copy requirements Step 2. In TopTeam, paste the requirements 1. You can open either Requirements Document Editor or Requirements Tree editor for pasting requirements. Both these options can be opened from the Requirements Document detail editor. 2. <\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[33],"tags":[167,46,286],"class_list":["post-50419","post","type-post","status-publish","format-standard","hentry","category-requirements","tag-excel","tag-import","tag-requirements"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/paoaNA-d7d","_links":{"self":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/50419","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/comments?post=50419"}],"version-history":[{"count":2,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/50419\/revisions"}],"predecessor-version":[{"id":50421,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/posts\/50419\/revisions\/50421"}],"wp:attachment":[{"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/media?parent=50419"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/categories?post=50419"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.technosolutions.com\/kb\/wp-json\/wp\/v2\/tags?post=50419"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}