What you can import
| Import type | Description |
|---|---|
| Products | Your company’s own products with SKUs and attributes |
| Materials | Material inputs and source products from suppliers - unprocessed, processed, or pre-formed |
| Bill of materials (BOM) | Bill of materials linking products to their inputs, with optional supplier and material breakdowns |
| Suppliers | Supplier companies and contacts |
| Locations | Named locations (factories, warehouses, ports) with optional address geocoding |
| Activity data | Purchase and sales transactions for GHG inventory tracking |
| Air travel | Air travel emissions data (flights, distances, classes) |
| Transport | Logistics and freight emissions data |
Supported file formats
Variable accepts the following file formats:| Format | Extension |
|---|---|
| Comma-separated values | .csv |
| Excel spreadsheet | .xlsx |
CSV and XLSX work equally well. For multi-sheet XLSX workbooks, you’ll be prompted to pick which sheet to import. See Troubleshooting for tips on merged cells, hidden rows, and formulas.
Import workflow
The import process follows these steps:Upload file
Choose the import type, set the data source system and decimal separator, and upload your CSV or XLSX file. For multi-sheet XLSX workbooks, pick the sheet to import.
Parse and detect
Variable parses your file and identifies columns. AI-assisted mapping suggests how your columns map to Variable fields.
Key benefits
Bulk creation
Import thousands of products, materials, or activities in a single operation instead of creating them one by one.AI-assisted mapping
Variable uses AI to suggest how your column headers map to Variable fields, reducing manual configuration.Learning from history
The system remembers your previous import mappings. When you import similar files, it automatically applies your past configurations.Idempotent re-imports
Re-importing the same file produces no duplicate data - products are matched by SKU (or by name when no SKU is given) and inputs are deduplicated automatically.This applies to products, materials, suppliers, locations, and BOMs. Activity, air travel, and transport imports are not deduplicated - each row becomes a new record every time. See Import behavior by type for the per-type rules.
Automatic calculations
After import, Variable automatically calculates CO2e footprints wherever it can - which means wherever a dataset is assigned to supply the emission factors. Products and materials that don’t yet have a dataset assigned have nothing to calculate; once you assign one, Variable recalculates automatically.Next steps
- Import behavior by type - What each type creates and when re-imports create new vs. reuse
- Prepare your BOM file - Learn about required and recommended columns
- Upload and map columns - Step-by-step import process
- What happens after upload - Understand how Variable processes your data
- Troubleshooting - Solve common import issues