I have the folder of txt files saved in both google drive and on my desktop. So far I can get power query to work with a small sample of files but when I try to do all of them I get the error that there is too much data. I am using a Mac with Microsoft 365. One problem is that these files do not contain the same amount of data nor do they have headings. I need to get the data from each into either one cell each (that we can expand to view), one column each, or even one sheet each as long as its within the same file.