If you want to split based on file size then choose ' character split'. a text file with 20 lines split into 4 will output 4 files of 5 lines each (the size of each line is irrelevant to the spit so output file sizes will vary). We can do this by manually creating the headers and then each employee like so: Add-Content -Path C:Employees.csv -Value 'FirstName','LastName','UserName'. For example, perhaps I want to create a list of employee names in a CSV file. Note: If you choose 'Line split' files are split on the number of lines included in them. Even though Add-Content does not natively understand a CSV file, it would still be able to read one. Anything larger and results will vary by browser.Īlso for large files you'll have to ignore the warning of your browser that a script is taking too long to execute and let your machine work until it finishes. Please note that this will only work for files up to 300Mb. Select the method of splitting (line or character based).įor csv files you probably want line based. Input the number of equally split files you desire.

Load your text file or csv file by pressing the Load File button.

Tab to csv online notepad ++