+ Reply to Thread
Results 1 to 6 of 6

Generate fake data sets for when posting Excel tables with data

  1. #1
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    4,665

    Generate fake data sets for when posting Excel tables with data

    When a user has a question and needs to post a table in Excel containing data it is inadvisable to post private and/or sensitive data.

    I have personally used the functionality (free) that is offered at https://www.fakenamegenerator.com/ to generate a large amount of data.
    There are many options to generate any amount of data for all purposes; professions, specific country related.

    Hope this tip helps.
    Hans
    "IT" Always crosses your path!
    May the (vba) code be with you... if it isn't; start debugging!
    If you like my answer, Click the * below to say thank-you ( It doesn't hurt )

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    46,917

    Re: Generate fake data sets for when posting Excel tables with data

    Useful to know, thanks for sharing
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    10-04-2018
    Location
    Cancun, Mexico
    MS-Off Ver
    2013 & 2016 32b
    Posts
    35

    Re: Generate fake data sets for when posting Excel tables with data

    nice one

  4. #4
    Registered User
    Join Date
    05-11-2019
    Location
    India
    MS-Off Ver
    2007
    Posts
    2

    Re: Generate fake data sets for when posting Excel tables with data

    good to know thanks
    Danish is working with It Training Centers.

  5. #5
    Forum Guru Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2019
    Posts
    5,081

    Re: Generate fake data sets for when posting Excel tables with data

    I have an alternative data generator here: https://excel.solutions/generatedata (powered by generatedata.com)
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  6. #6
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2016
    Posts
    4,665

    Re: Generate fake data sets for when posting Excel tables with data

    Looks good too, well, my idea was mainly to point out that you can generate fake data for sample files and you can go as deep as you want.
    Looks real, feels real and it's fake, what more do you want

+ 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