+ Reply to Thread
Results 1 to 4 of 4

Power Query results to a .csv file

  1. 04-16-2019, 01:45 AM #1
    JohnnyBoyxxx
    JohnnyBoyxxx is offline
    Forum Contributor
    Join Date
    04-25-2011
    Location
    Donegal, Ireland
    MS-Off Ver
    Excel 2013
    Posts
    133

    Power Query results to a .csv file

    Hi, does anyone know a simple way to output PQ results to a .csv file in excel 2013

    I've searched around but all i can find requires using Power BI which i need an OrgID apparently

    Regards
    John

    UPDATE:

    Please ignore this question, the obvious answer is to do a 'save as' as was very kindly pointed out to me by AliGW but for some reason i assumed it was a bigger issue.

    I can only put it down to a brain freeze. tiredness perhaps but no doubt a signal to take a break from the PC

    Thanks
    Last edited by JohnnyBoyxxx; 04-16-2019 at 02:15 AM.
    Reply With QuoteRegister To Reply
  2. 04-16-2019, 01:51 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Power Query results to a .csv file

    Why are you not just saving the worksheet with the PQ results table as a .csv file? It's really easy to do.
    Attached Files Attached Files
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 04-16-2019, 02:06 AM #3
    JohnnyBoyxxx
    JohnnyBoyxxx is offline
    Forum Contributor
    Join Date
    04-25-2011
    Location
    Donegal, Ireland
    MS-Off Ver
    Excel 2013
    Posts
    133

    Re: Power Query results to a .csv file

    lol OMG, it's too early, i never even thought of that, what an idiot.

    Thanks anyway, you're a star
    Reply With QuoteRegister To Reply
  4. 04-16-2019, 02:39 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,830

    Re: Power Query results to a .csv file

    LOL!!!

    I'm up early after one of our cats decided to pee all over the hallway floor - that was a rude awakening, but definitely got me wide awake!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Link to OneDrive file in Power Query using 'Get data' from Web
    By rgsbouma in forum Excel General
    Replies: 6
    Last Post: 03-18-2019, 02:02 PM
  2. Power Query / retrieve many queries from different files in another XL file
    By Thyf in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-09-2019, 11:51 PM
  3. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  4. [SOLVED] Excel Power Query with file being used
    By taylorsm in forum Excel General
    Replies: 34
    Last Post: 11-02-2017, 05:57 PM
  5. [SOLVED] Power Query Not loading all Rows from Source File
    By jdriscol in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-21-2017, 04:03 PM
  6. How to add dbf file with over 1M rows to power query ?
    By wrybel in forum Excel General
    Replies: 11
    Last Post: 08-01-2017, 06:08 AM
  7. Power Query how do i reuse on a new file
    By thorrrr in forum Excel General
    Replies: 3
    Last Post: 05-03-2014, 02:07 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1