0

I am trying to create a single Excel spreadsheet page from a text file with more than 1.2 million lines. However, Excel 2016 doesn't support more than 1048576 rows.

Is it possible to do this?

ti7
  • 16,375
  • 6
  • 40
  • 68
Stackuser
  • 59
  • 7
  • This is not a forum, and you should provide what research you have done, along with some more about your goal and some sample data. That said, you do have a reasonable question at the base so I have vastly reworded your question to be a more appropriate form. – ti7 Jul 06 '18 at 11:16
  • @ti7 We know the OPs goal and they dont need to include sample data, did you even read the question? Its an excel row issue not a code issue? However i do agree with your statement about research – connorg98 Jul 06 '18 at 11:21
  • @connorg98 It is sometimes possible to reduce a problem with a little sample data (especially XY problems). Further, the user has obviously not read the guidelines from their question design, and there is limited space to welcome and help them create better questions in the future. – ti7 Jul 06 '18 at 11:25
  • @ti7 I understood what the OP needed and personally i do not think sample data is necessary in this instance however i agree that they will never learn how to ask a good question without criticisms – connorg98 Jul 06 '18 at 11:28
  • Why don't you use MS-Access? – Dominique Jul 06 '18 at 11:31

2 Answers2

1

This is currently the reason i dont use excel much anymore.

You can use excel still but you would have to spread the data over 2 tabs in excel;

  • 500,000 rows on Sheet 1
  • 700,000 rows on Sheet 2 and so on

To my knowledge you cannot change the max rows, i would recommend that you have a look around/google at other ways of showing the data like SQL for example because in my opinion Excel is outdated.

I hope this has helped, thanks.

connorg98
  • 189
  • 12
  • Thanks! Oh! it is even good to know that we cannot change the max rows! Thanks, Connorg98! – Stackuser Jul 06 '18 at 11:16
  • No problem atall i hope it helped – connorg98 Jul 06 '18 at 11:17
  • If you are happy with my answer and it has helped you can you mark it as your favorite as i need the extra reputation :P thank you – connorg98 Jul 06 '18 at 11:43
  • lol... but the software delimit work for me better and the only problem is that how can I change those converted excel file to access because I need to do some relationship using create query design in access! thanks – Stackuser Jul 06 '18 at 12:03
  • Do you mean how to convert an excel file to microsoft access? If you do here is a quick guide http://smallbusiness.chron.com/convert-excel-documents-microsoft-access-40490.html :) – connorg98 Jul 06 '18 at 12:06
  • Hi sorry do you mean separate tabs? in excel – connorg98 Jul 09 '18 at 08:35
  • I think you will find your answer if you put up another question my friend :) it is no good asking on this question – connorg98 Jul 09 '18 at 12:27
0

What is the purpose of having 1.2 million records in excel? If it is to do some kind of analysis you will need to aggregate them anyhow.

As for your question: you can import a text file of 1.2 Mln records (with reasonable amount of fields)into excel using powerpivot.

Powerpivot/Manage Get exernal data from other sources/text file

Wim F
  • 58
  • 7