How to sync data from Excel to a data warehouse
Unlock the power of your spreadsheets! With our new OneDrive connector, you can now sync your Excel and CSV files directly to your destination. Leverage the power of Weld by seamlessly integrating your Excel and CSV files with the rest of your data sources.
How can I set up the connector in Weld?
- Prepare Your Files:
- Ensure that all the Excel files you intend to sync are located within a dedicated folder on OneDrive
- Create Connector in Weld
- Click on 'New Connector' and select 'OneDrive' from the list.
- Authenticate using your Microsoft credentials to grant Weld access to your OneDrive.
- Configure Connector Settings:
- In the connector settings, select either 'XLSX' or CSV as the file type.
- Enter the URL of your file path from OneDrive
- Opt to use the first row of your file as the column names if applicable.
- Decide if you need to convert all properties to strings.
- In the connector settings, select either 'XLSX' or CSV as the file type.
- Set Sync Schedule:
- Set the frequency at which new data should be synced from your OneDrive files to your destination.
What can I do with my OneDrive Data?
- Merge multiple Excel or CSV files into one table
- Join with your other data sources in our SQL Editor
- Get insights into core business logic using our Ed, our AI SQL assistant
- Visualize in any BI Tool
Can I sync excel files from any other source?
Yes! You can also sync Excel files with Weld using our Google Drive connector!
I don't know SQL, can I still use Weld?
Absolutely! With Ed, our AI SQL assistant, you can get started creating data models and metrics without any prior knowledge of SQL.
Can I Weld for free?
For sure! We offer a 14-day free trial for you to start exploring your data.
Continue reading
Weld + Shopify: Powering your ecommerce brand with data
Weld's Shopify integration is one of our most used connectors. Learn how it works and see real-world use cases for your ecommerce business.
Introducing our newest integration - dbt Cloud!
Weld's dbt Cloud integration streamlines data workflows from extraction to transformation. Get a quick setup guide and see how dbt improves automation and scalability for data teams.
New Connector Alert - TikTok Organic
Want to get the best overview of your TikTok Organic metrics? Our ETL connector now combines your TikTok Organic data with all sources for a unified view. Track all your profile metrics, audience demographics, and video performance, including impressions and audience location.