Format CSV Files

£40-120 GBP

Closed

Posted

about 1 year ago

£40-120 GBP

Paid on delivery

Hi, I have downloaded 2 very large (500mb) CSV files. The formatting is not correct, therefor I need someone to be able to convert them to CSV so the columns are separate. Please note due to the size, Microsoft excel will not load all the data so the successful freelancer needs to endure that all data is included. Upon successful formatting of the data, please include the following columns: 1: Address 2: Decription 3: Valuation (current rateable value) 4: Valuations (all historic data) 5: Effective Date 6: Rateable Value 7: Description 8: Local council 9: Local council reference 10: Rating list 11: Effective date 12: List alteration date 13: Transitional relief certificate issued 14: Special category code Please refer to the attached print screens to show the data from individual records. The 2 x CSV downloads should include the same data. The 2 x CSV files are here: [login to view URL]:u:/g/personal/b_middlebrook_callsuk_co_uk/EcJjZmNgRnxJqES3W7EG6yQBL0TfjBQdfOl_I-H9Mgnalw?e=4P2LzB [login to view URL]:u:/g/personal/b_middlebrook_callsuk_co_uk/ETpdpChuZOdOgTIyPTwXRzABT2nkoXZepj9rfkzgbIVtfw?e=VZd16k

Project ID: 36167070

About the project

97 proposals

Remote project

Active 1 yr ago

Looking to make some money?

Email address

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

97 freelancers are bidding on average £113 GBP for this job

@schoudhary1553

Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 850 + Projects. I have 6 + years of the experience in same kind of projects. I am available almost 24-7 and am very responsive. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 Kindly contact me via chat for further details and discussion. Thank you Sandeep

£150 GBP in 4 days

4.9

(609 reviews)

8.5

@livegoodlife

Hello there I have worked on similar project before, The largest file was about 12GB of data, I made a software to load that file and then filter the data by each column.

£120 GBP in 5 days

4.9

(347 reviews)

8.0

@daniyal3214

I can perfectly assist you with that. I am a professional Excel expert holding years of experience in Pivot Table, Macros, VBA and various advance level tools and functions. I will be happy to discuss in detail.

£45 GBP in 1 day

4.8

(243 reviews)

7.3

@fakharreser

Hi There, I am read and 1st file downloading is in progress. I have lready worked in 6600 documents and it is even larger data set than this. Please contact me, I will complete this work in 2 days. Waiting to see you!

£65 GBP in 2 days

5.0

(74 reviews)

7.3

@hatemfreelance4

Dear Employer, I have checked your project's description and I can be your virtual assistant. I have vast experience in Data Entry and Excel Automation. I can start Your project immediately. With Kind Regards Hatem M.

£80 GBP in 2 days

5.0

(204 reviews)

7.2

@SPARKtechBD

Since 2000 I am working on Visual Basic (VB6 and VB.NET) and MSSQL, and MS Access MDB. Also Excel spread sheet. So more than 20 years of experience in Visual Basic to build any kind of Windows application. I have created Point of Sales, Inventory, Accounting, Back Office, Hardware Controller System, etc. If you need a good delivery of job and move this project to successful then message me, please.

£3,000 GBP in 30 days

5.0

(17 reviews)

6.3

@vsprybhanu

Hi, I can develop Excel VBA Macro as per your requirements. I am experienced Data Analyst and Macro Developer and have done many similar projects. So, can do this job nicely. Ready to start please message me to discuss your project in more details. Thanks, Virendra

£120 GBP in 3 days

4.9

(153 reviews)

6.2

@MamukaB

I have converted one file in excel format already and can show part of the file via chat Hi I can help to do this job and can start work right now. Can do within very short time. Maybe 2-3 hour I have check both files and it's easy job for me I have good experience with working large data sets. I'm working in Distribution company and making reports from 1 500 000 row data everyday Regarding my experience you can check my 100% feedback and reviews I have 16+ year experience of Excel, Excel VBA and Have 100% feedback So, you can trust me. Result will be as you need Best Regards

£40 GBP in 1 day

5.0

(74 reviews)

5.5

@amokhtar70

Hi, I have gone through the Job details and am interested in taking it up. I downloaded the zip file, and I am going to use Python to manipulate data because as you said, Excel will not handle that number of records. I will deliver the required tasks fast and accurately. I’m Ahmed Hassanein. I’ve been working with MS Office since 1997 as a user, developer, and trainer. I've been using formulas, VBA, and macros in Excel since 2004. I completed Excel VBA and Google Sheets Apps Script jobs for happy customers (check my job reviews). I have over 25 years of experience supporting systems and users in the information technology field such as office applications, domain servers, application servers, network security, information systems audit, etc. I would be happy if we connect to talk more about your Job and discuss how I can help you accomplish it. Thank you and kind regards, Ahmed Hassanein

