It is known that Excel sheets can display a maximum of 1 million rows. Is there any row limit for csv data, i.e. does Excel allow more than 1 million rows in csv format?
众所周知，Excel表最多可以显示100万行。csv数据是否有行限制，即Excel是否允许在csv格式下超过100万行?
One more question: About this 1 million limitation; Can Excel hold more than 1 million data rows, even though it only displays a maximum of 1 million data rows?
还有一个问题，关于100万的限制;Excel能保存100多万个数据行吗，即使它只显示最多100万个数据行?
3 个解决方案
#1
19
CSV files have no limit of rows you can add to them. Excel won't hold more that the 1 million lines of data if you import a CSV file having more lines.
CSV文件没有可以添加的行限制。如果你导入的CSV文件有更多的行，Excel不会比100万行的数据多。
Excel will actually ask you whether you want to proceed when importing more than 1 million data rows. It suggests to import the remaining data by using the text import wizard again - you will need to set the appropriate line offset.
当导入超过100万行数据时，Excel会询问您是否要继续。它建议再次使用文本导入向导导入剩余的数据——您需要设置适当的行偏移量。
#2
2
In my memory, excel (versions >= 2007) limits the power 2 of 20 1, 048, 576 lines.
在我的记忆中，excel(版本>= 2007)限制了201,048576行的power 2。
Csv is over to this boundary, like ordinary text file. So you will be care of the transfer between two formats.
Csv在这个边界上，就像普通的文本文件一样。所以你会关心两种格式之间的传输。
#3
1
Using the Excel Text import wizard to import it if it is a text file, like a CSV file, is another option and can be done based on which row number to which row numbers you specify. See: This link
如果是文本文件(如CSV文件)，则使用Excel文本导入向导将其导入，这是另一个选项，可以根据指定的行号对其进行导入。看:这个链接
#1
19
CSV files have no limit of rows you can add to them. Excel won't hold more that the 1 million lines of data if you import a CSV file having more lines.
CSV文件没有可以添加的行限制。如果你导入的CSV文件有更多的行，Excel不会比100万行的数据多。
Excel will actually ask you whether you want to proceed when importing more than 1 million data rows. It suggests to import the remaining data by using the text import wizard again - you will need to set the appropriate line offset.
当导入超过100万行数据时，Excel会询问您是否要继续。它建议再次使用文本导入向导导入剩余的数据——您需要设置适当的行偏移量。
#2
2
In my memory, excel (versions >= 2007) limits the power 2 of 20 1, 048, 576 lines.
在我的记忆中，excel(版本>= 2007)限制了201,048576行的power 2。
Csv is over to this boundary, like ordinary text file. So you will be care of the transfer between two formats.
Csv在这个边界上，就像普通的文本文件一样。所以你会关心两种格式之间的传输。
#3
1
Using the Excel Text import wizard to import it if it is a text file, like a CSV file, is another option and can be done based on which row number to which row numbers you specify. See: This link
如果是文本文件(如CSV文件)，则使用Excel文本导入向导将其导入，这是另一个选项，可以根据指定的行号对其进行导入。看:这个链接