# SyteLine Excel add-in and paste rows: bulk loading data > Source: https://netray.co/erp-help/syteline-excel-add-in-and-paste-rows-append > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: ERP Help ## Short answer There are two common ways to move spreadsheet data into SyteLine: the Excel add-in, which reads and writes IDO data from Excel, and the grid's paste rows features, which copy rows from Excel into a form. Both go through the same business rules as manual entry, so errors appear per row. Always trial on a test site and load in small batches. ## Kind how-to ## System syteline ## Erp Infor SyteLine (CloudSuite Industrial) ## Module Data Loading / Excel ## Query syteline excel add in ## Alternate Queries - syteline paste rows append - SyteLine bulk load from Excel - SyteLine copy rows from Excel into grid ## Applies To SyteLine 9.x and CloudSuite Industrial 10.x; availability and menu names vary by release and deployment ## Steps ### Bulk load safely **Items:** - Decide which operation you need: insert new rows, update existing, or just extract data to Excel. - Prepare the spreadsheet with column headers in the same order as the target form, in the target data formats (dates, decimals, codes). - Clean the data first: trim spaces, check lookups such as item, customer and unit of measure exist, and remove duplicates. - Open the target form in a test site and try five rows first. - For paste rows, copy the range in Excel and use the append option in the form's edit menu so rows are added after existing ones. - For the add-in, connect to the configuration, select the IDO collection and properties, and save or update from the worksheet. - Review row-level errors, fix the source and reload only the failed rows. - After success, reconcile counts and totals against the source before loading production. ## Sections ### The add-in versus paste rows **Body:** Paste rows is the quickest option for small loads into a single grid, like adding order lines or cost records. It works at the form level and respects form defaults and validations, so it behaves like fast typing. The Excel add-in suits repeated or larger work because it works directly against IDO properties, can refresh data and keeps a reusable workbook. It needs the add-in installed and a connection set up, and the user needs authorization for the underlying IDOs. ### Preparing data that will actually load **Body:** Most failures come from data, not the tool: lookups that do not exist, wrong date formats, trailing spaces in codes, decimals using the wrong separator, and required fields left empty. A staging worksheet with validation formulas against exported master data catches these before loading. For loads that create financial or inventory transactions, use the normal transaction forms in a controlled batch, not a direct table update, so costing and GL posting rules apply. ### When to use something else **Body:** For very large volumes or recurring integrations, use an IDO-based import, a scheduled task or a middleware route with logging and rollback rather than a spreadsheet. Spreadsheets lack an audit trail and are easy to run twice. Keep a copy of every file loaded to production with the date, user and result. It will save you during reconciliation. ## Pitfalls - Loading into production without a test run. - Pasting over existing rows when you meant to append. - Hidden spaces and leading zeros lost in Excel cells. - Running the same load twice and creating duplicates. - Using direct updates for transactional data, bypassing posting rules. ## Ai Angle A grounded assistant can pre-check a spreadsheet against live master data, listing rows whose item, customer, UOM or location does not exist, and suggest corrections, before anyone touches production. It reads data and shows the query. The load itself runs through SyteLine under the user's own authorizations. ## Faq ### What does paste rows append do in SyteLine? **Answer:** It adds copied rows to the end of the grid instead of replacing selected rows. This is generally what you want for bulk entry. Test on a few rows, because behavior depends on the form. ### Can the Excel add-in update existing records? **Answer:** Yes, it can retrieve records and save changes through the IDO, subject to the user's authorizations and business rules. Test the update path on a non-production site and limit the columns you change. ### Why do some rows fail to load? **Answer:** Usually because a lookup value does not exist, a required field is empty, a date or number format is wrong, or a validation rule rejects it. Check the row-level message and fix the source data. ### Is Excel loading safe for inventory or GL transactions? **Answer:** Only through the normal transaction forms with controls, in small reviewed batches. Avoid direct table updates for anything that affects cost, inventory or the ledger. ## Search terms syteline excel add in, syteline paste rows append, syteline bulk upload excel, syteline import from excel, csi excel add-in ido, syteline load data spreadsheet, syteline mass update, syteline copy paste grid --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json