Find Jobs
Hire Freelancers

Insert file and folder name in Excel .csv columns

€8-30 EUR

Completato
Pubblicato quasi 6 anni fa

€8-30 EUR

Pagato al completamento
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.
Rif. progetto: 17033733

Info sul progetto

27 proposte
Progetto a distanza
Attivo 6 anni fa

Hai voglia di guadagnare un po'?

I vantaggi delle offerte su Freelancer

Imposta il tuo budget e le scadenze
Fatti pagare per il lavoro svolto
Delinea la tua proposta
La registrazione e le offerte sui lavori sono gratuite
Assegnato a:
Avatar dell'utente
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 giorno
4,9 (86 valutazioni)
5,9
5,9
27 freelance hanno fatto un'offerta media di €29 EUR
Avatar dell'utente
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 giorno
4,9 (315 valutazioni)
7,6
7,6
Avatar dell'utente
I can do it for you quickly and exactly . Please contact me for saving your time and your money .
€50 EUR in 2 giorni
4,9 (116 valutazioni)
6,6
6,6
Avatar dell'utente
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 giorno
4,8 (110 valutazioni)
6,1
6,1
Avatar dell'utente
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 giorno
5,0 (66 valutazioni)
5,7
5,7
Avatar dell'utente
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 giorni
5,0 (165 valutazioni)
5,4
5,4
Avatar dell'utente
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 giorno
4,7 (33 valutazioni)
5,5
5,5
Avatar dell'utente
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 giorno
4,7 (36 valutazioni)
5,4
5,4
Avatar dell'utente
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 giorno
4,9 (29 valutazioni)
4,3
4,3
Avatar dell'utente
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 giorno
4,9 (7 valutazioni)
3,5
3,5
Avatar dell'utente
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 giorno
5,0 (2 valutazioni)
1,6
1,6
Avatar dell'utente
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 giorno
4,8 (2 valutazioni)
0,9
0,9
Avatar dell'utente
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 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 giorno
0,0 (0 valutazioni)
0,0
0,0
Avatar dell'utente
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 giorno
0,0 (0 valutazioni)
0,0
0,0

Info sul cliente

Bandiera: ITALY
ROMA, Italy
5,0
3
Metodo di pagamento verificato
Membro dal mar 23, 2018

Verifica del cliente

Grazie! Ti abbiamo inviato tramite email il link per richiedere il tuo bonus gratuito.
Non è stato possibile inviarti l'email. Riprova per piacere.
di utenti registrati di lavori pubblicati
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Caricamento anteprima
Autorizzazione per la geolocalizzazione concessa.
La tua sessione è scaduta ed è stato effettuato il log out. Accedi nuovamente per piacere.