Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Program to read LARGE CSV files

Apr 15, 2005 6:17PM PDT

I have a 330meg csv file I need to open, and sort by the phone number of each contact. Is there a free program I can use to do this? I've tried excel, works, and open office, and no luck with any of them so far. i have 1.3 million contacts in my database.

Thanks in advance.

Matt
webmaster@xantonmarketing.com

Discussion is locked

- Collapse -
Have you tried...
Apr 15, 2005 11:11PM PDT
- Collapse -
Split it
Apr 16, 2005 3:40PM PDT

Since it is a CSV (Comma Separated Values) file, you should be able to use any capable text editor to open the file and separate between records (a record should be per line, so you separate it at the end of a line).

Make as many chunks as needed for getting each chunk down to a reasonable size.