Find Jobs
Hire Freelancers

Write a program to automatically append tab files in different folders into Excel files

$30-250 USD

Terminado
Publicado hace casi 6 años

$30-250 USD

Pagado a la entrega
I have more than 5000 folders, in each of which there are three tab files. Each folder represents a company, and each company has three tab files: comments, fullstats, and statsperday. I need a program (VBA or something like that) to automatically grab tab files from each folder and append them together by their types. Not only that, I need the folder's name to be included in each data as a separate column. For example, the first folder contains data for a company called 2 K WEB GROUP, its comments data should be appended with other comments data in other folders, so should fullstats and statsperday data. And 2 K WEB GROUP needs to be the first column of the appended data. Final outcome will be three Excel files: comments_all, fullstats_all, and statsperday_all, each of them contains data from all 5740 folders in that type.
ID del proyecto: 17045465

Información sobre el proyecto

37 propuestas
Proyecto remoto
Activo hace 6 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi, I am interested in your project and I can definitely get this done for you better, faster and more neatly than anybody else here. I have an enormous amount of experience in programming and also working with data files and received excellent 5 star ratings for my previous work. Your requirement is quite clear to me but I would like to discuss further to get a better idea of your folder structure and how you want the merging to be done for the 3 files. * Do you have any special reason to use VBA for this? I personally wouldn't use VBA to do this as you would be dealing with a large number of files. I recommend using a standalone VB.Net or C# program or even Python. But I am more than willing to do it in VBA if you insisit. By the way, my schedule is clear right now to start working on your project immediately, so please get back to via project chat if you are interested. Thanks and I look forward to get this job done for you.
$100 USD en 3 días
5,0 (55 comentarios)
6,5
6,5
37 freelancers están ofertando un promedio de $127 USD por este trabajo
Avatar del usuario
Hi there, Can I see samples of the excel tab files? I have a 99% project completion rate and a 4.99 reputation (out of max 5.0 from more than 1120 projects over 11 years. Thanks. I look forward to hearing from you Best Regards, Rajesh Soni.
$244 USD en 3 días
5,0 (995 comentarios)
8,8
8,8
Avatar del usuario
Hello, I can help with you in your project Write a program to automatically append tab files in different folders into Excel files. I have more than 5 years of experience in Data Processing, Excel, PHP, Software Architecture, Visual Basic. We have worked on several similar projects before! We have worked on 300+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$250 USD en 3 días
4,9 (407 comentarios)
8,1
8,1
Avatar del usuario
I will create script to combine all three types in comments, fullstats, and statsperday from each folder and include folder name column inside the excel file. I will complete this work in 2 days. Looking for your reply to start this work immediately. I will be available online from 2 am GMT to 5 pm GMT individual full-time freelancer.
$67 USD en 2 días
5,0 (1210 comentarios)
8,1
8,1
Avatar del usuario
I can create simple GUI program that will allow you to select root folder and output files location. After you click Start button it will process each subfolder in root folder, parse comments, fullstats, and statsperday files and append that data into main output files. I can start right now and complete it in next 15 hours for just $100 and all I need to start is some sample data from you.
$100 USD en 1 día
5,0 (526 comentarios)
7,5
7,5
Avatar del usuario
Hello, My name is Chrys. As you can see from my profile, I have 17+ years experience working with Excel/VBA and 13 years teaching them both (all levels). I can certainly do excellent work with your project. Please contact me to further discuss the details. Looking forward to hear from you, Kind regards, Chrys
$190 USD en 2 días
4,9 (98 comentarios)
6,8
6,8
Avatar del usuario
Hello Sir, I am experienced excel developer. I can help you with this to get those 3 files within 6h looking to hearing from you soon .
$111 USD en 1 día
4,9 (147 comentarios)
6,5
6,5
Avatar del usuario
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.
$75 USD en 1 día
5,0 (123 comentarios)
6,5
6,5
Avatar del usuario
Hello there, This looks feasible and I can do this quickly. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping me to discuss project , timeline and budget. Thanks A
$94 USD en 1 día
4,9 (177 comentarios)
6,5
6,5
Avatar del usuario
I am proficient with macro/VBA development, I can write the macro to append and categorize files into specific workbook as per your specification, feel free to message me if you are interested, looking forward to chat further and work on your project.
$80 USD en 1 día
5,0 (107 comentarios)
6,3
6,3
Avatar del usuario
Hi, I think I can do it!:-) I have a lot of experience in Excel and Visual Basic data processing. Best regards:-)
$155 USD en 3 días
4,9 (72 comentarios)
5,8
5,8
Avatar del usuario
Hi there!I am a professional Software developer and Excel CSV Expert. I have developed many software that combine data from other files into csv files etc. Message me and if you want to discuss your project details with me. i can finish your work in very short amount of time.
$100 USD en 3 días
5,0 (30 comentarios)
5,3
5,3
Avatar del usuario
Hi, I am ready to convert those tab files(csv files) into excels. Put those files into any drop box and share with me. You will get your final three excel in a day. The tool will be based on Java. You will get the source code after completion. Regards Debashish
$155 USD en 1 día
5,0 (8 comentarios)
5,1
5,1
Avatar del usuario
Hi, as your project brief, I think I have an idea to help you. What i need is your folder list and your raw concept about how the excel file will looks like. I'm waiting for your reply. Thank you.
$50 USD en 3 días
5,0 (44 comentarios)
4,6
4,6
Avatar del usuario
I have done a similar project some time ago. Contact me to talk about that and maybe send me an example. Depending on the way you would like to execute this, i could write you an app that you simply drop the files into and it will generate you the desired excel file. best regards Sebastian
$155 USD en 3 días
5,0 (3 comentarios)
4,7
4,7
Avatar del usuario
I worked in many projects with VBA, most of them for web scraping, dashboard, forms. I have the required expertise for your project.
$155 USD en 7 días
4,9 (17 comentarios)
4,4
4,4
Avatar del usuario
Hi Sir, if you provide me the samples i can start your task within 3-4 hours. Thanks in advance
$111 USD en 1 día
5,0 (13 comentarios)
4,5
4,5
Avatar del usuario
Hello, the offer includes maintenance and future, minor changes. I would be happy to do that project for you. Best regards, Michael
$111 USD en 6 días
5,0 (13 comentarios)
4,5
4,5
Avatar del usuario
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
$61 USD en 3 días
4,7 (31 comentarios)
4,5
4,5
Avatar del usuario
Hello, I am an expert in programming with Excel and VBA with experience in data management. I am your best option. Let's do it !!! Best regards.
$50 USD en 5 días
5,0 (1 comentario)
1,7
1,7
Avatar del usuario
Hi, I'm new to Freelancer and am looking to build a good reputation here. I just need to be given an opportunity. I have a versatile skill set working with data and data tools. I would love to do this in vb as quick as possible for you.
$138 USD en 2 días
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Sprngfield, United States
5,0
1
Forma de pago verificada
Miembro desde dic 11, 2017

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.