Help Center / Import Excel with multiple sheets /

Import Excel with multiple sheets

Every Excel or Google Sheet is unique and continually growing, often reaching the limits of Excel files and Google Spreadsheets. It's no wonder that more companies are opting for direct connections through web services and APIs. Additionally, other file formats, such as CSV files, allow an unlimited number of rows and columns. Import capabilities are primarily restricted by the platform into which they are loaded.

Limitation of Excel and Google Spreadsheets
In Google Sheets, you can have a maximum of 18,278 columns and 200 sheets per workbook. Each sheet can contain up to 10 million cells.
In Microsoft Excel, the limit is significantly larger. You can have 1,048,576 rows and 16,384 columns in a single worksheet.

These limitations, especially in terms of the number of rows and columns, can impact the amount of data you can handle in a single document. If your data exceeds these limits, you might need to consider alternative solutions, such as database systems. In some cases, the data is split into multiple columns.

Import Excel with multiple tabs

How Spotzi handles files with multiple tabs?

When dealing with Excel files or spreadsheets containing multiple tabs, Spotzi imports only the active sheet, which is the sheet active at the time of the last save.


Related blog posts

Access the Free Spotzi Explorer

Gain access to our free catalog of maps and dashboards. Find Postal Codes, learn more about global income differences or just get inspired by our community maps. Spotzi Explorer is our free solution for every marketer, researcher, student and beyond. Available as a stand alone solution and part of our price plans.

Get free access to Spotzi Explorer Read more
thumbnail Spotzi welcomes TomTom as a new data partner for global traffic and POI data.


Spotzi welcomes TomTom as a new data partner for global traffic and POI data.