Introduction

The 1010data Excel Add-in is a utility that enables Microsoft Excel to communicate directly with the 1010data server and extract data into Excel.

An Excel workbook can contain multiple queries that use the 1010data macro language. Queries are sent by Excel to the 1010data server, and results are retrieved to the specified destination within the workbook. The queries embedded within a workbook can be hidden from view, providing a seamless experience for the user.

This user guide is divided into three sections:
  1. General - for all users
  2. Advanced - for advanced users who will be constructing workbooks or templates with embedded queries or data to upload
  3. Troubleshooting and Support - for users experiencing errors or unexpected behavior