open in a new tab
This online tool process a delimited text file. The file will have a header row, then one row per record. The records may be comma-separated or tab-separated. An example file’s contents could be:
First Name,Middle Name,Last Name
Jane,Taylor,Doe
Chris,Lee
Jose,,Morro
The user will fill out (*optional)
- (*optional) Is the file format CSV (comma-separated values) or TSV (tab-separated values)?
- (*optional) How many fields should each record contain?
Click upload file to upload a .csv file or .tsv file
The tool will produce two output files download link. One file named xxx_good_data will contain the records (if any) with the correct number of fields. The second file named xxx_bad_data will contain the records (if any) with the incorrect number of fields. Neither file contain the header row. If there are no records for a given output file, will create a 0 size empty file.
Based on the above sample input, if the user specified a CSV file with 3 fields per record, the following files would be created:
Correctly formatted records:
Jane,Taylor,Doe
Jose,,Morro
Incorrectly formatted records:
Chris,Lee