Get All WordPress Tags in Excel (CSV) using WordPress WP API v2

wptags.py

import requests
import csv
import time
from tqdm import tqdm

tags = {}
pages = int(requests.get('https://www.example.com/wp-json/wp/v2/tags').headers['X-WP-TotalPages'])

for i in tqdm(range(pages), ncols=65):
    js = requests.get('https://www.example.com/wp-json/wp/v2/tags?page='+str(i+1)).json()
    for entry in js:
        tags[entry['name']]=entry['slug']
    time.sleep(1)
    
with open("tags.csv", "w", newline='') as f:
    datawriter = csv.writer(f)
    datawriter.writerows(tags.items())

Works like a charm:

Can also be used to get Posts (title, URLs) after a little tweaking.