Transfer data from Uniconta to Excel

1,569 views 9 May 2017 15 September 2022 2 minutes

September 15th, 2022

It is possible to have direct ‘Read Only’ access to Uniconta from Excel. The minimum excel requirement is Office 365 or Excel 2016.

Get data

Select data in the Excel menu
Select ”New Query”
Select ”From Other Sources”
Select ”From OData Data Feed”
Enter the URL, including any filters

Enter the Username and Password. The account name can be entered before the Username: <Account name (“/” cannot be included in the name))>/UserName or <AccountID>/User Name

Select the table or tables to be transferred to Excel

Click on “Load” to complete the transfer to Excel.

Was this Helpful ?
Yes No

Categories: Data Access, Unipedia