£100 GBP in 3 days

5.0

(35 reviews)

5.2

@GKEvans

Hello, Are these files limited by *s? If so I can help you out. If you want I can have a look at it tomorrow.

£80 GBP in 7 days

5.0

(3 reviews)

4.9

@vw1514518vw

Hi, No worries about the file size, I checked the 2 files, contains 2 millions+ , 9 millions+ records, Ready to correct the CSV files, split it to smaller size if you want,

£40 GBP in 1 day

5.0

(18 reviews)

4.8

@serdaryalcin

Hi, I have several tools in hand, so file size will not be an issue for me. Best Regards, Serdar Yalçın

£60 GBP in 3 days

5.0

(25 reviews)

4.6

@Prgohil89

✅ Excel Expert ✅ Microsoft Office Certifier ✅ Surely Delivery in 5 Days ✅ Immediate Start ✅ Offering you Professional IT Experience in Excel, data mining, web searching, Web scrapping and lead generation with over 5+ years experience working in all domains. What do we offer? ✅ Will update you in excel as you need. ✅ Daily work updates. ✅ Quality Work with 99.99% Accuracy ✅ Always on time ✅ Excellent Support. ⭐ Previous work available on request. I would be glad to bring my skill-set and expertise to work with you on your project. Feel free to send me a message to discuss your project with me, and I will respond right away!!! ? Hard work always appreciated ? Thanks & Regards, Pooja G.

£100 GBP in 5 days

5.0

(15 reviews)

4.4

@eduardoherreral4

Hello, there? I have read the proposal carefully. I would like to write program with python or others to format the csv file with very large size. I will guarantee the quality of the job. I can start right now. Looking forward to hearing from you. Regards. Eduardo H.

£80 GBP in 3 days

5.0

(12 reviews)

4.4

@mdbaserul011

Hello sir, I have read the job description and now ready to start. I will be able to complete your project with the highest quality and accuracy. I Have a team. We are a very hard worker and very punctual. Our main goal is to gain my client's satisfaction by completing a job with 100% accuracy. No need to pay me anything if you are not satisfied with my work. I can complete your project perfectly. Please send me a message so we can discuss further. thank you

£45 GBP in 1 day

5.0

(14 reviews)

4.1

@umairnoor32

Hello Sir, I have read your instructions and I can do it efficiently. Please give me this project. i will never disappoint you regarding your work and I will give you unlimited revisions with 100% quality work. Thanks. Regards, UMAIR

£50 GBP in 2 days

5.0

(55 reviews)

4.3

@abugosia

Hello, I'm Abu Gosia. I'm interesting in your project very well. I'm good in C#, .Net Core, MVC, ASP.NET, Angular.js, Yii2, PHP, Laravel, Codeigneter, Wordpress, Open Cart. I m quite well experienced in these jobs. Let's go ahead with me. Thanks

£80 GBP in 2 days

5.0

(14 reviews)

4.5

@alamineee

Hi, Dear Employer. I am Al.A. I am a Ph.D. backgrounder and professional Excel and data scraper with over 12+ years of experience. I will provide you high-quality Excel file. I have worked on similar projects of Spreadsheets /Excel /Web Scraping /Data Mining/Excel Macros/ Excel VBA/ Capabilities,/ CSV,/ and I can deliver professional excel to tight deadlines. Please feel free to send me a message for a chat to discuss your requirements." Gratefulness " Al. A

£120 GBP in 2 days

4.5

(9 reviews)

4.2

@CodingHelpLine

Hello Sir/Madam I have development experience in various Programming Languages, OOP, Data Structures, Database Driven applications, APIs, Files handling and Data Transformation, ETL and various frameworks. I assure you an excellent solution of your project within the time frame and exactly according to the requirements. Thanks @CodingHelpLine

£80 GBP in 7 days

4.8

(2 reviews)

4.0

@MohamedKamelCS

Hi, I can help you with this task ,I'm expert in data extraction,I will create a python script use to read and convert the files to clean csv files I will give you the script and the final results file I'm also committed to providing efficient and accurate work. To demonstrate my capabilities, I'm happy to share my previous work and start working on your project before you hire me. This way, you can evaluate the results and only move forward with me if you're satisfied. Furthermore, I'm willing to support my work and make myself available for communication as needed. Additionally, I will provide a python script for future use and ensure that you are completely satisfied with the final results. I'm excited about the possibility of working with you and contributing to the success of your project. Please let me know if you have any questions or if you would like to discuss the project further. I'm available to chat at your convenience. Thank you for your time and consideration. Best regards, Mohamed

£50 GBP in 7 days