Excel Replicator Tool
The Excel Replicator tool allows users to replicate excel file(s) for a given list of file names.
Sample Usage: Education
Teachers may create a rubric template in an excel file for a given assignment. Suppose the teacher has 100 students, saving as the name of the student will take a very long time and sometimes even overwrite an older file.
The Excel Replicator tool comes in handy in this case. By having a template excel file, in this case, the rubric for an assignment, the teacher has to paste the list of names to generate the excel files.
Upon adding the names of the students in the text file, the teacher needs to run the program, select the rubric template (s) and let the program do its job.
Once the program concludes, the Results folder will have all the Excel files replicated for the given names of students for each rubric selected for replication.
MacOS: Use Wine to run the program.
Note: This free version is not the latest version. Contact us to purchase the latest version and receive 1 free workshop and wiki-how video on how to use this tool.
Tutorial
Disclaimer: Your antivirus may flag the program as unsafe. This is because it is a new software which hasn’t been scanned previously. To run the program, let your antivirus run the program.
Alternatively: Download the (.zip) file and use extract the compressed zip file.
Step 1: Install Excel Replicator (Option 1)
After clicking on the Download Now button above, open the Excel Replicator Installer.exe file.
When asked to allow for the program to make changes – Say Yes. You will then see the installer.
Click on install and and then close the installer. You will now find the software in your Desktop inside the One Click Solutions folder. In this case the name of the folder will be Excel Replicator which will contain the following files:
Step 1: Extract the compressed file (Option 2)
You may extract a compressed file using tools such as WinRAR or 7zip.
Right-click on the Excel Replicator.zip file and click extract or extract to folder.
Step 2: Add names of files to replicate
The next step is to paste the names of the files to make. In this case, the names of your students into the NamesOfFiles.txt text file.
These names will serve as the filenames for the replicated word documents.
Step 3: Have your Excel File Ready
The assumption is, you already have your Word Document that you want to replicate. For this tutorial, we will use the Sample Excel File.xlsx for demonstration purposes.
If you open the document you will see:
Step 4: Run Excel Replicator.exe
Now, we are ready to use the Excel Replicator Program. Double-click or open Excel Replicator.exe (it has the same icon as shown above).
Give it a few seconds up to a minute and you will be shown the File Dialog Box to select the Excel File(s) you want to replicate.
In this tutorial, we will use the Sample Excel File to replicate. Please select your own Excel File to replicate.
Note: You may select more than 1 Excel Files to replicate.
If it is your first time running the program, you will be taken to our Donate Page. We hope you consider donating to keep us going!
Step 5: See Results
To see the files replicated, open the Result folder.
It is recommended to sort by ‘Date Modified’ by clicking on the column. This will help you find the latest replication of your files.
Selecting the top result after sorting, you will see the name of the file you selected for replication as the folder.
Inside the folder, you will see the files replicated as the names provided in the text file earlier.
A quick glimpse inside the files replicated shows the exact same contents as the original excel file used for replication!
Please feel free to leave any comments or questions below.
Also see: Word Replicator
Discover more from One Click Solutions
Subscribe to get the latest posts to your email.