Import Inventory

Bring your existing inventory into Legitski from Excel, CSV, or JSON files. The guided wizard handles column mapping, data validation, and sanitization automatically.

Supported File Formats

Legitski accepts the three most common data interchange formats. All parsing happens in your browser before anything is sent to the server.

FormatExtensionsMax SizeNotes
Excel.xlsx, .xls50 MBFirst sheet is used by default. Multi-sheet selection coming soon.
CSV.csv50 MBUTF-8 encoding recommended. Comma, semicolon, and tab delimiters are auto-detected.
JSON.json50 MBExpects an array of objects. Header selection step is skipped automatically.

Drag and drop

You can drag files directly onto the upload area, or click to browse. The file is parsed entirely in your browser — nothing is uploaded until you click Import.

The Import Wizard

The import process follows a four-step wizard. For JSON files, the header selection step is skipped automatically.

  1. 1
    Upload File

    Select or drag your file. Legitski detects the format and parses it immediately.

  2. 2
    Select Header Row

    For Excel and CSV, pick which row contains your column headers.

  3. 3
    Map Columns

    Match each file column to an inventory field. Auto-matching uses fuzzy name comparison.

  4. 4
    Preview and Import

    Review the validation summary. Choose to import all rows or valid rows only.

Column Mapping

Legitski automatically matches file columns to your inventory fields using fuzzy name comparison. You can override any mapping before importing.

Column MappingLive Preview
Product NameProduct Name *98%
QtyQuantity *85%
Unit CostCost 72%

Creating new columns

If your file contains columns that do not match any existing inventory field, you can create new columns directly from the mapping step. Each new column will be added to your schema after import.

Data Validation & Sanitization

Before importing, Legitski validates every row and sanitizes values that need formatting corrections. You see a full summary before committing.

Preview with ValidationLive Preview
10 Valid 1 With errors 2 Values modified
Product NameQuantityPrice
ThinkPad X114$1999.00
MacBook Air8$1499.00 was $1,499.00
Required5$1249.00
USB-C Hub2$49.99

Required fields

Rows missing required values (such as the product name) are flagged as invalid. You can choose to skip invalid rows and import only the valid ones, or go back and fix your file first.

Permissions & Limits

Import access is restricted by role, and batch sizes are governed by your subscription tier.

Who can import
Only users with the Owner or Boss role can import inventory. Workers and Viewers do not have access to the import wizard.
Batch size limit
Free plan: 100 rows per import. Pro plan: 1,000 rows. Enterprise: unlimited.
Item count limit
Your total inventory count is capped by your plan. The import will stop if adding the new rows would exceed your plan limit.
New columns
Creating new columns during import requires the Owner or Boss role. If you lack permission, unmapped columns are skipped.

Atomic imports

Imports are transactional — either all valid rows are created, or none are. If the batch insert fails, Legitski falls back to inserting rows one at a time so you get as many as possible without losing data.