--- title: Importing items from a spreadsheet description: "A wizard matches the columns of a CSV or TSV to item fields, then applies the changes after a preview." lastUpdated: 2026-09-30 order: 80 --- Who can do this: administrators and owners. ## What it does Import items walks a spreadsheet into your item list, with a progress strip across the top reading Upload, Match columns, Review, Import and Done. Rows are matched to items you already have. A SKU the wizard recognises is updated. Any other row becomes a new item. A column headed stock followed by a dot and a location name brings that location's quantity in with the item. Match columns takes a first guess at which spreadsheet column belongs to which Lucrii field and labels each guess Auto-mapped or Suggested, with a percentage, where it wants a second look. Review counts the items to be created, the ones to be updated and the rows with errors. It also lists the vendors and units of measure it would create alongside them, and shows the first rows as they will be written. The import itself keeps running once it starts. You can close the page while it works, and the last step reports what was created, updated, skipped and failed. ## Before you start Importing is for an administrator or above. The page is replaced by a message about not having permission to import inventory, and every request underneath is refused as well. One import runs at a time. Starting a second offers to resume the first or cancel it. A file can have up to 50,000 rows. If the file would take you past your plan's item limit, the review shows how far over you are. The import button turns off until you upgrade or take rows out of the file. All-or-nothing stops the whole import if any row has an error, and the import button will not start until you fix those rows or untick it. Leave it unticked to bring in the rows that are good and skip the rest. Money columns are read in your organisation's currency. A new item from a row with no tax gets your default tax, which is set in Settings under Taxes. ## How to use it 1. Open the Items list, select Actions, then Import items. 2. Drop a CSV or TSV onto the upload area, or select it through the file browser. Download template CSV gives you the column headings to start from. 3. Select Next. 4. Check the column matches. Change anything that looks wrong, or select Auto-map again to redo the guesses. 5. Select Confirm mapping. You need at least one column matched before you can confirm. 6. Read the review. Tick the vendors and units you want created with the items, and decide whether to stop the import on any error. 7. Select the import button at the foot, which states the number of rows it will take. 8. Wait for the run to finish, or close the page and come back. Where rows failed, Download errors.csv gives you them to fix and re-upload. ## Troubleshooting Importing the same file twice can create duplicate items. This happens when a row has no id and no sku column, so it is treated as new every time. Add a sku column to update the item in place instead. ## Related - [Exporting items](/docs/inventory/export.md): Actions downloads your whole item list as a CSV. - [Creating an item](/docs/inventory/items-create.md): The create button opens the item form, which covers naming, pricing, stock tracking and the vendor you buy from. - [Items and locations](/docs/inventory/overview.md): Inventory is two lists, one of the items you buy and sell and one of the locations you keep them in. - [Stock locations](/docs/inventory/locations.md): Locations are the places you keep stock, each with an address of its own and stats for what is held there. ## Changes - [Guided quests and help for every feature](/changelog/2026-09-30-guided-quests-and-product-help) - 2026-09-30