> ## Documentation Index
> Fetch the complete documentation index at: https://docs.lanternhq.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Upload Min/Max targets from a spreadsheet

> Apply different Min/Max targets to many items from a CSV or Excel file. Match columns, choose an expiration, and check the saved overrides.

When you already have agreed Min/Max targets in a spreadsheet, upload them to
Lantern together instead of opening each item. For example, you may have
reviewed a list of products for a customer commitment and chosen a different
Min and Max for each one.

An upload saves those quantities as **overrides**. They hold your chosen
targets until their expiration or until you change or remove them. Use an end
date for a temporary commitment so you can return to Lantern's recommendations
afterward.

## Choose the quickest way to make the change

| What you want to do | Use |
| - | - |
| Save different Min/Max quantities for each item and location. | Upload a spreadsheet using the steps below. |
| Hold each item's current or recommended targets, apply one exact pair, or adjust current targets by a percentage. | Select or filter the items and use the toolbar **[Override](https://docs.lanternhq.com/guides/overrides-and-boundaries.md#can-i-change-several-items-at-once)**. |
| Accept a group of Lantern's recommendations. | **[Bulk approve](https://docs.lanternhq.com/getting-started/first-review.md#2-approve-small-changes-in-groups)** the reviewed items. |

## Prepare your file

Use a **CSV or XLSX** file, with one row for each item and location you want to
change. Keep item and location IDs as text in Excel so leading zeros stay intact.
Keep only the rows you want to change: hidden and filtered-out Excel rows are
included in the import. See [file requirements](https://docs.lanternhq.com/reference/file-imports.md#file-requirements)
for accepted dates, numbers, and formulas.

| Field in Lantern | What to provide |
| - | - |
| **Item ID** | The item's ID in Lantern. |
| **Location ID** | The location's ID, or choose one location for all rows during column matching. |
| **Minimum** | The Min quantity to hold. |
| **Maximum** | The Max quantity to hold. |
| **Reason** | Why these targets are needed, from a column or one reason for all rows. |
| **Expiration** | An end date or **Permanent**, from a column or one choice for all rows. |

Include both Minimum and Maximum on every row, even when updating an existing
override. Zero is a valid quantity; quantities must be nonnegative and Minimum
cannot exceed Maximum. Lantern rounds each quantity to a whole unit. Use each item/location pair only once in the file.

Your column names do not need to match Lantern's labels. You choose which
columns supply each field before applying the changes.

## Upload and review

1. Open **Min/Max**, also called **Order/Line Points** in some workspaces, and
   drag your file onto the table.
2. In **Match your columns**, choose the worksheet to import if the workbook
   has more than one. Check **First row is column names** against your file.
3. Match your item, Minimum, and Maximum columns. For location, reason, and
   expiration, choose a file column or a shared value for all rows.
4. Choose the duration deliberately. **Expiration** starts as **Permanent**
   when no expiration column is detected. Use **Specific date** for a temporary
   commitment, or map a column containing the end dates.
5. Review the sample rows, including the item IDs, locations, quantities, reason,
   and expiration. Confirm that the file contains only the items you intend to
   change, then select **Start import**.

Uploading and matching columns lets you review the file before you start the
import. Once started, its rows are saved as overrides. For an item/location
that already has an active override, the uploaded values replace it. A saved
row also shows its item/location on Min/Max again if it was hidden. Where your
account can add items to locations, a row for an item/location Lantern does
not have yet adds it.

## Check the result and put it into use

Check the **Updated**, **Failed**, and any **Duplicates skipped** counts.
If some rows failed, [correct and upload them again](https://docs.lanternhq.com/reference/file-imports.md#correct-failed-rows).

Return to Min/Max and check the affected targets and **Override History**.
Saved overrides may take a few minutes to appear on the dashboard. Use history
to review their values, reason, and expiration, or to edit or remove them later.

The upload saves overrides in Lantern. To carry the reviewed targets into your
buying process, follow **[Apply reviewed targets](https://docs.lanternhq.com/guides/min-max.md#apply-reviewed-targets)**.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.