Importing Your Data

Migrate your existing tool inventory into ToolEquip quickly using our bulk import tools. We support CSV, Excel, and direct API imports.

Preparing Your Data

Before importing, prepare your data in a spreadsheet. Each row should represent one tool or piece of equipment. Here are the recommended columns:

• Name * — Tool name or description (required)
• Category — Tool category for grouping
• Serial Number — Manufacturer serial number
• Model Number — Manufacturer model number
• Location — Where the tool is stored
• Status — Available, In Use, Under Repair, Retired
• Purchase Date — When the tool was purchased
• Purchase Price — Cost of acquisition
• Notes — Additional information

Download our template CSV file to get started with the correct format.

CSV Import

The CSV import is the most common method for bulk data migration:

1. Navigate to Tools > Import > CSV
2. Upload your CSV file
3. Map your columns to ToolEquip fields
4. Preview the imported data
5. Confirm and complete the import

The system validates your data and reports any errors. You can fix issues and retry without losing previously imported records.

Excel Import

For Excel files (.xlsx, .xls), the process is similar to CSV import but supports multiple sheets. Select the sheet containing your tool data, map the columns, and preview before importing.

API Import

For automated or large-scale imports, use our REST API. The API supports creating, updating, and deleting tools programmatically. See our API documentation for endpoints, authentication, and rate limits.

Import Best Practices

• Start small — Import a test batch of 10-20 tools first to verify your data mapping
• Clean your data — Remove duplicates and standardize naming before importing
• Set up locations first — Create your location hierarchy before importing tools with location data
• Use categories — Group similar tools with consistent category names for easy filtering
• Include photos — Add images to your tools after import for visual identification

Handling Import Errors

After each import attempt, you'll receive a detailed report showing:

• Number of records successfully imported
• Records with warnings (imported with issues)
• Records with errors (not imported)
• Detailed error messages for each failed record

Common errors include missing required fields, invalid data formats, and duplicate serial numbers. Fix the issues in your source file and re-import the failed records.