{"id":158240,"date":"2026-10-26T06:28:34","date_gmt":"2026-10-26T06:28:34","guid":{"rendered":"https:\/\/docs.daftra.com\/tutorial\/%d9%86%d8%b3%d8%ae-%d8%a8%d9%86%d9%88%d8%af-%d8%a7%d9%84%d8%a5%d8%b0%d9%86-%d8%a7%d9%84%d9%85%d8%ae%d8%b2%d9%86%d9%8a-%d9%85%d9%86-excel-%d9%86%d8%b3%d8%ae-%d9%85%d9%86-%d8%ac%d8%af%d9%88%d9%84\/"},"modified":"2026-11-12T07:54:27","modified_gmt":"2026-11-12T07:54:27","slug":"copying-requisition-items-from-excel-paste-from-sheet","status":"publish","type":"tutorial","link":"https:\/\/docs.daftra.com\/en\/tutorial\/copying-requisition-items-from-excel-paste-from-sheet\/","title":{"rendered":"Copying Requisition Items from Excel (Paste from Sheet)"},"content":{"rendered":"
\n
\n

\ud83d\udec8<\/span><\/p>\n

Note:<\/strong> There is no option in the system to import requisitions from an Excel or CSV file. But you can add all the requisition items at once by copying them from Excel or Google Sheets and pasting them into the requisition, using the Paste from Sheet<\/strong> feature explained in this guide.<\/p>\n<\/div>\n

The Paste from Sheet<\/strong> feature lets you paste the items list (products and quantities, and prices in an inbound requisition) into the requisition while creating it, instead of choosing each product and typing its quantity manually. It is useful when entering a large balance into a warehouse, issuing a list of products, or transferring a large number of products between warehouses.<\/p>\n

\n
Required Permissions<\/span>The permission to add requisitions, set from Roles<\/strong><\/a>.<\/span><\/div>\n
How to Access<\/span>Direct link: Manual Inbound<\/strong><\/a> or Manual Outbound<\/strong><\/a> or Manual Transfer<\/strong><\/a>. Or from Requisitions<\/strong><\/a> \u2192 Add<\/strong>, then from the items table: the arrow next to Add<\/strong> \u2192 Paste from Sheet<\/strong>.<\/span><\/div>\n<\/div>\n
\n

Table of Contents<\/p>\n

    \n
  1. Where Does the Feature Appear?<\/strong><\/a><\/li>\n
  2. Available Columns<\/strong><\/a><\/li>\n
  3. Preparing the Data in Excel<\/strong><\/a><\/li>\n
  4. Steps to Paste from Sheet<\/strong><\/a><\/li>\n
  5. How Does the System Handle the Pasted Data?<\/strong><\/a><\/li>\n
  6. Limits and Rules<\/strong><\/a><\/li>\n
  7. Error Messages and Solutions<\/strong><\/a><\/li>\n
  8. FAQs<\/strong><\/a><\/li>\n<\/ol>\n<\/div>\n

    Where Does the Feature Appear?<\/h2>\n\n\n\n\n\n\n\n
    Requisition type<\/th>\nOption from the Add list<\/th>\n<\/tr>\n
    Inbound Requisition<\/td>\nManual Inbound<\/strong><\/td>\n<\/tr>\n
    Outbound Requisition<\/td>\nManual Outbound<\/strong><\/td>\n<\/tr>\n
    Transfer Requisition<\/td>\nManual Transfer<\/strong> (appears if you have more than one warehouse)<\/td>\n<\/tr>\n
    Manufacturing Materials<\/td>\nManufacturing Materials<\/strong> (with the Manufacturing app)<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    The feature appears only when adding a new requisition, and does not appear when editing a saved requisition.<\/p>\n

    Available Columns<\/h2>\n

    The paste window columns differ according to the requisition type and your account settings:<\/p>\n\n\n\n\n\n\n\n\n
    Column<\/th>\nInbound requisition<\/th>\nOutbound requisition<\/th>\nTransfer requisition<\/th>\nNotes<\/th>\n<\/tr>\n
    Item Code \/ Name<\/strong><\/td>\nMandatory<\/td>\nMandatory<\/td>\nMandatory<\/td>\nThe product name, code, or barcode.<\/td>\n<\/tr>\n
    Quantity<\/strong><\/td>\nMandatory<\/td>\nMandatory<\/td>\nMandatory<\/td>\nA positive number.<\/td>\n<\/tr>\n
    Unit Price<\/strong><\/td>\nOptional<\/td>\n\u2014<\/td>\n\u2014<\/td>\nIf left empty, the product average price is used.<\/td>\n<\/tr>\n
    Cost Center Code \/ Name<\/strong><\/td>\nOptional<\/td>\nOptional<\/td>\n\u2014<\/td>\nAppears if distributing cost centers on requisition items is enabled.<\/td>\n<\/tr>\n
    Tracking Data<\/strong><\/td>\nOptional<\/td>\nOptional<\/td>\nOptional<\/td>\nAppears if product tracking is enabled.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

    Preparing the Data in Excel<\/h2>\n