Import an Excel file

Import an Excel file

Created by: Johann Du Toit

Modified on: Tue, 3 Dec, 2019 at 12:46 PM



How to Import Your Own Excel Data and use it to create a Report



Note: This functionality is only available on Professional and Enterprise plans.

  

Set up a Connector to Excel

  • Click on your Login Name in the top right corner of the screen (see below)
  • A dropdown menu will appear.
  • From this dropdown list choose Setup Connectors





  • In the center of the screen there will now be a list of available Connectors (see below)
  • Scroll down and locate ‘File Import’ then click on the ‘Connect Now’ button (this will allow you to create a Connector to Import your own data from Excel, CSV, JSON, HDF5 and other files)


  • After clicking on the ‘Connect Now’ button you will then see the ‘File Import Connector’ screen with Connection Details (see below)




  • If this is your first time adding an Excel file, you can now click on the green button labeled ‘Import New File’ or click on the blue hyperlink ‘Please add one’ (see above)
  • Once you have clicked on ‘Import New File’ or ‘Please add one’ you will see a screen that will allow you to Add a Title and then Browse and choose a file (in the screen shot below, a file name ‘Restaurants.xlsx’ was chosen)


 


  • Click on ‘Save’ once you have added the Title and chosen a file
  • The next screenshot shows the resultant screen after clicking on Save




  • From this screen you can
    • ‘Forget’ (remove) the Connector
    • Import a New Excel, CSV etc. file to report on
    • Reload (‘Upload Again’) the file again
    • Remove the file
  • You have now successfully created the Connector and Imported the Excel file
  • In the future, to return to the File Import Connector screen above (for editing, importing, removing Excel files), click on your ‘User Name‘ in the upper right hand corner of the screen.
  • Then choose ‘Setup Connectors’, scroll down and locate the ‘File Import’ connector and then click on ‘Status’





Create a Report using the Excel Connector

  • Login to Wink and at the Main screen click on ‘Reports’ on the left-hand side of the screen




           


  • The following screen will appear




           


  • Next click on ‘Design a New Report' (as shown below)




           


  • The following screen will appear




  • Type in a ‘Title’ (in the above example ‘Restaurants Report’, next, choose a 'Report Type’ (Spreadsheet or Multi-Tab Spreadsheet), next choose a Data Source’ (in this case under ‘File Import’ choose the data source name for the Excel Connector just created above), finally click on ‘Create’
  • The basic Report will now be created and appear similar to below (you can now perform further editing etc.):


    • Related Articles

    • Report Designer Excel Style Formulas

      Created by: Gavin Hodge Modified on: Fri, 14 Feb, 2020 at 9:43 AM Most formula transformations can be done using value source formulas, but the report designer tool also supports using literal Excel style formulas.  While value source formulas are ...
    • No totals when viewing in Excel

      Created by: Gavin Hodge Modified on: Mon, 7 May, 2018 at 9:55 AM Spreadsheet reports are exported to Excel format when sent via email, and also when 'Save As Excel' is used while viewing a report. When you first open an Excel attachment it will show ...
    • What is the MYOB file user name and password?

      Created by: Johann Du Toit Modified on: Fri, 11 Sep, 2020 at 10:39 AM MYOB has two separate user concepts. The normal MYOB Account (which you use for OAuth and logging in), and the MYOB "file" has it's own set of users. (which is different from the ...
    • How to decide when to use Value Source or Excel formulas?

      Created by: Johann Du Toit Modified on: Fri, 14 Feb, 2020 at 9:41 AM Warning! This is a confusing subject, but please bear with us. If you've done some report designs and created formula columns, then you would be familiar with "Value Source" or ...
    • How to direct link to a shared report URL?

      Created by: Johann Du Toit Modified on: Tue, 27 Oct, 2020 at 3:05 PM Reports can be shared via a special link which can be given to people without a Wink Reports login. That link will open up a portal with menu options to download copies of the ...