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.

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.

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.

Solution

• If you wish to import an Excel file with multiple tabs and want to include all data, you can export each sheet to a CSV file and consolidate all the rows into a single file.
• Alternatively, if your data is stored in a database, another option is to utilize the Spotzi Webservice, establishing a direct connection from your data to the Spotzi Platform. For further details, please feel free to contact us.