This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 57.99999999999999%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERK%3C/text%3E%3C/svg%3E)
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?
An Azure service for ingesting, preparing, and transforming data at scale.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hey,
Can you provide some more details w.r.t your query?
What exactly are are trying to achieve by opening the CSV file in excel? is to for manual file data analysis?
yes, this is for manual file data analysis.
Check the official recommendations too:
Hi Rakesh Kumar ,
Just following up to see if the below answer helped. Please do consider clicking Accept Answer as accepted answers help community as well. Also, please click on Yes for the survey 'Was the answer helpful'
Answer accepted by question author
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
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.
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.