Hey,
this is a limitation on Excel
So you can either open the CSV file as txt file or load data into SQL or use synapse serverless to query the CSV file data from database or use databrick notebooks etc
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
I am transferring data from an on-premises database to a data lake in CSV format. When I attempt to open the CSV file in Excel, I encounter a row limit of approximately 1 million rows, while the source database contains over 4 million rows. What is the recommended approach to handle this situation?
Hey,
this is a limitation on Excel
So you can either open the CSV file as txt file or load data into SQL or use synapse serverless to query the CSV file data from database or use databrick notebooks etc
Hi,
The maximum number of rows and columns on a worksheet in Excel is 1,048,576 rows by 16,384 columns. You cannot increase the rows and columns in Excel. In my opinion you should change the application to help you analysis the data in .csv file.
Just checking in to see if the information was helpful. Please let us know if you would like further assistance.
If the response is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
When I attempt to open the CSV file in Excel, I encounter a row limit of approximately 1 million rows
1 Mio is the limit of Excel.
What is the recommended approach to handle this situation?
Not opening a CSV file in Excel, that will cause always issue. CSV is a text file so use a text editor if you want to view the file content.