Excel Parser Processor Burak Targaç
winget install --id=btargac.excel-parser-processor -e Does the tedious processing over all items of a given excel file by converting the rows to an array and process all items of that array recursively
Excel Parser Processor is a desktop application designed to automate repetitive tasks involving Excel files. It processes each row of an Excel file as an array of items, executing predefined operations sequentially until all items are processed. This tool simplifies workflows such as downloading files from URLs listed in an Excel file.
Key Features:
- Downloads assets (images, text files, PDFs, etc.) from URLs specified in column A of the Excel file.
- Renames downloaded files using custom filenames provided in column B.
- Creates subfolders for organized storage based on folder names entered in column C.
- Handles large datasets efficiently, with no practical limit to the number of items processed.
Audience & Benefit: Ideal for professionals and teams needing to automate bulk operations involving Excel data. It saves time by eliminating manual repetitive tasks, ensuring consistent processing of files, and organizing results into a structured directory system. The tool can be installed via winget for seamless integration into workflows.
README
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]
Sponsors
Support this project by becoming a sponsor. Your logo will show up here with a link to your website. [Become a sponsor]
License
MIT © Burak Targaç