Json To Excel
Try for free
No credit card required
View all Actors
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
2 monthly users
-
2 stars
>99% runs succeeded
Created in Oct 2021
Modified 6 months ago
Categories