News

Planning to create a Disavow File for Google? Learn how to extract domain names from URLs using Excel - and then add 'domain:' in front of each.
When working with Excel files that have different sheet names or layouts, Power Query can dynamically detect and extract the necessary data.
I have a bunch of DVDs, each filled with dozens of files. I want to create a list of the contents of these discs and put it into a spreadsheet. I want to list the file name, type and size. So far ...
When your boss hands you a file (regardless of the source) with thousands of URLs and says “manage this data,” the first task is to extract the domain names from the URLs.
Note: you can use “Append to file” button to save the data to an existing file. This is a useful option, if you are collecting this data for the whole site by going from page and page and ...