Send the Request
Once you’ve configured the request, if you directly click on “Send” button. Postman will send the request to the API endpoint, and you’ll receive a response in the “Response” section below. If the response is not purely text, then you will see text with some unreadable characters.
In order to avoid this problem, the file needs to be downloaded and viewed in a supporting software such as Microsoft Excel.
To download the file click on dropdown just beside the “Send” button.
- Choose the “Send and Download” option from the dropdown.
- Once, you click on the “Send and Download” option, you will be prompted to save the file, confirm the format of the file. Choose desired location and name (if required), then click on “Save” button.
- Once, your file has been successfully downloaded, you will see a prompt “Downloaded Response” in green on the bottom-right corner indicating the file has been downloaded.
How to Download Excel (.xls) file from API in Postman ?
In this tutorial, we’ll explore the process of downloading Excel (.xls) files from APIs using Postman. Postman, an Application Programming Interface (API) tool, offers a comprehensive suite for API development, testing, and management. While typically used for designing, documenting, and testing APIs, Postman can also facilitate the retrieval of specific file formats like Excel sheets from APIs.
This guide will walk you through the step-by-step process of downloading Excel files using Postman, enabling you to efficiently manage and utilize data retrieved from APIs.