• SQL Spreads Blog

  • How to Export Data from SQL Server to Excel

    Aug 26th, 2021

    In a previous article, SQL and Excel: Why you need both, we showed that for many businesses the use of both SQL Server and Excel is an optimum approach to data management.  For organizations that use SQL Server and Excel extensively, there is often a need to export data from SQL Server to Excel.  The …

  • SQL Server Import and Export Wizard Guide

    Jul 20th, 2021

    What is the SQL Server Import and Export Wizard? SQL Server Import and Export Wizard is a simple way to copy data from a source to a destination.  It is most commonly used to get data into or out of a SQL Server database, but it caters to several scenarios. Although like most Microsoft wizards …

  • Connect Excel to SQL Server: 3 Easy Steps

    Jun 29th, 2021

    In a previous article, we spoke about why you need both Excel and SQL in your data management solutions, but how do you connect Excel to SQL Server?  In this article, we’re going to show you the steps and highlight a key benefit of using an Excel add-in like SQL Spreads. But, first, we’re going …

  • SQL and Excel: Why you need both

    Jun 17th, 2021

    Introduction SQL vs. Excel: which is better?  As you can see from the title of this article, it’s not the case that you should choose one over the other; you actually need SQL and Excel. Excel is a really great application.  There are not many applications that are used by such a wide variety of …

  • CSV to SQL: How to Convert, Open & Import

    May 12th, 2021

    Introduction Comma Separated Values (CSV) files are commonly used to exchange data from one system or application to another.  The simple format of the csv file makes them ideal for exporting data from one place and importing it to another.  A common use case, for example, is to export the data from an accounting or …

  • How to import data from Excel to SQL Server using the SQL Spreads Excel Add-In

    May 8th, 2019

    In many businesses, the number-one choice to edit, analyze and store data is still Microsoft Excel. In this article, I will show you how a modern Excel Add-In can be used to collaborate and allow even non-technical users to import data from Excel to SQL Server in a simple, secure and structured way.

  • How to Update an SQL Table from Excel

    Feb 5th, 2019

    If you want to easily let your non-technical users update and manage SQL Server data from Excel,click here to download the SQL Spreads Excel Add-In. SQL Spreads solves some common data management problems for Microsoft SQL Server. It makes it fast and simple to update an SQL table from an Excel spreadsheet. And it gives …

  • How to insert data from Excel to SQL Server

    May 4th, 2017

    Most people do not know that there is a really simple way to copy and paste data from Excel to SQL Server. In this article, I will show you what you need to know to copy and paste data from Excel to SQL Server.
    I will go through and show the technique using simple step-by-step instructions, and I will also cover a few special cases that are great to know.

  • Use Excel to update data in SQL Server Views

    Nov 28th, 2016

    If you want to easily let your non-technical users update and manage SQL Server data from Excel, click here to download the SQL Spreads Excel Add-In. To enable users to work with data from several different tables when updating data in Excel to SQL Server, the latest release of SQL Spreads now supports working with …

  • How to use Excel to update SQL Server data

    Oct 17th, 2014

    If you want to easily let your non-technical users update and manage SQL Server data from Excel, click here to download the SQL Spreads Excel Add-In. End users love working in Excel; they know the tool and they are free to do what they want. That’s the heart of the much-loved Excel application, but also …