Find Jobs
Hire Freelancers

Standardize and Merge Excel Sheets

€8-32 EUR

Completed
Posted over 7 years ago

€8-32 EUR

Paid on delivery
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.
Project ID: 12198491

About the project

26 proposals
Remote project
Active 7 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
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 you that all the provided instruction is clear to me and will complete this task on budget and on time as well. If you have any question, please feel free to message me. Regards Mukesh
€32 EUR in 2 days
4.9 (72 reviews)
5.4
5.4
26 freelancers are bidding on average €56 EUR for this job
User Avatar
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 and I am very interested in this project. I can start today. Please message me. By the by, my name is Kal. I promise you quality service with quick job submission time. I am ready to submit a sample work before we agree on the project. My bid for this task is undoubtedly negotiable. Please let me know of any questions or concerns you have regarding my proposal. Many great thanks for the opportunity to work with you on what I am certain will be a conspicuously successful partnership. Sincerely, KalpanaSekhar
€33 EUR in 1 day
5.0 (202 reviews)
8.0
8.0
User Avatar
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
5.0 (94 reviews)
6.1
6.1
User Avatar
A proposal has not yet been provided
€9 EUR in 1 day
4.9 (56 reviews)
5.7
5.7
User Avatar
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
5.0 (96 reviews)
5.8
5.8
User Avatar
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 cracking on it straight away. Payment on completion and satisfaction
€24 EUR in 4 days
5.0 (17 reviews)
4.5
4.5
User Avatar
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 may be waste your time. Let me introduce myself first. I am a professional Graphics Designer along with Web design and Data Entry. I have competency on, Graphics Design based on these fields, Clipping path, Background Removing/Changing/etching, Image editing, Image Optimization for web, Image Enhancement, Portrait Retouching, Image Manipulation, Photo Restoration, Photo Retouch, Hair Masking, Color Correction, Creating Vector Image, Flyer /Brochure Design, Business card, Banner Design etc. And Web Design based on these fields, WordPress, HTML & CSS, PSD to responsive HTML to WordPress etc. I even worked with some clients as a Virtual Assistant and I have done well on all of them. So I can tell you confidently that Admin assistant or virtual admin is also one of my strong skill. Even I am fully expert in web research, extracting email, data mining, Google, Bing, Yahoo, MS Office (Full), Google Docs, Google Document, Google Spreadsheet, Ad words, Analytics, Webmaster, PR, B2B Marketing, Lead Generation, Directory and other related programs. This is a summary of me. You can now take your decision and if has any opportunity then that will be very glad for me. Looking forward to hearing from you. And thanks a lot for your response. Thanks once again.
€10 EUR in 1 day
5.0 (8 reviews)
3.8
3.8
User Avatar
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 in less than 1 day. I can assure you that all the data will be accurately entered. Please provide me a sample to test my accuracy & time taken to complete the task. If you are satisfied with the sample you can then award me your project. I am looking forward for your reply. Please feel free to contact me. You can also check my profile here: https://www.freelancer.com/u/vishnuteja74.html Respectfully, Vishnu Teja
€19 EUR in 1 day
4.6 (2 reviews)
0.8
0.8
User Avatar
I am very good knowledge in data entry. My Speed 40-45 WPM. Very familiar with keyboard, ms office, excel. I can complete your project before your time limit. Hire me
€19 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
is there any specific order of the sheets Like 2 types of order 3 types or 4 types or its always random
€400 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello My Dear Client My name is Baran. I am an excel specialist. I am good at data analysis, serach and selections, combining and seperating tasks. I utllize VBA scripts. I am free to work for you Have a shiny day Regards
€34 EUR in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Greeting! My name is Nor sahela . I am new freelancer and I ‘m full time typist at home. I am also good in data entry. I would like apply this job to enhance my skill. I am hardworking, disciplined and dedication person .I can help you to complete the project. I believe communication is key to any successful project .So, my suggesting is we can communicate via email. I hope you will consider me for this project too. I will manage my time properly to complete the task .Really looking forward to receive a positive reply from you soon .Thank you for your time and consideration.
€25 EUR in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
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. Please let me know, if there are any more details to know, and also I am ready to start with this task immediately. And before starting would just like to have a small conversation to know few fields in the excel sheet, so that I would be aware that we both are on the same page. I have gone through your examples also, and am pretty sure about the output you want to have. Thanks
€30 EUR in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear Employer, I am an Executive Assistant by profession for the last 15 years and assisted top management like CEO, country head, business head etc. My core area skills are assisting IT tools, excel expert, word and ppt expertise, database management, data mining, research activities, presentations etc. Please check my profile so that you would be able to have a detailed info about me. I am here to earn golden stars to my profile by giving quality job so the amount can be fixed by you as you feel appropriate. Thanks Savitha
€44 EUR in 1 day
0.0 (2 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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.0 (0 reviews)
0.0
0.0
User Avatar
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 their manual efforts.
€23 EUR in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SWITZERLAND
Zurich, Switzerland
5.0
1
Payment method verified
Member since Nov 26, 2016

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.