Large CSV file (800,000+ records) sorted, then split into 20 Excel (xls) files
- or -
Post a project like this3564
$15
- Posted:
- Proposals: 3
- Remote
- #521104
- Awarded
Description
Experience Level: Entry
General information for the business: Large CSV file are just purchased sales leads, that I'll be utilizing in MS Excel
Industry: Business
Description of excel work: The list (CSV file) is a flat record that runs about 800,000 records (rows) which have 24 columns
Column 5 is the SIC Code and I want the list Primary Sorted by this filed, with the secondary sort being Column 1 (Company Name field) I have a temporary active link to Sales Lead site where you can download this 53 MB download I may need to have the Sellers/approval for a 3rd party to access my download probably won't be able to reach them today (July 4th USA holiday)
The required task is download the large CSV file, First sort the records (Col 5 - SIC Code is main sort) then export the records 40,000 at a time into MS Excel, preferably xls format however xlsx is acceptable, please name the filed OH1, OH2, etc...
Extra notes:
Industry: Business
Description of excel work: The list (CSV file) is a flat record that runs about 800,000 records (rows) which have 24 columns
Column 5 is the SIC Code and I want the list Primary Sorted by this filed, with the secondary sort being Column 1 (Company Name field) I have a temporary active link to Sales Lead site where you can download this 53 MB download I may need to have the Sellers/approval for a 3rd party to access my download probably won't be able to reach them today (July 4th USA holiday)
The required task is download the large CSV file, First sort the records (Col 5 - SIC Code is main sort) then export the records 40,000 at a time into MS Excel, preferably xls format however xlsx is acceptable, please name the filed OH1, OH2, etc...
Extra notes:
Brian S.
100% (2)Projects Completed
4
Freelancers worked with
4
Projects awarded
38%
Last project
23 Aug 2015
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies