{"section":"troubleshooting","requestedLocale":"en","requestedSlug":"error-when-trying-to-import-skus-via-spreadsheet-in-the-vtex-admin","locale":"en","slug":"error-when-trying-to-import-skus-via-spreadsheet-in-the-vtex-admin","path":"docs/en/troubleshooting/merchandising-and-search/error-when-trying-to-import-skus-via-spreadsheet-in-the-vtex-admin.md","branch":"main","content":"After setting the category tree and adding [product specifications and SKUs](/en/tracks/catalogo-101--5AF0XfnjfWeopIFBgs3LIQ/2NQoBv8m4Yz3oQaLgDRagP#product-specification) to your store, you must complete the values for the specifications you created. In the VTEX Admin, you can do this process manually or using a spreadsheet when [adding products and SKUs](/en/docs/tutorials/adding-sku-specifications-or-fields).\n\nIf you get the message `\"An error occurred in the data writing process. Make sure your worksheet data is consistent with the instructions and try again.\"` when importing SKUs via spreadsheet, this may be due to:\n\n- [Incomplete mandatory SKU specifications.](/en/docs/tracks/specifications-concept-definition)\n- Incorrect file formatting.\n\n## Solution\n\nYou can solve this problem by:\n\n[Changing the file](#solution-changing-the-file): The file must follow specific formatting rules and be saved as an XML spreadsheet in .xls format.\n\n### Solution - Changing the file\n\n1. In the VTEX Admin, go to **Catalog > Import and Export > All Products > Export / Import** and click the **Import** tab.\n2. Click `Click Here` to download the spreadsheet template.\n3. Edit the spreadsheet template with the SKUs you want, following all the recommendations on the [Import and Export](https://cosmetics2.myvtex.com/admin/Site/Relatorio_Skus.aspx) page.\n4. Save the spreadsheet in `.xls` format.\n5. On the same page, under `Upload Import File`, select the file and click `Import`.\n6. Check if the action of importing was successful.\n\nIf the error persists after changing the file, please contact our [Support](https://support.vtex.com/hc/pt-br/signin?return_to=https%3A%2F%2Fsupport.vtex.com%2Fhc%2Fpt-br%2Frequests) team."}