Json To Excel avatar

Json To Excel

Try for free

No credit card required

View all Actors
Json To Excel

Json To Excel

zuzka/json-to-excel
Try for free

No credit card required

Convert your json into a tabular form, such as CSV, Excel or HTML table fast and easy.

You can access the Json To Excel programmatically from your own Python applications by using the Apify API. You can also choose the language preference from below. To use the Apify API, you’ll need an Apify account and your API token, found in Integrations settings in Apify Console.

1from apify_client import ApifyClient
2
3# Initialize the ApifyClient with your Apify API token
4# Replace '<YOUR_API_TOKEN>' with your token.
5client = ApifyClient("<YOUR_API_TOKEN>")
6
7# Prepare the Actor input
8run_input = { "JSON": """[
9    {
10    \"title\": \"Apify: Full-stack web scraping and data extraction platform\",
11    \"url\": \"https://apify.com/\",
12    \"displayedUrl\": \"https://apify.com\",
13    \"description\": \"Crawls arbitrary websites using the Chrome browser and extracts data from pages using a provided JavaScript code. The actor supports both recursive crawling and ...\",
14    \"emphasizedKeywords\": [],
15    \"productInfo\": {},
16    \"type\": \"organic\",
17    \"position\": 1
18    },
19    {
20    \"title\": \"Apify (@apify) · X\",
21    \"url\": \"https://twitter.com/apify?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor\",
22    \"displayedUrl\": \"https://twitter.com/apify\",
23    \"description\": \"\",
24    \"emphasizedKeywords\": [],
25    \"siteLinks\": [],
26    \"productInfo\": {},
27    \"type\": \"organic\",
28    \"position\": 2
29    },
30    {
31    \"title\": \"Apify\",
32    \"url\": \"https://github.com/apify\",
33    \"displayedUrl\": \"https://github.com › apify\",
34    \"description\": \"Generic REST API for scraping websites. Drop-in replacement for ScrapingBee, ScrapingAnt, and ScraperAPI services. And it is open-source!\",
35    \"emphasizedKeywords\": [],
36    \"siteLinks\": [],
37    \"productInfo\": {},
38    \"type\": \"organic\",
39    \"position\": 3
40    },
41    {
42    \"title\": \"Apify Pricing, Alternatives & More 2024\",
43    \"url\": \"https://www.capterra.com/p/150854/Apify/\",
44    \"displayedUrl\": \"https://www.capterra.com › Data Extraction Software\",
45    \"description\": \"Apify is used by large enterprises, SMEs, and independent developers. The Apify platform lets you turn any website into an API and reliably extract data at any ...\",
46    \"emphasizedKeywords\": [
47    \"Apify\"
48    ],
49    \"siteLinks\": [],
50    \"productInfo\": {
51    \"rating\": 4.8,
52    \"numberOfReviews\": 150
53    },
54    \"type\": \"organic\",
55    \"position\": 4
56    },
57    {
58    \"title\": \"Apify\",
59    \"url\": \"https://cz.linkedin.com/company/apifytech\",
60    \"displayedUrl\": \"6.6K+ followers\",
61    \"description\": \"Apify is a full-stack web scraping and browser automation platform that lets you extract data from websites and automate workflows on the web.\",
62    \"emphasizedKeywords\": [
63    \"Apify\"
64    ],
65    \"siteLinks\": [],
66    \"productInfo\": {},
67    \"type\": \"organic\",
68    \"position\": 5
69    },
70    {
71    \"title\": \"Apify Reviews 2024: Details, Pricing, & Features\",
72    \"url\": \"https://www.g2.com/products/apify/reviews\",
73    \"displayedUrl\": \"https://www.g2.com › ... › Apify › Apify Reviews\",
74    \"description\": \"One of the best features of Apify is their own free scrapers. They provide a variety of ready-made solutions for common web scraping tasks, such as extracting ...\",
75    \"emphasizedKeywords\": [
76    \"Apify\"
77    ],
78    \"siteLinks\": [],
79    \"productInfo\": {
80    \"rating\": 4.8,
81    \"numberOfReviews\": 112
82    },
83    \"type\": \"organic\",
84    \"position\": 6
85    },
86    {
87    \"title\": \"Apify Tutorial For Beginners | How To Use Apify\",
88    \"url\": \"https://www.youtube.com/watch?v=3rrpfW0bEdc\",
89    \"displayedUrl\": \"4.9K+ views  ·  9 months ago\",
90    \"description\": \"Apify review: https://speakaboutdigital.com/apify-review/ Apify Tutorial For Beginners | How To Use Apify This is my video tutorial on Apify ...\",
91    \"emphasizedKeywords\": [
92    \"Apify\"
93    ],
94    \"siteLinks\": [],
95    \"productInfo\": {},
96    \"type\": \"organic\",
97    \"position\": 7
98    }]""" }
99
100# Run the Actor and wait for it to finish
101run = client.actor("zuzka/json-to-excel").call(run_input=run_input)
102
103# Fetch and print Actor results from the run's dataset (if there are any)
104print("💾 Check your data here: https://console.apify.com/storage/datasets/" + run["defaultDatasetId"])
105for item in client.dataset(run["defaultDatasetId"]).iterate_items():
106    print(item)
107
108# 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/python/docs/quick-start

Json To Excel API in Python

The Apify API client for Python is the official library that allows you to use Json To Excel API in Python, providing convenience functions and automatic retries on errors.

Install the apify-client

pip install apify-client

Other API clients include:

Developer
Maintained by Community
Actor metrics
  • 2 monthly users
  • 2 stars
  • 96.7% runs succeeded
  • Created in Oct 2021
  • Modified 5 months ago
Categories