how-to-fetch-apidata-import-into-excel-without-coding
Home » BLOG » Web development » How to fetch API data and import data into Excel or CSV without coding

How to fetch API data and import data into Excel or CSV without coding

category:  Web development

Previously, I published the “How to fetch API data using cURL and import data into Excel” tutorial. In that tutorial, it requires PHP programming skills (beginner level). In this tutorial, I will share how to fetch API data and import data into the Excel or CSV file without coding. No programming skill is needed. However, this method can not be used in web applications or websites. It uses to help people who just need to extract the API data and import it into Excel or CSV for research purposes.

Prepare Tools

PostMan

If you work on API the PostMan is your tool. It allows you to build and use APIs. It is available on Windows, Mac, and Linux platforms.

Talend API Tester – Free Edition

Talend API Tester is a Chrome extension. Meaning you need to use the Chrome browser and install the Talend API Tester extension on the Chrome browser. If you just want to test the APIs(REST, SOAP, and HTTP APIs), this extension is working fine.

Convert JSON to CSV website

This website is a simple free online tool that allows you to convert the JSON data into CSV or Excel online.

Fake Store API

In this tutorial, I use a fake API from Fake Store API. I use only a User API.

Understand HTTP response status code

In order to work with APIs, you should understand the HTTP response status code which will return back from the server. For example, a 200 status code means a successful request.

Fetch API data

Fetch API data in PostMan

  1. Create new tab.
  2. At the GET method which is a default method, enter your API endpoint. In this tutorial, I use “https://fakestoreapi.com/users” which is the fake API. If you need to use POST, PUT or DELETE methods, you can change it. If you need to pass some parameters such as authenication, you can add via Query Params.
  3. Hit Send button to make a request to server. If the request is success, you will get a 200 status and see the response data in the body section.
  4. Make sure you are at the body section because we want to copy the response data from this section.
  5. Hit copy icon for copying the response JSON data.
postman fetch APIs
Fetch API data in PostMan

Fetch API data in Talend API Tester chrome extension

  1. At GET method which is a default method, enter your API endpoint. In this tutorial, I use “https://fakestoreapi.com/users” which is the fake API. If you need to use POST, PUT or DELETE methods, you can change it. If you need to pass some parameters such as authenication, you can add via Query Paramaters.
  2. Hit Send button to make a request to server.
  3. If the request is success, you will get a 200 status and see the response data in the body section.
  4. At the body section, hit Copy menu.
talend API tester fetch APIs
Fetch API data in Talend API Tester chrome extension

Convert JSON into CSV or Excel file

Now you should have the response JSON data that you already copied from the step above.

  • Next, you just visit the convertcsv website
  • At Step1, choose Enter Data tab and paste your copied response data in there.
paste json data into convert form
Paste the copied response data
  • At Step3, choose JSON to Excel or Convert JSON to CSV as you want. It will let you download the file to your computer. Also, it shows the result in the table to let check before downloading the file.

Wrap Up

This tutorial aims to help people who just want to fetch the API data and extract the data into Excel without coding. I hope you find it useful. That’s it for today.