Rows is an Excel add-in that allows you to:

1. Craft informative reports and cool data visualizations using your accounting software and the power of Excel.

2. Allows you to Download, Edit and Upload data in bulk to and from your accounts software.

Learn how to upgrade from the old DataDear add-in to Rows.

If you are still using the old DataDear add-in, follow the link below to update to the new Rows add-in.

Learn how to Install the Rows excel add-in.

Learn how to add or reconnect your organisations in Xero to Rows from the Dashboard or directly from Excel.

You need to add organisations to Rows to start using the Excel add-in. You may add your organisations by following the below. You must have the "Add Orgsanisation" permissions to do this.

Learn how to add Users and edit permissions.

An organisation connected to Rows may be shared with other user including staff / employees or with clients so they can also use Rows. Different user granular permissions allow further control on what can be shared and with whom.

Learn how you can take a data copy of your journals, static data and attachments of a Xero organisation or a QuickBooks Online company.

A data copy is useful for:

Peace of mind - Your company or client want to store a copy of the Xero or QuickBooks Online data offline.

Cancel Subscription - Get a copy of all data when you terminate the subscription with Xero or QuickBooks Online.

Closing off a client - Get all the client data out of Xero or QuickBooks Online including attachments for clients.

Data Retention Policy - Some companies require an offline copy as part of their data retention policy.

Transactions for a year - Choose to download a data copy of all transactions for any required period.

Attachments - Get a copy of all attachments within the Xero organisation or QuickBooks Online company.

You need data copy tokens to be able to create a data copy. If you need tokens please get in touch with us at [email protected]

Learn how to use Data Tables and Reports.

Users can pull data into excel from their accounting software. It is important to understand that with Data Tables and Reports, users cannot affect the data that is in their accounting software.

Learn how to use the Templates to Download, Edit and Upload data in bulk.

Templates are essentially Excel workbooks that are built in a way that will allow data to flow into your accounting system. Users can populate the templates using all of Excels functionality and post to their accounting software with the press of a button. Templates are the only way a user can change the data in their accounting software.