Import txt file into excel with 281,344 rows

  • Thread starter Thread starter JulieM39
  • Start date Start date
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.
 
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.
 
You will need to break the file up into smaller files, or use XL 2007.
 
You must log in or register to reply here.

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

Similar Threads

Formatting .txt File 1
Importing .txt data into Excel 1
Drag text file to Excel -- stopped working 5
Import only certain rows from text file 5
importing from a *.txt file 4
Importing a space-delimited txt. file right-justified into Excel 2
Import Txt file over several excel sheets 2
txt files into one spreadsheet 1

Back
Top