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.

.actor/INPUT_SCHEMA.json

1{
2  "title": "Transform json to different formats.",
3  "type": "object",
4  "schemaVersion": 1,
5  "properties": {
6    "JSON": {
7      "title": "JSON",
8      "type": "string",
9      "description": "Paste your JSON here.",
10      "editor": "textarea",
11      "prefill": "[\n    {\n    \"title\": \"Apify: Full-stack web scraping and data extraction platform\",\n    \"url\": \"https://apify.com/\",\n    \"displayedUrl\": \"https://apify.com\",\n    \"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 ...\",\n    \"emphasizedKeywords\": [],\n    \"productInfo\": {},\n    \"type\": \"organic\",\n    \"position\": 1\n    },\n    {\n    \"title\": \"Apify (@apify) · X\",\n    \"url\": \"https://twitter.com/apify?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor\",\n    \"displayedUrl\": \"https://twitter.com/apify\",\n    \"description\": \"\",\n    \"emphasizedKeywords\": [],\n    \"siteLinks\": [],\n    \"productInfo\": {},\n    \"type\": \"organic\",\n    \"position\": 2\n    },\n    {\n    \"title\": \"Apify\",\n    \"url\": \"https://github.com/apify\",\n    \"displayedUrl\": \"https://github.com › apify\",\n    \"description\": \"Generic REST API for scraping websites. Drop-in replacement for ScrapingBee, ScrapingAnt, and ScraperAPI services. And it is open-source!\",\n    \"emphasizedKeywords\": [],\n    \"siteLinks\": [],\n    \"productInfo\": {},\n    \"type\": \"organic\",\n    \"position\": 3\n    },\n    {\n    \"title\": \"Apify Pricing, Alternatives & More 2024\",\n    \"url\": \"https://www.capterra.com/p/150854/Apify/\",\n    \"displayedUrl\": \"https://www.capterra.com › Data Extraction Software\",\n    \"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 ...\",\n    \"emphasizedKeywords\": [\n    \"Apify\"\n    ],\n    \"siteLinks\": [],\n    \"productInfo\": {\n    \"rating\": 4.8,\n    \"numberOfReviews\": 150\n    },\n    \"type\": \"organic\",\n    \"position\": 4\n    },\n    {\n    \"title\": \"Apify\",\n    \"url\": \"https://cz.linkedin.com/company/apifytech\",\n    \"displayedUrl\": \"6.6K+ followers\",\n    \"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.\",\n    \"emphasizedKeywords\": [\n    \"Apify\"\n    ],\n    \"siteLinks\": [],\n    \"productInfo\": {},\n    \"type\": \"organic\",\n    \"position\": 5\n    },\n    {\n    \"title\": \"Apify Reviews 2024: Details, Pricing, & Features\",\n    \"url\": \"https://www.g2.com/products/apify/reviews\",\n    \"displayedUrl\": \"https://www.g2.com › ... › Apify › Apify Reviews\",\n    \"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 ...\",\n    \"emphasizedKeywords\": [\n    \"Apify\"\n    ],\n    \"siteLinks\": [],\n    \"productInfo\": {\n    \"rating\": 4.8,\n    \"numberOfReviews\": 112\n    },\n    \"type\": \"organic\",\n    \"position\": 6\n    },\n    {\n    \"title\": \"Apify Tutorial For Beginners | How To Use Apify\",\n    \"url\": \"https://www.youtube.com/watch?v=3rrpfW0bEdc\",\n    \"displayedUrl\": \"4.9K+ views  ·  9 months ago\",\n    \"description\": \"Apify review: https://speakaboutdigital.com/apify-review/ Apify Tutorial For Beginners | How To Use Apify This is my video tutorial on Apify ...\",\n    \"emphasizedKeywords\": [\n    \"Apify\"\n    ],\n    \"siteLinks\": [],\n    \"productInfo\": {},\n    \"type\": \"organic\",\n    \"position\": 7\n    }]"
12    }
13  },
14  "required": ["JSON"]
15}

.actor/actor.json

1{
2  "actorSpecification": 1,
3  "name": "json-to-excel",
4  "title": "JSON to EXCEL",
5  "description": "Changes JSON into dataset",
6  "version": "0.0.1",
7  "storages": {
8      "dataset": {
9          "actorSpecification": 1,
10          "title": "Instagram Scraper",
11          "description": "Too see all scraped properties, export the whole dataset or select All fields instead of Overview",
12          "views": {}
13    }
14  }
15}

.gitignore

1# This file tells Git which files shouldn't be added to source control
2
3.idea
4node_modules

Dockerfile

1# First, specify the base Docker image. You can read more about
2# the available images at https://sdk.apify.com/docs/guides/docker-images
3# You can also use any other image from Docker Hub.
4FROM apify/actor-node:16
5
6# Second, copy just package.json and package-lock.json since it should be
7# the only file that affects "npm install" in the next step, to speed up the build
8COPY package*.json ./
9
10# Install NPM packages, skip optional and development dependencies to
11# keep the image small. Avoid logging too much and print the dependency
12# tree for debugging
13RUN npm --quiet set progress=false \
14 && npm install --only=prod --no-optional \
15 && echo "Installed NPM packages:" \
16 && (npm list --all || true) \
17 && echo "Node.js version:" \
18 && node --version \
19 && echo "NPM version:" \
20 && npm --version
21
22# Next, copy the remaining files and directories with the source code.
23# Since we do this after NPM install, quick build will be really fast
24# for most source file changes.
25COPY . ./
26
27# Optionally, specify how to launch the source code of your actor.
28# By default, Apify's base Docker images define the CMD instruction
29# that runs the Node.js source code using the command specified
30# in the "scripts.start" section of the package.json file.
31# In short, the instruction looks something like this:
32#
33# CMD npm start

apify.json

1{
2    "env": { "npm_config_loglevel": "silent" }
3}

main.js

1// Import Apify SDK. For more information, see https://sdk.apify.com/
2const Apify = require('apify');
3
4Apify.main(async () => {
5    const input = await Apify.getInput();
6    const data = JSON.parse(input.JSON);
7    console.log(data)
8    await Apify.pushData(data);
9});

package.json

1{
2    "name": "example-hello-world",
3    "version": "0.0.1",
4    "description": "This is an example of an Apify actor.",
5    "dependencies": {
6        "apify": "^2.0.7"
7    },
8    "devDependencies": {},
9    "scripts": {
10        "start": "node main.js",
11        "test": "echo \"Error: oops, the actor has no tests yet, sad!\" && exit 1"
12    },
13    "author": "It's not you it's me",
14    "license": "ISC"
15}
Developer
Maintained by Community
Actor metrics
  • 3 monthly users
  • 2 stars
  • 100.0% runs succeeded
  • Created in Oct 2021
  • Modified 4 months ago
Categories