1. Integrations
  2. SQL Server

Push data into SQL Server from CSV or XLSX files

SQL Server Integration

Import CSV data directly into SQL Server

Use EasyCSV to process and import CSV or XLSX file data directly into SQL Server. You can automate imports by sending CSV/XLSX files to a custom email you get in EasyCSV. Or also use our scheduled fetcher to routinely grab files from FTP / SFTP, Google Drive, Dropbox, OneDrive, a URL, and more.

Then simply map your spreadsheet columns to fields in your database and you're done!

Sign up & try it free SQL Server website

3 Simple Steps to Import a CSV into SQL Server

A CSV (comma-separated values) file is a table of data, typically exported from another program such as Microsoft Excel.

You can import the CSV into SQL Server and load it as a table so you can access and query its data. This page will show you how to import a CSV into SQL Server and set up the data so you can start working with it.

Section 1: Understanding the CSV file.

The first step is to understand what’s in the CSV file.

If you have a CSV file, you can use a CSV editor to view the contents of the file. In Excel, for example, you can just click the Data tab and then choose from the menu to Open as Text, then select Comma as the delimiter.

In this example, the CSV file contains a list of people with their first and last names. The first row is the header row and provides the names of each column:

First Last

John Doe

Jane Smith

Jim Johnson

Jim Smith

Now you know what’s in your CSV file and what each column means. The next step is to import it into SQL Server and set up the data so you can start working with it.

Importing CSV files into SQL Server

Importing CSV files into SQL Server is simple with EasyCSV.

  1. First, use an example CSV file you need to import into SQL Server to set up an EasyCSV import page.

  2. Enter your SQL Server info for connecting to the database. If you need a static IP address please reach out to EasyCSV support via webchat or email and we can provide IP addresses for you to whitelist.

  3. Map your CSV columns to SQL Server Database Fields. You can also use Virtual Fields to transform or combine spreadsheet data into new values to map into your database fields.

  4. Do a real import with your import page!

  5. You can use an automated fetcher or email to automatically send and import data into your database as well. Take a look at the EasyCSV docs for how to do that.