> For the complete documentation index, see [llms.txt](https://docs.loopit.co/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.loopit.co/assets/price-overrides-new/csv.md).

# Import and export prices with CSV in the Price Overrides grid

Use this page to export prices from the Price Overrides grid, edit them in a spreadsheet, and import them back into your draft.

Use CSV import and export in the Price Overrides grid when you have lots of different prices to change and it's easier to work in a spreadsheet. You export your prices, edit the file, then import it back into the grid. The grid is separate from the classic **Price overrides** tab. Editing a price doesn't change your live pricing. Your changes stay in a draft until you review and publish them.

## Before you start

* Where: **Settings → Packages**, open your package, then the **Price Overrides** tab (marked **New**).
* Permissions needed: **View packages in the workspace** to see the **Price Overrides** tab, and **Update packages in the workspace** to open the grid and change prices. An admin can turn these on under **Settings → Roles and permissions**, in the **Settings - packages** group.
* Availability: Enabled for selected workspaces. Contact support to request access.
* Importing a file replaces any changes already in your draft. If you want to keep them, publish them before you import.

## Export prices from the Price Overrides grid

Do this to get a file of your current prices that you can edit.

1. At the top left of the grid, choose **Flat Fees**, **Tiered** or **Deposits**. Each file holds one of these.
2. If you only want some prices, narrow down what the grid shows first. The file only includes the categories, items, terms and frequencies the grid is showing. If you tick cars in the grid, the file only includes those cars, plus their categories so you can see where they belong.
3. Click **…** at the top right of the grid, then **Export**.
4. Check the address in **Email**. Your own email address is filled in for you. Then click **Export**.

![Export price overrides dialog with an email address entered and the Export button highlighted](https://2451226423-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FT8x4qsJr8A1IrE3A8r3f%2Fuploads%2Fgit-blob-885cfd728f8c74c360b13a237b98c3ef9852b3f6%2Fprice-overrides-grid-export.png?alt=media)

You see an **Export started** message, and the file arrives by email once it's ready.

## Import a CSV into the Price Overrides grid

Do this when you've finished editing your file and want to bring the new prices into your draft.

1. At the top left of the grid, choose the tab that matches your file: **Flat Fees**, **Tiered** or **Deposits**.
2. Click **…** at the top right of the grid, then **Import CSV**.
3. If you already have changes in your draft, a **You have unsaved changes** message appears. Click **Clear draft and import** to replace your draft with the file, or **Cancel** to keep your draft and stop.
4. Drop your file into the upload window, or choose it from your computer.

![Upload Package Pricing window with the area to drop or choose a CSV or Excel file highlighted](https://2451226423-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FT8x4qsJr8A1IrE3A8r3f%2Fuploads%2Fgit-blob-f90a1f84cc940aab517c27980ee8bb30213f58d9%2Fprice-overrides-grid-csv-upload.png?alt=media)

5. Wait while the grid shows **Checking your file…**. It compares every row with your current prices.
6. Check the summary. It shows how many cars and prices will change, how many are already up to date, and any rows listed under **Rejected — won't be imported**, with the reason for each.
7. If the file changes prices you've already edited in your draft, choose **Keep my table edits** or **Use the CSV's values**.
8. Click the button that adds the changes to your draft. It shows how many cars will change, for example **Draft Changes to 10 Assets**. To stop instead, click **Cancel import**.

A message confirms the changes were added, and the **Review changes to publish** panel opens so you can check the imported prices.

## Result and recap

The prices from your file are in your draft, and the package name shows **Unsaved changes**. Customers keep seeing the old prices until you publish.

## Related pages

* [Edit prices in the Price Overrides grid](https://docs.loopit.co/assets/price-overrides-new/edit-prices.md)
* [Review and publish price changes in the Price Overrides grid](https://docs.loopit.co/assets/price-overrides-new/review-publish.md)
* [Price Overrides grid overview](https://docs.loopit.co/assets/price-overrides-new/grid-overview.md)
