LibraOfficeで以下のようなデータをカンマ（,）区切りでセルに分けたい場合について試行錯誤したのでここにメモを残しておきます。
国籍 コード","国籍","時間軸（月次） コード","時間軸（月次）","全国・都道府県・大都市 コード","全国・都道府県・大都市","/性別","総数","男","女","総数","男","女","総数","男","女","総数","男","女 60000","移動者","2020001010","2020年10月","00000","全国",","208,821","106,509","102,312","161,380","90,419","70,961","161,380","90,419","70,961","0","0","0 60000","移動者","2020001010","2020年10月","01000","北海道",","12,659","6,225","6,434","3,462","2,018","1,444","3,108","1,738","1,370","354","280","74 60000","移動者","2020001010","2020年10月","02000","青森県",","1,021","501","520","1,191","726","465","1,100","656","444","91","70","21 60000","移動者","2020001010","2020年10月","03000","岩手県",","1,145","589","556","1,134","656","478","1,140","693","447","-6","-37","31 60000","移動者","2020001010","2020年10月","04000","宮城県",","4,117","2,032","2,085","2,839","1,669","1,170","2,754","1,599","1,155","85","70","15
カンマ区切りのデータをセル分割する手順
カンマ区切りのデータを選択
メニューから [データ]-[テキストから列へ] を選択
区切り設定
「テキストから列へ」というサブウィンドウが表示されるので「区切りのオプション」の [コンマ(C)] を選択します.
分割確認
「OK」をクリックするとカンマ区切りのデータが セルに分割されます。
ただ一列ずつしか変換できないのでまとめてやる方法はまだ調査中です。
