Microsoft Excel

This topic describes how to connect Tableau to a Microsoft Excel file and set up the data source. Tableau can connect to .xls and xlsx files.
  1. Click Connect to Data.
  2. On the Connect page, click Microsoft Excel, select the Excel workbook you want to connect to, and then click Open.
    To connect to the Excel file using the Microsoft Jet-based connection, in the Open dialog box, click the Open drop-down menu, and then select Open with Legacy Connection. The data source page displays.
  3. On the data source page, do the following:
    1. (Optional) Click the default data source name at the top of the page, and then type a unique data source name for use in Tableau.
    2. If your Excel file has one table, click Go to Worksheet to start building the view.
      Alternatively, drag additional tables to the join area and use conditions to join them. You can choose to combine tables or use Custom SQL when you are working with multiple tables. You can also add joins later.
      You can also connect to a named range the same way you connect to a worksheet. Named ranges are created in Excel by highlighting a range of cells and then selecting Define Name on the Formulas tab.
      You can connect to multiple Excel worksheets at the same time as long as each worksheet has a unique connection name.

Optional Settings

You can set the following options before building the view.

Set Excel table options

In the join area, hover over the table name until the gear icon displays, click the icon, and then specify whether the data includes field names in the first row. These names will become the names of the fields in Tableau. If column names are not included, they will be automatically generated by Tableau. You can rename the fields later.

Preview the data and change data types


The first 10,000 rows of the data in the data source is automatically displayed below the join area. If you add tables, remove tables, or make changes to the join conditions, the preview updates. You can also do the following in the preview area:
  • Change the data type of a column by clicking the data type icon.
  • Rename or hide a column by clicking the column header drop-down menu and selecting the respective option.

Connect live or use an extract

At the top of the data source page, select a live or extract connection to the data source. If you choose to take an extract, the Edit link displays allowing you to set up filters that define a subset of the data that you want to include in the extract.

Add data source filters

Add data source filters to restrict the visibility and use of the fields in the data source.

Additional Information

An example of a Microsoft Excel data source is shown below.

Note: If the Excel file contains columns that are more than 254 characters wide, Tableau is not able to use these fields for workbooks that were created before Tableau Desktop 8.2 or use the legacy connection. Either remove the columns, modify them to fit within 254 characters prior to connecting in Tableau, or upgrade the Excel data source.

31 comments:

  1. hi.this is a very nice blog to guide a newbie in hysys-excel automation. thanks for sharing. anw, I have a question here. Can you do the hysys-excel automation without opening the hysys file?? I want to do this since it'll be more simple and save our cpu workspace. I've tried it but got some problems in the "ActiveDocument" syntax. is there any solution to do this?? thanks. Excel Training in Chennai | Advanced Excel Training in Chennai

    ReplyDelete
  2. Amazing Blog...!! Thanks for sharing information. I will be waiting for next blog. Get to know more Advance Excel Training.

    ReplyDelete
  3. Thanks so much for this information. I have to let you know I concur on several of the points you make here and others may require some further review, but I can see your viewpoint.
    excel vba courses london

    ReplyDelete
  4. Very nice and informative blog thank you for sharing Tableau online training

    ReplyDelete
  5. It is really a great work and the way in which you are sharing the knowledge is excellent.Thanks for your informative article
    Tableau Online Training|
    SAS Online Training |
    R Programming Online Training|

    ReplyDelete
  6. well done! the blog is good and it is about Tableau Course Content it is useful for students and tableau Developers for more updates on Tableau follow the link

    tableau online training

    ReplyDelete

  7. well done! the blog is good and it is about Microsoft Excel is useful for students and tableau Developers for more updates on Tableau

    tableau online course

    ReplyDelete
  8. It is really a great work thank you for sharing Tableau Online Training

    ReplyDelete
  9. Nice Blog post. Thanks for sharing great information. keep posting..

    SAP S/4 HANA training online

    ReplyDelete
  10. Thanks for sharing the details! thanks for sharing information,nice article.
    i would like to more information from your side!
    please added more then tips!Am working in
    Excel Training in Hyderabad

    ReplyDelete
  11. WOW..Great Blog Thanks for sharing a good information of this blog .... Keep SHARING These Type of blogs.
    it is very Useful to Hadoop Beginners
    Hadoop Training in Hyderabad
    Data Science Training in Hyderabad
    Tableau Online Training in Hyderabad

    ReplyDelete
  12. This is really too useful and have more ideas and keep sharing many techniques. Eagerly waiting for your new blog keep doing more.
    tableau training in hyderabad
    tableau onlinetraining in hyderabad

    ReplyDelete
  13. Thank u for posting such a valuable information.keep sharing like these.

    http://www.rstrainings.com/adv-java-online-training.html

    http://www.rstrainings.com/core-java-online-training.html

    ReplyDelete
  14. Thanks for Sharing this valauable article it was very intresting to read, please keep sharing this type effective articles......
    Tableau Online Training In Hyderabad

    ReplyDelete
  15. Thanks for sharing such a useful information. Having some training in Excel is a MUST nowadays.As a professional in your field, you already know the benefits of using Microsoft Excel. By using Excel, you’ll save a ton of time at your job and/or in your personal life, and it’s guaranteed to be more accurate than something you could’ve done by hand.Get the Best Microsoft Advanced https://www.urbanpro.com/chennai/microsoft-excel-training-classes only on urbanpro platform

    ReplyDelete
  16. Nice Blog just watching that blog, It is really Impressive.

    Advanced Excel

    ReplyDelete
  17. Very nice write-up. I absolutely appreciate this website.Thanks.excel courses london

    ReplyDelete
  18. Thanks for the information. This blog is easily understandable.
    Online Training Courses

    ReplyDelete
  19. Hey Alfred,
    I Just checked you link of Trunao.com which is very impressive.
    It converts Excel 10k rows to web based form very quickly and enable us inline editing, sorting, filtering and many more
    please goto its features page to check many other features https://trunao.com/features

    ReplyDelete