Import data from online Excel file to SQL Server

Want to parse cloud Excel file and save to SQL Server ?

Try Withdata FileToDB, a desktop Excel to SQL Server converter for Windows, MacOS, and Linux, Import cloud Excel to SQL Server, Easy and Fast.

• Can run in GUI mode, Step by Step, just a few mouse clicks.
• Can run in Command line, for Scheduled Tasks and Streams.
• Import Excel to SQL Server locally and privately, avoid uploading Excel file(s) to online services.

Download Withdata FileToDB
Windows 64 bit
Windows 32 bit
Linux .deb (For Debian, Ubuntu) 64 bit
Linux .rpm (For Red Hat, Fedora, SUSE) 64 bit
MacOS 64 bit

Import cloud Excel data to SQL Server table

Choose SQL Server and logon.

Click “Wizard – 1 File To 1 Table” at task dialog.

Select “Source Type” with “Url”.

then show the wizard.

1. Input the Excel file URL, and download the file.

2. Open the saved Excel file.

3. Config target SQL Server table.

4. Set rows options.

5. Import cloud Excel data to SQL Server.

See SQL Server table

Import cloud Excel to SQL Server in command line

Save “Excel to SQL Server” session, then you can:

• Import cloud Excel to SQL Server in Windows command line.
• Import cloud Excel to SQL Server in Linux command line.
• Import cloud Excel to SQL Server in macOS command line.

Set scheduled tasks for importing Excel to SQL Server

You can schedule and automate this converting task by:

1. Save session and create .bat (Windows) or .sh (Linux/macOS) file for “Excel to SQL Server” conversion.
2. Set scheduled task for “Excel to SQL Server” conversion.

FAQ

More about Withdata FileToDB – Excel to SQL Server converter