+ Reply to Thread
Results 1 to 17 of 17

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 2021 (Windows)
    Posts
    7,905

    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

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,926

    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
    78

    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 Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    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 2021 (Windows)
    Posts
    7,905

    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

  7. #7
    Registered User
    Join Date
    11-11-2019
    Location
    Spain
    MS-Off Ver
    2007
    Posts
    1

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

    Great, thanx for sharing!

  8. #8
    Registered User
    Join Date
    12-21-2022
    Location
    San Jose, CA
    MS-Off Ver
    Office 365
    Posts
    1

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

    Great tool. Thank you for sharing!

  9. #9
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

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

    I prefer this one

    https://generatedata.com/

  10. #10
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

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

    Hi @sandy666,
    Nice site, works fast

  11. #11
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

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

    Hi Keebellah,
    unfortunately older version was much better but maybe I'm old fashioned

  12. #12
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

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

    I'll stick to the one I used before that because the generatde fake names are realistic for the region and languag you select but for a quick-and-dirty this one works great

  13. #13
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

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

    I would like to find a website that generates 10 thousands or more records but no luck
    however 500 rows is better than nothing

  14. #14
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

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

    The site I first posted is less limited try and see
    And like I mentioned it’s more realistic

  15. #15
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

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

    it doesn't matter if it's realistic or not, it's usually for testing or an example for someone else, however an email (which can't be fake) is required to get the max number of records (100000) so I'm sticking with my generator.
    if it generated an account number and a pin/password for it that could be used in the real world then this would be much more useful
    everyone has their preferences

  16. #16
    Forum Expert Keebellah's Avatar
    Join Date
    01-12-2014
    Location
    The Netherlands
    MS-Off Ver
    Office 2021 (Windows)
    Posts
    7,905

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

    Clear
    Have a happy new year 🎆

  17. #17
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

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

    2 u 2

    Name:  hny.png
Views: 102
Size:  11.6 KB

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. generate fake emails for Wordpree on 36,000 names
    By SWMagic in forum Excel General
    Replies: 5
    Last Post: 01-30-2017, 05:26 PM
  2. Any website can generate large number of fake addresses?
    By niuyuer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-16-2016, 12:06 PM
  3. How to use Excel data to generate new comparison tables
    By prk91 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2015, 12:34 PM
  4. Replies: 2
    Last Post: 11-30-2014, 08:19 PM
  5. Replies: 1
    Last Post: 03-19-2014, 01:00 PM
  6. Combining two data sets (tables), with one common denominatior
    By lomacm in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 05-29-2013, 02:59 AM

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