Find Jobs
Hire Freelancers

Combine Excel Files

$30-250 USD

Completed
Posted almost 12 years ago

$30-250 USD

Paid on delivery
I have a project with two parts that are very similar. The first part of the project has 34 Excel Files that need to be reformatted and then combined and the second project has 100 Excel files that need to be reformatted and then combined. I have attached sample files for review. Part #1 Instructions (SpeakerBureaus .xls Files): 1) Open the .xls file 2) VERY IMPORTANT - Select all of the text by clicking on the box right above the "1" for the first row and to the left of the "A" for the first column. There is a little triangle in that box. Next click on "Format" on the menu, then while on the "Number" tab (the first tab) select "text" from the category list and click OK. It souds like a lot but it is a very quick step. 3) VERY IMPORTANT - Scan all the way down while checking the State column and make sure the state is not missing. If it is missing, fill in the missing state columns with the same state from the other records. All of the states should be the same. 4) Save the file and close. Repeat these steps on the next file in project #1. 5) Once all individual files have been completed, combine the files into one big file and name it [login to view URL] 6) Send me an email with a zip file that contains the combined file and the 34 reformatted files. Project #2 Instructions (Chamber of Commerce .xls Files): 1) Open the .xls file 2) VERY IMPORTANT - Select all of the text by clicking on the box right above the "1" for the first row and to the left of the "A" for the first column. There is a little triangle in that box. Next click on "Format" on the menu, then while on the "Number" tab (the first tab) select "text" from the category list and click OK. It souds like a lot but it is a very quick step. 3) VERY IMPORTANT - Scan all the way down while checking the State column and make sure the state is not missing. If it is missing, fill in the missing state columns with the same state from the other records. All of the states should be the same. 4) Save the file and close. Repeat these steps on the next file in project #2. 5) Once all individual files have been completed, combine the files into one big file and name it [login to view URL] 6) Send me an email with a zip file that contains the combined file and the 100 reformatted files. Pre-Qualify Step (Should take less than 2 minutes): In order to be considered, please combine the two sample files using instructions for part #2. Then post your results so we can confirm that you have completed the work properly before we award the project to you. It is VERY important that all steps are followed and we will check the work and payment will only be made if the steps are followed exactly.
Project ID: 1677182

About the project

10 proposals
Remote project
Active 12 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
Seems like a simple straight forward job. I have time to fulfil the task today. I did the sample files and am ready to continue right away! Hope to hear from you soonest. see PM for the file
$30 USD in 1 day
5.0 (2 reviews)
3.2
3.2
10 freelancers are bidding on average $67 USD for this job
User Avatar
Hi, Ready to start, Please check Inbox for details.
$50 USD in 1 day
5.0 (170 reviews)
7.4
7.4
User Avatar
Consider it done. Check your PM for my bid details.
$100 USD in 2 days
4.9 (330 reviews)
7.6
7.6
User Avatar
Hello, samples are attached in your personal message box. Thank you
$45 USD in 2 days
5.0 (65 reviews)
5.4
5.4
User Avatar
hello, I'm interested to work on this project.
$30 USD in 0 day
4.9 (18 reviews)
4.1
4.1
User Avatar
Hi I am confident to handle this
$37 USD in 15 days
4.4 (22 reviews)
4.8
4.8
User Avatar
Hi, i am ready to work with u
$150 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
hello sir i will do your project in just 5 days Regards Ahsan
$100 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
St. Peters, United States
5.0
42
Payment method verified
Member since Dec 9, 2005

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.