> For the complete documentation index, see [llms.txt](https://docs.xlconnect.net/xlconnect-documentation/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.xlconnect.net/xlconnect-documentation/developing-with-xlconnect/import-scripts.md).
# Import Scripts
The easiest way to get started with XLConnect development is with Prefab Scripts, that you can import from the Ribbon. For this example we will use Xero, for other platforms it works similarly.
On the Ribbon, select `Import Script > Xero > Connections`.
Insert a Xero Connections Script
On the right hand side of your screen the Maps and Scripts pane will open with a script called 'Connections', with under it two maps Input and Output, and under output a table again called Connections.
The Connections table is grey, indicating it is not connected to workbook cells. To connect it, click and hold the table, to drag it onto your workbook. This should create a table with two generic columns called Column1 and Column2, and a message telling you it will get it's columns from the data:
So let's execute the script. To do that, right click the script, then choose `Execute Script`:
This will execute the script, this will call into the Xero API to pull the connection so it will probably open up a browser to log in to Xero.
Complete the steps, then it will pull the data and display it in the table:
Table with list of Companies from Xero
The companies in this example have been altered, you should recognize the companies on Xero that you have access to. To get access to more companies, go though the login process again.
Now it's time to select the company we want to pull the data for, to do that mark the column `Pull` with an x.
Now we have a list of Zero Companies, but no data yet. Let's pull the chart of accounts for a company. To do this, import the Accounts script:
This imported a second script 'Accounts', with one input table `Connections` and an Output table `Accounts`. The Connections table is white, inidcating it is connected. That's because it the Excel table created in the step above is also called Connections. XLConnect will automatically connect a table connection when it finds a table with the same name.
To connect the Accounts table to the workbook, drag it onto the worksheet. You will get the same message a earlier that it needs to pull data to derive the columns. Your workbook should look like this:
Empty Accounts table below Connections table
To expand the table, we'll do the same as with the first table, execute the `Accounts` script:
Now XLConnect should grab your Chart of Accounts data from Xero and display it the table:
Chart of Accounts for Company 3
That is how easy it is to grab data from Xero by Drag & Drop, without even writing a single line of code.
---
# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.
## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.
Perform an HTTP GET request on the current page URL with the `ask` query parameter:
```
GET https://docs.xlconnect.net/xlconnect-documentation/developing-with-xlconnect/import-scripts.md?ask=
```
The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.
Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.