There's another way PowerShell will convert text into tables.

$text = "1 fantasy West Tour 216406 2014-01-21 data sheet 2 furnace stone legends 15905 2014-01-24 3 new big talk West Tour 214465 2002-08-01 gauge 4 asked 11322 2006-04-22 5 fertile soil 1009  4 in 2014-04-23 6 QQ Fairy 10056 2014-06-06 public test 7 Shenwu 10011 2010-09-17 male 8 Heroes Q pass 9576 2014-06-27 9 goddess three 9343 2014-06-28 10 champions Duel 8809 2014-04-23 11 I want to seal the day 4447 2014-07-05 public Test 12 Taoyuan will be recorded 4324 2012-05-24 male 13 god 3899 2011-11-24 14 fairy tale 3779 2013-07-20 inside measured 15 Dream Sui Tang 3462 2014-07-11 public test 16 Peach Blossom Garden 3289 2013-06-21 17 God-carved man 3112 2012-09-20 beta 18 West Tour 2516 2012-08-31 limited to 19 fantasy sin 22421 200 9-10-22 203 countries chopped 2313 2010-04-28 "[email protected] ()  $text. Split (" ' N ", [StringSplitOptions]:: Removeemptyentries) |  %{$game = "" |select rank, game name, heat value, date, status, Notes $game. Ranking =$_.split () [0] $game. Game name =$_.split () [1] $game. Heat value =$_.split () [2]$ Game. Date =$_.split () [3] $game. Status =$_.split () [4] $t 1+= $game}  $t 1| Export-csv "Games.csv"-not-enc oem

PowerShell also has a way of converting text into tables