Standardize and Merge Excel Sheets

In Progress

The project is basically about merging 206 excel files into one. Unfortunately, the layout of columns is not always the same. Therefore, they sometimes need to be standardized before (or after) merging.

In more detail:

I have excel files with FDI statistics for each country in the world, 206 files in total. In each file, there are 4 sheets: Inflows, Outflows, Instock and Outstock. In the end, I need to have only two sheets: one containing the merged information of all the inflow-sheets and one containing all the merged information of the instock-sheets.

As a template, I uploaded two original data files for Aruba and Afghanistan and two files with the merged data of these countries. Please refer to those examples for needed information, layout etc.

Important notes:

The column "FDI to" must be filled in manually. You find the country's name on top of each original sheet.

The country's names in column "FDI from" can be copied from the original tables. But you will sometimes have to delete empty cells in order to bring all the countries into one column.

Be careful: The order of the sheets in the original files is not always the same.

Skills: Data Entry, Excel

See more: macro excel merge sheets, excel merge sheets, automotive quote sheets excel, vbscript excel merge, updating costing sheets excel, vba code update sheets excel, excel merge tab delimted, easy sheets excel, sum multiple sheets excel, work sheets excel work book java, excel merge data photoshop, name sheets excel using vbscript, excel project help needed, excel merge files mail duplicates, computer inventory sheets excel

Project ID: #12198491

Awarded to:


Hi, I have reviewed the project description along with the attached .xlsx file and able to perform this task which require to merging 206 excel files into one according to the provided instruction. I make sure yo More

€32 EUR in 2 days
(19 Reviews)

30 freelancers are bidding on average €51 for this job


Hello There, I can deliver my best service in fulfilling your requirement. Here I am a full-time excel, web research, web scraping, data entry, and email list building freelancer. I did check your requirements More

€33 EUR in 1 day
(124 Reviews)

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 100 works on Freelancer where major More

€70 EUR in 1 day
(71 Reviews)

Hello, I am Excel and VBA expert. I can start now. Please note that I have 100% completion rate and 5-star feedback on 50 projects.

€55 EUR in 2 days
(51 Reviews)

I can complete your requirement on time with good quality results. I am open to work 30Hours/week on this. I am confident that i can deliver best service for you if i am awarded Thanks in advance!

€29 EUR in 1 day
(17 Reviews)

Hey there, Here is an excel expert from Bangladesh. I’ve already finish some big project here in with excellent feedback. I’ve seen your clear job description & eagerly wishing to be a part of your i More

€111 EUR in 3 days
(33 Reviews)

A proposal has not yet been provided

€9 EUR in 1 day
(16 Reviews)

if the issue is actual please clarify next steps i can send first draft for your test within 4H since start More

€30 EUR in 1 day
(3 Reviews)

I am an accountant and a data entry expert with 15+ years of experience. I should be able to complete this task quickly and efficiently and withing the time frame. Please dropbox me the files and i will get crack More

€24 EUR in 4 days
(10 Reviews)

Hello, I have more than ten years experience working full-time with Excel, including manipulation and formatting of data using manual data entry and, wherever feasible, automated (vba-macros) processes to accomplish More

€30 EUR in 3 days
(5 Reviews)

With more than Eight years experience in Accounting, Finance, QuickBooks, Data Entry, Excel, Copy, Typing, Word, Power Point, Web Research, PDF Conversion, Translator, Proposal Writer. I can complete this project with More

€23 EUR in 1 day
(8 Reviews)

Greetings! Hope you will not ignore my resume/cover letter or proposal letter whatever you mean it. Wish you could have spent some time to read this thoroughly. May be this will help you to get an eminent person or ma More

€10 EUR in 1 day
(3 Reviews)
€111 EUR in 4 days
(2 Reviews)

Have very good experience in data entry, content writing, Advance excel sheet & WordPress etc.. Happy to work with you, and give you quality work.

€23 EUR in 1 day
(0 Reviews)

I am Data Entry/Data Processing/excel Expert who knows the value of time, very hard working and always delivers the work on time. My Motive is to make my employer happy without adding additional charges. If you are loo More

€8 EUR in 0 days
(0 Reviews)
€23 EUR in 1 day
(0 Reviews)
€30 EUR in 2 days
(0 Reviews)

Dear Hiring Manager, I would like to apply in your job post. I think that I am the right person for the job. I am quite good at excel. I can apply formulas and get your task done quickly. I can complete the task More

€19 EUR in 1 day
(1 Review)

This can be achieved using excel macro which will read all the files and merge into one excel of your requirement. I have an experience of 9.5 yrs of experience in creating of excel macros which help users to reduce th More

€23 EUR in 1 day
(0 Reviews)

Hi, I have strong experience in automate processes with excel sheets using a VBA programming, so unviable repetitive tasks, i can do quickly.

€23 EUR in 1 day
(0 Reviews)

Hello, I have understood your requirement for merging excel file and you need to have two sheets as Inflows and Instock, For this work, you have 206 files each with four sheets and the same task is to be done. More

€30 EUR in 3 days
(0 Reviews)