Find Jobs
Hire Freelancers

Insert file and folder name in Excel .csv columns

€8-30 EUR

Completed
Posted almost 6 years ago

€8-30 EUR

Paid on delivery
I need an Excel script (exe) that allow me to add to the second column the name of the file and to the third column the name of the folder in wich the file is. For example: 1 - I have a folder named "main_folder". 2 - This folder contains 900 files .csv named: file1, file2, file3.....file900 3 - The first column of each .csv file has a variable number of items; for example file1 has 700 items (700 rows); file2 900 items, etc. I need an executable that allow me to: 1 - select a folder (containing the .csv files); for example select the folder "main_folder" that contains 900 .csv files 2 - click on a button and fill the second column of each file with the name of the file; for example the file named "[login to view URL]" has 700 items (one for row) in the first column; I want a function that, when I press a button, fill the 700 rows of the second empty column with its name ("file1" in this case), and so on for all other 899 files. 3 - click on a second button and fill the third column of all 900 files in the folder with the name of the folder; in the previous example, when I click on the 2nd button, the function fill the rows of the third empty column with the name of the folder ("main_folder" in this case). The script must be fast and functional with large amount of data.
Project ID: 17033733

About the project

27 proposals
Remote project
Active 6 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
dear Sir, I can write c# application to complete your task. It is scalable. Looking to hearing from you soon. Kind regards
€30 EUR in 1 day
4.9 (86 reviews)
5.9
5.9
27 freelancers are bidding on average €29 EUR for this job
User Avatar
I am an excel expert. I love excel automation. Clear instructions. I can write a macro for this project. I understand the task completely and I will complete this with highest accuracy and speed. ZERO ERROR GUARANTEED!! Please read my 350+ reviews. I am here to impress you with my work.
€100 EUR in 1 day
4.9 (315 reviews)
7.6
7.6
User Avatar
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
€50 EUR in 2 days
4.9 (116 reviews)
6.6
6.6
User Avatar
Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in getting this task done with more focus on quality and getting it delivered on time. Hoping to serve you in the best possible manner and completing it to your level of satisfaction. Looking forward to work for you. Hope to hear from you. Have a nice day. Regards, Nidhi
€23 EUR in 1 day
4.8 (110 reviews)
6.1
6.1
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.
€30 EUR in 1 day
5.0 (66 reviews)
5.7
5.7
User Avatar
Hi, I can write the tool you want in Visual Basic 6, exactly as you describe. I could also add option to create a copy of all the csv files instead of overwriting them, just to be super safe. Could also implement those two modes as checkboxes , allowing you to do both operations in a single pass, if you want to. The small application can be done in less than a day, but just to be on the safe side, let's say maximum 2 days. If you have any questions, please let me know. I would also be available through chat, and I'm willing to make small tweaks and changes after you accept the project, so you can be sure you'll be 100% satisfied with my work. Marius Hudea
€20 EUR in 2 days
5.0 (165 reviews)
5.4
5.4
User Avatar
Hi, You won’t make the right candidate selection without knowing what your project on writing Excel script that allows you to add to the second column the name of the file and to the third column the name of the folder in which the file is. will look like. Fortunately, I can show you how your job will look like before you award the project. Before you award this project, I can complete a part of this project as a sample. This is so that you can be confident of the hands you will entrust this task. Please refer to my reviews to see why all my clients love my job. Do you want me to start working on the sample?
€30 EUR in 1 day
4.7 (33 reviews)
5.5
5.5
User Avatar
Hello I suggest to implement you a solution in java(exe) I can assure the best results thank you in advance
€24 EUR in 1 day
4.7 (36 reviews)
5.4
5.4
User Avatar
Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, format txt, csv, xls, xlsx, doc, docx, rtf, json, xml, database files as you request. I can start right now
€29 EUR in 1 day
4.9 (29 reviews)
4.3
4.3
User Avatar
HI, I can help in this by creating small web based software, where you may create nay pattern for csv, Please let me know when w can discuss. Looking forward for your response. Thanks.
€34 EUR in 1 day
4.9 (7 reviews)
3.5
3.5
User Avatar
Hi. 2 questions: 1- What would you like the delimeter to be in your csv files? 2- While I can do the column adding the way you described it (adding to the files directly), would you prefer instead to have the result be one new file that has all data consolidated with the 2 new columns included, leaving the original files untouched? Since the data is in csv format I can do this task using PowerShell scripting. That way you can see script for yourself and not worry about any suspicious EXEs. The script will do all the processing independently of Excel. Let me know if you are interested.
€30 EUR in 1 day
5.0 (2 reviews)
1.6
1.6
User Avatar
Dear next Employer We will give you the best result by using my past experience and excellent academic skills on your project. You can chat with me and let's get started, I'm ready to show you samples of similar projects I've completed. Thanks
€16 EUR in 1 day
4.8 (2 reviews)
0.9
0.9
User Avatar
l can do it 1 hour its very easy and fast lets do it and i have 5 years experience in data entry so i need this so much
€19 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a mom with two kids. I believe that your company will help me sustain the needs of my kids. I am willing to learn everything. Thank you. Relevant Skills and Experience Inserting a file inside q cell of a spreadsheet where you want to insert the object.
€19 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am expert in excel and have advance excel reporting workshop training certificates. Please feel free to contact with me so I would be able to start your work in a way you like.
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of ITALY
ROMA, Italy
5.0
3
Payment method verified
Member since Mar 23, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.