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.

The code examples below show how to run the Actor and get its results. To run the code, you need to have an Apify account. Replace <YOUR_API_TOKEN> in the code with your API token, which you can find under Settings > Integrations in Apify Console. Learn more

1import { ApifyClient } from 'apify-client';
2
3// Initialize the ApifyClient with your Apify API token
4const client = new ApifyClient({
5    token: '<YOUR_API_TOKEN>',
6});
7
8// Prepare Actor input
9const input = {
10    "JSON": `[
11            {
12            "title": "Apify: Full-stack web scraping and data extraction platform",
13            "url": "https://apify.com/",
14            "displayedUrl": "https://apify.com",
15            "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 ...",
16            "emphasizedKeywords": [],
17            "productInfo": {},
18            "type": "organic",
19            "position": 1
20            },
21            {
22            "title": "Apify (@apify) · X",
23            "url": "https://twitter.com/apify?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor",
24            "displayedUrl": "https://twitter.com/apify",
25            "description": "",
26            "emphasizedKeywords": [],
27            "siteLinks": [],
28            "productInfo": {},
29            "type": "organic",
30            "position": 2
31            },
32            {
33            "title": "Apify",
34            "url": "https://github.com/apify",
35            "displayedUrl": "https://github.com › apify",
36            "description": "Generic REST API for scraping websites. Drop-in replacement for ScrapingBee, ScrapingAnt, and ScraperAPI services. And it is open-source!",
37            "emphasizedKeywords": [],
38            "siteLinks": [],
39            "productInfo": {},
40            "type": "organic",
41            "position": 3
42            },
43            {
44            "title": "Apify Pricing, Alternatives & More 2024",
45            "url": "https://www.capterra.com/p/150854/Apify/",
46            "displayedUrl": "https://www.capterra.com › Data Extraction Software",
47            "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 ...",
48            "emphasizedKeywords": [
49            "Apify"
50            ],
51            "siteLinks": [],
52            "productInfo": {
53            "rating": 4.8,
54            "numberOfReviews": 150
55            },
56            "type": "organic",
57            "position": 4
58            },
59            {
60            "title": "Apify",
61            "url": "https://cz.linkedin.com/company/apifytech",
62            "displayedUrl": "6.6K+ followers",
63            "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.",
64            "emphasizedKeywords": [
65            "Apify"
66            ],
67            "siteLinks": [],
68            "productInfo": {},
69            "type": "organic",
70            "position": 5
71            },
72            {
73            "title": "Apify Reviews 2024: Details, Pricing, & Features",
74            "url": "https://www.g2.com/products/apify/reviews",
75            "displayedUrl": "https://www.g2.com › ... › Apify › Apify Reviews",
76            "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 ...",
77            "emphasizedKeywords": [
78            "Apify"
79            ],
80            "siteLinks": [],
81            "productInfo": {
82            "rating": 4.8,
83            "numberOfReviews": 112
84            },
85            "type": "organic",
86            "position": 6
87            },
88            {
89            "title": "Apify Tutorial For Beginners | How To Use Apify",
90            "url": "https://www.youtube.com/watch?v=3rrpfW0bEdc",
91            "displayedUrl": "4.9K+ views  ·  9 months ago",
92            "description": "Apify review: https://speakaboutdigital.com/apify-review/ Apify Tutorial For Beginners | How To Use Apify This is my video tutorial on Apify ...",
93            "emphasizedKeywords": [
94            "Apify"
95            ],
96            "siteLinks": [],
97            "productInfo": {},
98            "type": "organic",
99            "position": 7
100            }]`
101};
102
103(async () => {
104    // Run the Actor and wait for it to finish
105    const run = await client.actor("zuzka/json-to-excel").call(input);
106
107    // Fetch and print Actor results from the run's dataset (if any)
108    console.log('Results from dataset');
109    console.log(`💾 Check your data here: https://console.apify.com/storage/datasets/${run.defaultDatasetId}`);
110    const { items } = await client.dataset(run.defaultDatasetId).listItems();
111    items.forEach((item) => {
112        console.dir(item);
113    });
114})();
115
116// 📚 Want to learn more 📖? Go to → https://docs.apify.com/api/client/js/docs
Developer
Maintained by Community
Actor metrics
  • 2 monthly users
  • 2 stars
  • 100.0% runs succeeded
  • Created in Oct 2021
  • Modified about 1 month ago
Categories