Split CSV / Convert CSV file
- Views 89
What you get with this Offer
* Splitting csv files based on line counts - such as 1000, 2000, and 10000 lines per file.
* Split by column value is available, with potential criteria such as Customer, Category, or Country
whereby for example each Country will their own file.
* Split to XLSX files or a single file with multiple sheets (from a CSV file containing less then 400 000
records)
If needed I will also:
* Remove unneeded columns
* Remove duplicate records
* Remove headers rows from resulting split files if needed (CSV).
* Change the csv output file delimiter if needed (CSV).
IT IS IMPORTANT TO NOTE THAT THE FOLLOWING LIMITS ARE IMPOSED ON FILE SIZE DUE TO CONSTRAINTS ON AVAILABLE SYSTEM RESOURCES:
* The maximum allowable CSV file size is set at 3 million lines and 50 columns, with an accompanying restriction of no more than 400 megabytes.
* In instances where the CSV file size remains at or below 3 million lines, flexibility regarding the exact file size can be discussed for up to 600 megabytes.
* If splitting to XLSX is requested, the source CSV file provided by the client needs to less then 400 000 records to minimize system impact.
* To streamline data transfer and minimize internet data usage, the files should be shared in a compressed ZIP or RAR format
Feel free to message me beforehand if any clarification is required.
What the Freelancer needs to start the work
I will need a short description of how the file should be split. If by line count, how many lines and if by column value, what column? If 'Customer' is selected, all customers will have their own file with NO aggregation.
It is possible to export to XLSX, but is still experimental and output can be unpredictable. The output file(s) would be in a simple table structure. Read project details for more details.
The CSV file should have no more than 3 million lines and 50 columns and should be supplied within a .zip or .rar file to compress the size.
Does the CSV file contain headers and if so, do you want to keep them in the output CSV files?
Do you want some columns removed or the delimiter changed for the resulting output CSV files?