excel parser processor

Automate Excel downloads in seconds. Simply does the tedious, repetitive operations for all rows of excel files step by step and reports after the job is done. It can download files from URL(s) in a column of Excel files. If a new filename is provided at column B it will rename the file before saving. It will even create sub folders if column C is filled with a valid folder name.

btargac

190

JavaScript

Excel Parser Processor

A Desktop app for processing all rows of Excel files

Simply generates an array of items from the rows of an Excel file and does the repetitive tedious operations step by
step till every item of the array is processed. For example downloads all the assets from the URLs from column A in an
Excel file.

How to use

You can download the latest release for your operating system
or build it yourself (see Development).

Just select or drag & drop an Excel file, then select the output folder for the downloaded images or files. All the items
in the Excel file will be downloaded into the selected folder, and you will be notified about the state of ongoing progress.

Sample Excel file structure

	A (resource to download)	B (new filename if used)	C (subfolder name)
1	https://www.buraktargac.com/sample_image.gif	optional-sample-file-name	optional-sub-folder-name
2	https://www.buraktargac.com/sample_image.png	optional-sample-file-name	optional-sub-folder-name
3	https://www.buraktargac.com/sample_image.jpg
.	…
.	…
n	Asset URL (any type of file image, text, pdf etc.)

Currently, there is no limit for n, I tested with 4000 items and unless your IP is banned from the publisher there
is no problem to download as much as you can.

Demo

Development

You need to have Node.js installed on your computer in order to develop & build this app.

$ git clone https://github.com/btargac/excel-parser-processor.git
$ cd excel-parser-processor
$ npm install
$ npm run build
$ npm start

If you are changing the view or renderer related things, you can use Webpack’s watch feature with

$ npm run start-renderer-dev

After running this command, you’ll see a webpack process watching your files after a new renderer.bundle.js is generated
you can refresh the Excel parser processor app window with cmd + R or ctrl + R depending on your system.

To generate binaries on your computer after your development is completed, you can run;

$ npm run dist

This will add binaries under /release folder on your project folder.

/release folder is ignored at the repository. Github Actions will be building the binaries after your branch is merged with master.

Contributors

This project exists thanks to all the people who contribute. [Code of Conduct].

Backers

Thank you to all our backers! 🙏 [Become a backer]