Excel Easy Fake Data From Python In Excel - Episode 2660

[@tomniedringhaus2755]

This is just what I needed. I was looking for a way to get fake data to test a database.

[@Ticky66MN]

That is so cool! Thank you Bill!

[@mswordexpert]

dose this work for languages other than English.

[@MrXL]

You would have to edit one line of the Python code to specify a language. If you google "Python Faker Other Languages", you will get a list of the language codes that can be used.

[@hakankisa5002]

I have Microsoft 365, I tried Python in Excel, but I didn't find Python templates, Random Data Generator etc. ! ???

[@MrXL]

On the Insert tab in the Ribbon, to the right of the Function Library icons, do you have a Python group with the Insert Python icon? If you don't have it, go to File, Account. On the right, below About Excel, you should see four lines. The third line is the Version number and Build number. Below that is the update channel. Does it show Monthly or Semi-Monthly? Can you reply back and let me know what you see there?

[@ennykraft]

I teach Excel and creating fake data that feel realistic takes a lot of time. Unfortunately from what I've seen in this video this feature needs a lot of improvements. Someone in Ethiopia should have an Ethiopian name and address. But the text option ("Still must nice century. Human actually dream could country west along interesting. Score as big. Second hope something career material. Can left wife product.") is quite hilarious.

[@Koushiro-blmegtm]

Brother, the xmatch() function gives multiple different results for empty cells, isn't this an error? Example Fill in a few cells in the range A1:A100, leave the others blank, then enter XMATCH(A1:A50,A:A,0,-1) in cell B1. When you examine the results, you will see that XMATCH is working incorrectly.

[@MrXL]

Search mode of -1 is searching from the bottom of the range. Any reason you aren’t using the default 1 there?

[@Koushiro-blmegtm]

@MrXL I use it to filter the position of non-empty cells Shouldn't all empty cells give the location of the last row of column A:A? (-1)

[@MrXL]

@@Koushiro-blmegtm Empty cells should return the location of the last empty cell in column A, which is 1048576.

[@NO1808]

In principle, not bad, but the names don't really match the respective countries. ;-)

[@syrophenikan]

Nor do the emails, addresses, etc. It's like each field is generated irrespective of the other fields.

[@DIGITAL_COOKING]

I prefer do it with chatgpt