Excel Integration

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.

Overview

Authentication: None
Settings: None
Schema type: Dynamic
Update Type: None
 

Authentication

This integration requires no authentication.
 

Import Settings

This integration has no import settings.
 

Schema

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.

Screenshot_2021-01-06_at_3.36.43_PM.png

Note: You can always import and reimport other tables as well, or delete them.

Was this article helpful?
0 out of 0 found this helpful