web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Max number of columns ...
Power Apps
Unanswered

Max number of columns in Excel

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Dear All, Does anyone know what is the maximum number of columns in excel that can be retrieved? 

Categories:
I have the same question (0)
  • Pstork1 Profile Picture
    69,651 Most Valuable Professional on at

    I don't believe there is a specific limit on the number of columns that can be in the table.  But there is a hard limit on the overall size of the Excel file.  The file can't be larger than 2MB. That will limit how many columns you can have.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hello Pstork1, thanks for your response. the issue i am having is that the excel file has exceed 2000 rows and i am not able to retrieve the data after the column number 2000. Do you have any solution for that? how to extend the number of rows accepted?

     

  • timl Profile Picture
    37,283 Super User 2026 Season 2 on at

    Hi @Anonymous 

    There is no way to extend the number of rows that is accessible beyond 2000.

    As @Pstork1  says, there is a 2MB limit to the size of your Excel file. If you want to extend the amount of data that you can store in a spreadsheet by extending the number of columns, you'll likely hit the 2MB soon and you'll end up in the same situation

    The only workable solution is to work out a way in which you can partition your data, and to split it across multiple Excel files. You would then create a separate connection for each Excel file.

    Alternatively, if you're working with read-only Excel data that doesn't change, you can import it as static data and there isn't any limit to the amount of rows that you can import this way.

  • Pstork1 Profile Picture
    69,651 Most Valuable Professional on at

    You asked about columns, not Rows.  I don't believe there is a limit to 2,000 columns, but as @timl said there is no way to increase beyond the 2,000 rows other than retrieve the content through import.  But then you can't save changes back.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Thank you all. I am trying now to take the extra rows and convert them into colums. so i solve the issue of the extra rows.

  • Pstork1 Profile Picture
    69,651 Most Valuable Professional on at

    Rows and Columns really aren't interchangeable.  Rows represent records with specific fields (columns).  Switching them around won't really give you usable data.

  • timl Profile Picture
    37,283 Super User 2026 Season 2 on at

    @Anonymous 

    Is the any reason why you can't use a SharePoint list?

    If you're spending time transposing rows to columns, I would suggest that a more effective use of your time would be to migrate your data to SharePoint, which would then provide a much more future proof platform on which to work on.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    thank you for your input. i am limited only to excel. 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 416 Most Valuable Professional

#2
11manish Profile Picture

11manish 205 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard