Forum Discussion

Abdellatif1995's avatar
Abdellatif1995
Copper Contributor
Apr 07, 2023

Excel file with 260k rows

Hi all , I downloaded an excel file recently that had over 250k row but when I open it it only shows me a total of 100k row ,even when I imported it into Microsoft SQL server it still shows the total is 100k row. Is there a way to get the excel to read all the 250k row the file supposed to have?

BI & Data Analysis
Excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Apr 07, 2023
    How do you know it contains 250K rows?
    Is the worksheet filtered, or have some rows been hidden?
    • Abdellatif1995's avatar
      Abdellatif1995
      Copper Contributor
      Apr 07, 2023
      I reviewed the data online before I downloaded it and it showed 267k entry , I tried to unhide rows but nothing happened
      • SergeiBaklan's avatar
        SergeiBaklan
        MVP
        Apr 07, 2023

        Abdellatif1995 

        Do you mean in Excel for web you see 267000 rows and in desktop version 100000 rows? Or with what you reviewed data online?

Resources