Completed

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

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.

Skills: Data Processing, Excel, PHP, Software Architecture, Visual Basic

See more: how to merge multiple excel files into one workbook 2010, how to merge excel files into one using cmd, combine multiple excel files into one workbook vba, combine multiple text files into one excel spreadsheet, merge multiple excel files into one sheet vba, merge multiple excel files into one sheet, merge excel files online, combine excel files into one workbook macro, Write a command line program to \ join\ .csv files., write program display flags different countries, write program language excel file open, write program java find average size files folder, write program excel, write java program automatically fill forms, automatically search html page copy paste excel file

About the Employer:
( 1 review ) Sprngfield, United States

Project ID: #17045465

Awarded to:

ianoc

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 More

$100 USD in 3 days
(41 Reviews)
5.4

43 freelancers are bidding on average $125 for this job

rajeshsonisl

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 fro More

$244 USD in 3 days
(919 Reviews)
8.5
KESHAVINFOTECH

Hi There, Thanks for your valuable time. :-) Please check below points : 1. I have more than 5000 folders, in each of which there are three tab files. Each folder represents a company, and each company has thr More

$250 USD in 12 days
(637 Reviews)
8.5
sureshdevi

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 re More

$67 USD in 2 days
(1117 Reviews)
8.0
schoudhary1553

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 Arc More

$250 USD in 3 days
(281 Reviews)
7.6
gangabass

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 statsperda More

$100 USD in 1 day
(429 Reviews)
7.2
chriskerpini

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 c More

$190 USD in 2 days
(97 Reviews)
6.8
$200 USD in 5 days
(227 Reviews)
6.6
avinav606lx

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. P More

$94 USD in 1 day
(165 Reviews)
6.5
sunny945

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 wi More

$100 USD in 3 days
(30 Reviews)
5.3
rinabuoy13

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 in 1 day
(71 Reviews)
5.6
SShtv

I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots of some of my works. [login to view URL] More

$100 USD in 2 days
(58 Reviews)
5.6
netcoder

Hi, I think I can do it!:-) I have a lot of experience in Excel and Visual Basic data processing. Best regards:-)

$155 USD in 3 days
(71 Reviews)
5.7
periyannas

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 in 1 day
(41 Reviews)
5.2
bengulee

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 th More

$155 USD in 1 day
(7 Reviews)
5.1
huongth

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, fo More

$61 USD in 3 days
(31 Reviews)
4.4
TetyanaS

The examples of my codes you can see in my books. I'm the author of this book (VBA and VB .NET): [login to view URL] I conduct lectures and laboratory classes with students in the course “VBA and VB .NET”

$55 USD in 3 days
(23 Reviews)
4.7
sloker18

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 More

$80 USD in 1 day
(27 Reviews)
4.3
Alprn2558

Hi Sir, if you provide me the samples i can start your task within 3-4 hours. Thanks in advance

$111 USD in 1 day
(13 Reviews)
4.5
maximwang8661

nice to meet you. your project is very interesting to me If you hire me, I can start working for you right now. I have a good experience in excel and excel vba. thank you for your job posting.

$155 USD in 3 days
(15 Reviews)
4.6
nurnga1218

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 in 3 days
(38 Reviews)
4.5