citiescas.blogg.se

I'm trying to use Power Query to see if this works easier and quicker as an option at the moment.csv file in Notepad, copy data and paste in clean Excel workbook, then run text-to-column and set delimiter as pipe

csv file in Excel and set the delimiter to pipe. csv file in Excel because it reads it as a comma separator and I lose some data on certain rows because 1 of the columns' data has a comma in. I do realize the amount of data could be the problem of the file size? The files contain no formulas, conditional formatting or anything except the converted data, I did check for used range size and there are no extra empty cells after the last row or column. There are roughly 33 million cells of data (roughly 950 000 rows and 35 columns). When I convert them in Excel it's still quite big (150-190MB). csv file sizes are extremely big (300 to 330MB). The row separator is tab-delimited and the column separator is pipe-delimited (|).Ĭurrently the. I have data files that get extracted from an online system which is saved in.