Can I create a database in Excel of say a million rows?

Asked By abrahamahartman 60 points N/A Posted on - 12/22/2014

What is the maximum number of rows and columns in a standard worksheet in Excel? Can I increase the number of rows or columns more than the standard available number? Can I create a database in Excel? If not, what is the option for me to use a database within Excel? What can I do to make this possible?ca

• Status: Open
• Question Views: 734
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By Neil Auso 0 points N/A #200190

Can I create a database in Excel of say a million rows?

There are more than 1 lac rows in excel sheet and more than 16,000 columns in it to help the user make it easy and convenient to create vast database. 

The exact number of Rows is 1048576 & columns is 16,384 in an Excel Sheet.  If you want to increase or in need to add more rows or columns you have to switch from standard to MS Excel 2010 version.

How to add rows beyond maximum in an Excel Sheet

 

About Neil Auso

Questions
0

Answers
117

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 01/04/2015
• Question Category: MS Excel