In this article, we’ll integrate an Excel data source with Y42.
Microsoft Excel is the most widely used spreadsheet program. Excel is typically used to organize data and perform data analysis. It is used across all business functions and at companies from small to large ones.
Schema type: Dynamic
Update Type: None
This integration requires no authentication.
This integration has no import settings.
Dynamic Schema is a schema which will be dynamically loaded at run-time.
Each sheet from your Excel file is imported as a separated table.
Note: If none of your rows have numeric values, the column names from Excel will not be imported as heading onto the Google BigQuery. However, if there's a number in any of the columns data, then the import will successfully take the first row as column headers. Therefore, we recommend creating an index column to avoid the issue.
Updating your data
There's no update schedule feature for this integration.
Excel Setup Guide:
Simply press Browse Files (or Drag & Drop), select your preferred Excel files and upload them into the system.
Note: You must have an Excel file in your files to upload it.
Note: You can always import and reimport other tables as well, or delete them.
Was this article helpful?