+ Reply to Thread
Results 1 to 6 of 6

Link CSV file as data source for pivot table in Excel

  1. #1
    Registered User
    Join Date
    09-23-2015
    Location
    Manchester
    MS-Off Ver
    Latest Excel
    Posts
    7

    Link CSV file as data source for pivot table in Excel

    I have a huge CSV file that is too large to put into a worksheet and CSV is the format I have it in.

    I want to use a pivot table to mine that data but I have no idea how to link a CSV to a Pivot. I downloaded an ODBC driver (no idea what it is) and cant make head nor tail of what stuff on google tells me. Does anyone have any bright ideas? It would appear that because I have Mac and am on Office 365, I don't have the Power options that would otherwise render this easy?

    Cheers, in advance

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016
    Posts
    4,061

    Re: Link CSV file as data source for pivot table in Excel

    OK, it's the end of day here and I do not have time to write it up now. But I did figure out how to do it. I'll report back tomorrow with how to make the ODBC connection and how to navigate the pivot table wizard to find it. I'll get screen shots and put it in a word document.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016
    Posts
    4,061

    Re: Link CSV file as data source for pivot table in Excel

    Here are the steps I used to connect to a Pivot Table to a CSV remote file.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    09-23-2015
    Location
    Manchester
    MS-Off Ver
    Latest Excel
    Posts
    7

    Re: Link CSV file as data source for pivot table in Excel

    I cant add a text driver in MAC it only gives me the options for the attached?

    Thanks for trying. Hopefully the fix is easy...
    Attached Images Attached Images

  5. #5
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016
    Posts
    4,061

    Re: Link CSV file as data source for pivot table in Excel

    Do a web search for a text driver for a MAC. I just did that and found this. It looks like a good starting point: http://support.openlinksw.com/support/mac-faq.html.

    Good luck with your project.

  6. #6
    Registered User
    Join Date
    09-23-2015
    Location
    Manchester
    MS-Off Ver
    Latest Excel
    Posts
    7

    Re: Link CSV file as data source for pivot table in Excel

    Thanks but that may as well be foreign language

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1