{"section":"known-issues","requestedLocale":"en","requestedSlug":"masterdata-worksheet-importexport-returning-timeout","locale":"en","slug":"masterdata-worksheet-importexport-returning-timeout","path":"docs/en/known-issues/Storage/masterdata-worksheet-importexport-returning-timeout.md","branch":"main","content":"## Summary\n\n\nWhen exporting and/or importing an entity, a timeout may occur in the following scenarios:\n\n- Entity with many fields;\n- A certain field with too much information;\n- Many documents in the entity.\nThese scenarios can lead to a very large file size, burdening the worker who exports/imports the documents to the file/database, resulting in a timeout response with an aborted request response.\n\n\n#### Simulation\n\n\nFor **export** case:\n\n- Access Master Data CRM (for example https://my-account-here.vtexcrm.com.br);\n- Access a Form Application with fields that contain a very large amount of data per field (ex: images, videos..);\n- Click on the \"**Export XLS**\" button:\n ![](https://vtexhelp.zendesk.com/attachments/token/p7ycuur8ck3Qtw2zmSUBNDmxE/?name=image.png)\n\n- On \"**Data Export**\" popup, click on \"**Select all fields**\" to check it:\n ![](https://vtexhelp.zendesk.com/attachments/token/IIc8z6df21Cl6djTt5Toz4udk/?name=image.png)\n\n- Go back to the Applications page;\n- Click on the \"**Exports**\" button:\n ![](https://vtexhelp.zendesk.com/attachments/token/NsI7JG4oWcuHAhDewa7PoEx1M/?name=image.png)\n\n- You can follow the request on \"**Export Status**\" (for example: https://my-account-here.vtexcrm.com.br/ExportStatus/Index);\n- The email will not be sent to the user.\n\nFor **import** case:\n\n- Access Master Data CRM (for example https://my-account-here.vtexcrm.com.br);\n- Click on the \"**Import**\" button:\n ![](https://vtexhelp.zendesk.com/attachments/token/3HUzAWSplEKGFAap3yU0jjmdf/?name=image.png)\n\n- Choose the Data Entity and the .xls file:\n ![](https://vtexhelp.zendesk.com/attachments/token/KFolvCXhUiqAhZV23iKDhTws0/?name=image.png)\n\n- Click on the \"**Import**\" button;\n- The import will start, it will be processing, and then you will be redirected to `Import/ExecuteImport` (for example https://my-account-here.vtexcrm.com.br/Import/ExecuteImport), and the following error will be displayed:\n\n    This page isn’t workingmy-account-here.vtexcrm.com.br took too long to respond.HTTP ERROR 504 ![](https://vtexhelp.zendesk.com/attachments/token/3brNPf70M3FBLGPiVwWsSHx94/?name=image.png)\n\n\n#### Workaround\n\n\nThere are some easy ways to use workarounds in this case.\n\n**Export:**\n**Option 1:** Filter only the documents you need, if you don't need the whole entity:\n ![](https://vtexhelp.zendesk.com/attachments/token/CojS7MzbOiDkaQ9HgdbrxlzHD/?name=image.png)\n\n**Option 2:** Only select the fields you really need, if you don't need the whole entity:\n ![](https://vtexhelp.zendesk.com/attachments/token/pTOU7TEWidoOrtstbDALphW6k/?name=image.png)\n\n**Option 3:** It is possible to export via API. You can follow this documentation Extracting data from Master Data with search and scroll.\n\n**Import:** Separate the spreadsheet to be imported. For example, a worksheet with 60,000 documents, divide it into 6 spreadsheets of 10,000 documents and try to import it again.\nRemember that we don't have an exact number. Dividing the file into up to 10k documents was a suggested example. It will depend on the number of fields/columns, the size of each information in the field/column, the file size, the worker, etc. There are some factors that can affect the expected import."}