{"section":"tracks","requestedLocale":"en","requestedSlug":"exporting-and-importing-via-a-price-spreadsheet","locale":"en","slug":"exporting-and-importing-via-a-price-spreadsheet","path":"docs/en/tracks/vtex-modules-getting-started/prices-101/exporting-and-importing-via-a-price-spreadsheet.md","branch":"main","content":"Adding prices via spreadsheet is recommended for catalogs with many products that require adding or changing prices in bulk.\n\nThe process is divided in:\n\n1. [Exporting prices](#exporting-prices)\n2. [Importing prices](#importing-prices)\n\n## Exporting prices \n\nThe first step in adding or changing prices for the offered products is to export the prices. The export extracts the prices from the VTEX platform, and you can run up to three exports at the same time.\n\nYou can view the price export history of the last 24 hours. Learn more in the [Tracking export](#tracking-export) section.\n\nFollow the steps below to export the price spreadsheet:\n\n1. In the VTEX Admin, go to *Catalog > Prices > Price List*.\n2. At the top of the screen, click the export icon <i class=\"fas fa-download\"></i>.\n> A sidebar will be displayed.\n3. Under **Select the spreadsheet you want to export**, you must choose from the following options:\n   - **Base prices table (default):** The [base price](/en/docs/tracks/preco-base-definicao-de-conceito) is the SKU reference price for all price tables.\n   - **Fixed price table:** The [fixed price](/en/docs/tracks/fixed-price-concept-definition) overrides the base price even if the price rule is configured.\n   - **Calculated price table:** The final price that will be displayed in the store, which does not include promotions.\n4. Click the `Export table` button.\n> Then, the selected price table will open.\n5. In the file that opened, fill out the rows with the SKU price data. The exported Price Table contains only products with registered prices, products without a price do not appear in the spreadsheet. To better understand the meaning of each field, read our article on [filling out an import spreadsheet's base price fields](/en/docs/tutorials/table-of-base-prices) or [filling out an import spreadsheet's fixed price fields](/en/docs/tutorials/filling-out-an-import-spreadsheets-fixed-price-fields).\n\n> ⚠️ The export of price tables in **XLSX** format is limited to 1,048,576 rows due to an Excel limitation. Exports exceeding this limit will result in an error.\n\nAfter the export is complete, you will receive the spreadsheet in your VTEX store email. You can also download the export by clicking the`Download export` button.\n\n### Tracking export\n\nIn **Tracking your exports**, you can follow in real-time the status of each exported spreadsheet with its percentage of completion, which can vary between 0% and 100%, besides viewing the price export history for the last 24 hours.\n\n## Importing prices\n\nThe second step in adding or changing prices in bulk is to do a price import. The import replaces the old prices with the new ones for your offered products.\n\nThis step is mandatory for adding or changing prices.\n\nAfter filling out the data in the spreadsheet, follow the steps below to import it:\n\n1. In the VTEX Admin, go to *Catalog > Prices > Price List*.\n2. At the top of the screen, click the import icon <i class=\"fas fa-upload\"></i>.\n> A sidebar will be displayed.\n3. Select a **Price List** option.\n4. The **Overwrite all existing prices** option replaces your store's fixed prices with those in your spreadsheet. If any of your store prices are not in the spreadsheet, they will be deleted. Uncheck this option if you want to keep existing fixed prices.\n5. Click the `Import table` button.\n6. Select the completed spreadsheet you want to import.\n7. Click `Open`.\n\nThen, your spreadsheet will have been imported, and your prices will be saved."}