Import txt file into excel with 281,344 rows

J

JulieM39

Hi, I've got a very large txt file that I need to import into excel. It has
288,344 rows. Is there a way I can do this? The fields on my txt file are
separated by a pipe "|"

Thanks in advance.
 
D

Dave Peterson

If you're using xl2007, then that data will fit.

Open the .txt file and choose delimited by |

If you're using xl2003 and below, you could use your favorite text editor to
make several smaller .txt files (65536 rows or smaller) and import each into
separate worksheets.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top