Pehea e hoʻololi ai i nā faila Excel i ka format CSV

CSV (Comma Separated Values) he ʻano maʻamau no ka mālama ʻana i ka ʻikepili papa (helu a me ka kikokikona) ma ka kikokikona maʻamau. He mea kaulana a paʻa kēia ʻano faila ma muli o ka nui o nā polokalamu a me nā noi e hoʻomaopopo iā CSV, ma ka liʻiliʻi loa ma ke ʻano he ʻano faila ʻē aʻe no ka lawe ʻana mai / lawe aku. Eia kekahi, ʻo ka format CSV e hiki ai i ka mea hoʻohana ke nānā i ka faila a ʻike koke i kahi pilikia me ka ʻikepili, inā he, e hoʻololi i ka delimiter CSV, e ʻōlelo ana i nā lula, a pēlā aku. Hiki kēia no ka mea he kikokikona maʻalahi ʻo CSV, a hiki i ka mea hoʻohana ʻike ʻole ke hoʻomaopopo maʻalahi me ka ʻole o ka hoʻomaʻamaʻa kūikawā.

Ma kēia ʻatikala, e aʻo mākou i nā ala wikiwiki a maikaʻi hoʻi e hoʻokuʻu aku i ka ʻikepili mai Excel a i CSV a aʻo pehea e hoʻohuli ai i kahi faila Excel i CSV me ka hoʻohuli ʻole ʻana i nā huaʻōlelo kūikawā a me nā haole. Hana nā ʻenehana i wehewehe ʻia ma ka ʻatikala ma nā mana āpau o Excel 2013, 2010 a me 2007.

• E hoʻohuli i ka ʻikepili mai Excel i ka format CSV
• Hoʻokuʻu aku mai Excel i ka CSV UTF-8 a i ʻole UTF-16 format
• ʻO nā ala ʻē aʻe e hoʻohuli ai mai Excel a i CSV (mālama i nā huaʻōlelo kūikawā)

Pehea e hoʻololi ai i ka faila Excel i CSV

Inā makemake ʻoe e hoʻokuʻu aku i ka faila Excel i kekahi palapala noi ʻē aʻe, e like me kahi puke helu Outlook a i ʻole kahi waihona Access, e hoʻololi mua i ka pepa Excel i kahi faila CSV, a laila e hoʻokomo i ka faila. . Csv i kekahi palapala noi. ʻO kēia ka ʻanuʻu aʻe i ke alakaʻi i ka pehea e hoʻoiho ai i kahi puke hana Excel i ka format CSV me ka hoʻohana ʻana i ka mea hana Excel - "E mālama i".

1. Ma kahi puke hana Excel, wehe i ka pā File (File) a kaomi E mālama i (Save as). Eia hou, ka pahu kamaʻilio Mālama i kahi palapala (Save as) hiki ke wehe ʻia ma ke kaomi ʻana i ke kī F12.
2. I ka Pūnae Puna (Save as type) koho CSV (hoʻokaʻawale ʻia e nā koma) (CSV (Hoʻopau koma)).Ma waho aʻe o CSV (ka palena koma), loaʻa kekahi mau koho hōʻano CSV ʻē aʻe:
   • CSV (hoʻokaʻawale ʻia e nā koma) (CSV (Hoʻopau koma)). Mālama kēia ʻano i ka ʻikepili Excel ma ke ʻano he faila kikokikona i hoʻokaʻawale ʻia i ke koma a hiki ke hoʻohana ʻia i kahi polokalamu Windows ʻē aʻe a ma kahi ʻano ʻē aʻe o ka ʻōnaehana hana Windows.
   • CSV (Macintosh). Mālama kēia ʻano i kahi puke hana Excel ma ke ʻano he faila i hoʻokaʻawale ʻia no ka hoʻohana ʻana ma ka ʻōnaehana hana Mac.
   • CSV (MS DOS). Mālama i kahi puke hana Excel ma ke ʻano he faila i hoʻokaʻawale ʻia no ka hoʻohana ʻana ma ka ʻōnaehana hana MS-DOS.
   • kikokikona unicode (Kikokikona Unicode (*txt)). Kākoʻo ʻia kēia maʻamau e kokoke i nā ʻōnaehana hana āpau, me Windows, Macintosh, Linux, a me Solaris Unix. Kākoʻo ia i nā huaʻōlelo mai nā ʻōlelo a pau o kēia wā a me kekahi mau ʻōlelo kahiko. No laila, inā loaʻa i kahi puke haʻawina Excel ka ʻikepili ma nā ʻōlelo ʻē, manaʻo wau e mālama mua ʻoe iā ia ma ke ʻano kikokikona unicode (Unicode Text (*txt)), a laila e hoʻololi i CSV e like me ia i wehewehe ʻia ma hope ma Export mai Excel i UTF-8 a i ʻole UTF-16 CSV format.

'Ōlelo Aʻo: ʻO nā palapala i ʻōlelo ʻia e mālama wale i ka pepa Excel ikaika.

3. E koho i kahi waihona e mālama i ka faila CSV a kaomi Save (Save).Ma hope o ke kaomi ʻana Save (Save) ʻelua pahu kamaʻilio e ʻike ʻia. Mai hopohopo, ʻaʻole hōʻike kēia mau memo i kahi hewa, ʻo ia ke ʻano.
4. Hoʻomanaʻo ka pahu kamaʻilio mua iā ʻoe Hiki ke mālama ʻia ka pepa o kēia manawa ma ka faila o ke ʻano i koho ʻia (ʻAʻole kākoʻo ke ʻano faila i koho ʻia i nā puke haʻawina i loaʻa nā pepa he nui). No ka mālama ʻana i ka pepa o kēia manawa, kaomi wale OK.Inā makemake ʻoe e mālama i nā pepa a pau o ka puke, a laila kaomi ka hoʻokuʻu (Hoʻopau) a mālama i nā pepa a pau o ka puke me nā inoa faila kūpono, a i ʻole hiki iā ʻoe ke koho e mālama i kekahi ʻano faila e kākoʻo ana i nā ʻaoʻao he nui.
5. Ma hope o ke kaomi OK i ka pahu kamaʻilio mua, e ʻike ʻia kahi lua, e ʻōlelo ana e lilo ana kekahi mau hiʻohiʻona no ka mea ʻaʻole i kākoʻo ʻia e ka format CSV. Penei ka pono, no laila kaomi wale ʻAe (Ae).

ʻO kēia ke ʻano e mālama ʻia ai kahi pepa hana Excel ma ke ʻano he faila CSV. ʻO ka wikiwiki a me ka maʻalahi, a hikiʻole ke ala mai nā pilikia maʻaneʻi.

Hoʻokuʻu aku mai Excel i CSV me UTF-8 a i ʻole UTF-16 hoʻopili

Inā loaʻa i ka pepa Excel nā huaʻōlelo kūikawā a i ʻole nā ​​​​mea ʻē aʻe (tilde, accent, a me nā mea like) a i ʻole hieroglyphs, a laila ʻaʻole e holo ka hoʻololi ʻana i ka pepa Excel i CSV ma ke ʻano i hōʻike ʻia ma luna nei.

ʻO ka manaʻo o ka hui E mālama i > CSV (Save as > CSV) e hoʻopau i nā huaʻōlelo a pau koe ka ASCII (American Standard Code for Information Interchange). A inā loaʻa nā huaʻōlelo pālua a i ʻole nā ​​kaha lōʻihi ma ka pepa Excel (hoʻololi ʻia i Excel, no ka laʻana, mai kahi palapala Word i ka wā e kope ai / paʻi ʻana i nā kikokikona) - e ʻoki ʻia kēlā mau ʻano.

Hoʻoponopono maʻalahi - mālama i ka pepa Excel ma ke ʻano he faila kikokikona Unicode(.txt), a laila hoʻololi iā ia i CSV. Ma kēia ala, e paʻa mau nā huaʻōlelo non-ASCII.

Ma mua o ka neʻe ʻana, e wehewehe pōkole wau i nā ʻokoʻa nui ma waena o nā hoʻopāpā UTF-8 a me UTF-16, i hiki iā ʻoe ke koho i ke ʻano kūpono i kēlā me kēia hihia:

• UTF-8 he hoʻopili paʻa paʻa e hoʻohana ana i ka 1 a 4 paita no kēlā me kēia ʻano. Manaʻo pinepine ʻia e hoʻohana i kēia ʻano i ka wā e ʻoi aku ka nui o nā huaʻōlelo ASCII i ka faila, no ka mea, ʻo ka hapa nui o kēia mau huaʻōlelo e koi i ka 1 byte o ka hoʻomanaʻo. ʻO kekahi pōmaikaʻi ʻē aʻe ʻo ka hoʻopili ʻana o kahi faila UTF-8 i loaʻa nā huaʻōlelo ASCII wale nō ʻaʻole e ʻokoʻa ma kekahi ʻano mai ka faila ASCII like.
• UTF-16 hoʻohana i ka 2 a i ka 4 bytes e mālama i kēlā me kēia ʻano. E ʻoluʻolu e hoʻomaopopo ʻaʻole i nā hihia a pau e koi ʻia kahi faila UTF-16 ma mua o kahi faila UTF-8. No ka laʻana, lawe nā huaʻōlelo Kepani i 3 a 4 paita ma UTF-8 a me 2 a 4 paita ma UTF-16. No laila, kūpono ke hoʻohana ʻana i ka UTF-16 inā loaʻa i ka ʻikepili nā huaʻōlelo ʻAsia, me ka Japanese, Kina, a me Korea. ʻO ka hemahema nui o kēia hoʻopili ʻana ʻo ia ʻaʻole kūpono piha me nā faila ASCII a koi i nā polokalamu kūikawā e hōʻike i kēlā mau faila. E hoʻomanaʻo i kēia inā hoʻolālā ʻoe e hoʻokomo i nā faila i loaʻa mai Excel ma kahi ʻē aʻe.

Pehea e hoʻololi ai i ka faila Excel i CSV UTF-8

Inā paha he pepa Excel kā mākou me nā huaʻōlelo haole, i kā mākou laʻana he mau inoa Iapana.

No ka hoʻokuʻu aku i kēia pepa Excel i kahi faila CSV, ʻoiai e mālama ana i nā hieroglyphs āpau, e hana mākou i kēia:

1. Ma Excel, wehe i ka pā File (File) a kaomi E mālama i (Save as).
2. E hoʻokomo i ka inoa faila ma ke kahua Pūnae Puna (Save as type) koho kikokikona unicode (Unicode Text (*.txt)) a kaomi Save (Mālama).
3. E wehe i ka faila i hana ʻia ma kekahi mea hoʻoponopono kikokikona maʻamau, e like me Notepad.

'Ōlelo Aʻo: ʻAʻole kākoʻo piha nā mea hoʻoponopono kikokikona maʻalahi i nā huaʻōlelo Unicode, no laila e ʻike ʻia kekahi ma ke ʻano he mau ʻāpana. I ka hapanui o nā hihia, ʻaʻole e pili kēia i ka faila hope ma kekahi ʻano, a hiki iā ʻoe ke haʻalele iā ia a koho paha i kahi mea hoʻoponopono ʻoi aku ka holomua, e like me Notepad++.

4. Ma muli o ka hoʻohana ʻana o kā mākou waihona kikokikona Unicode i ke ʻano o ka ʻaoʻao ma ke ʻano he mea hoʻokaʻawale, a makemake mākou e hoʻololi iā ia i CSV (koma i hoʻokaʻawale ʻia), pono mākou e hoʻololi i nā huapalapala tab me nā koma.

'Ōlelo Aʻo: Inā ʻaʻohe pono koʻikoʻi e kiʻi i kahi faila me nā palena koma, akā pono ʻoe i kahi faila CSV i hiki iā Excel ke hoʻomaopopo, a laila hiki ke hoʻokuʻu ʻia kēia ʻanuʻu, no ka mea, hoʻomaopopo pono ʻo Microsoft Excel i nā faila me kahi delimiter - tabulation.

4. Inā makemake ʻoe i kahi faila CSV (i hoʻokaʻawale ʻia e nā koma), a laila e hana i kēia ma Notepad:
   • E koho i ke ʻano o ka pā, kaomi ʻākau iā ia, a ma ka papa kuhikuhi, kaomi ke kope (Kopi), a kaomi wale Ctrl + Ce like me ka mea i hoikeia ma ke kii malalo.
   • Press Ctrl + He wehe i ka pahu kamaʻilio E hoʻololi hou (Hoʻololi) a hoʻopili i ke ʻano o ka pā i kope ʻia i loko o ke kahua ia (E huli i ka mea). I kēia hihia, e neʻe ka cursor i ka ʻākau - ʻo ia ka mea e hoʻokomo ʻia kahi ʻano tab. Ma ke kula mamua o (Hoʻololi me) e hoʻokomo i kahi koma a kaomi Hoʻopili i nā mea a pau (Hoʻololi i nā mea a pau).

   Ma Notepad, e like ka hopena me kēia:

   

5. Bus File > E mālama i (File> Save as), e hoʻokomo i kahi inoa no ka faila a ma ka papa inoa hāʻule Hoʻopā'ālua (Encoding) koho UTF-8… A laila kaomi i ke pihi Save (Mālama).
6. E wehe i ka Windows Explorer a hoʻololi i ka hoʻonui faila mai .txt on . Csv.E hoʻololi i ka hoʻonui ʻokoʻa .txt on . Csv Hiki iā ʻoe ke hana pololei ma Notepad. No ka hana ʻana i kēia, ma ka pahu dialog E mālama i (Save as) ma ke kahua Pūnae Puna (E mālama i ke ʻano) koho i kahi koho Nā faila āpau (Nā waihona āpau), a hoʻohui i ka ".csv" i ka inoa faila ma ke kahua kūpono, e like me ka hōʻike ʻana ma ke kiʻi ma lalo nei.
7. E wehe i ka faila CSV ma Excel, no kēia, ma ka pā File (Filet) kawili Open > Nā kikokikona pūnaewele (Wehe > Nā faila kikokikona) a nānā inā maikaʻi ka ʻikepili.

'Ōlelo Aʻo: Inā makemake ʻia kāu faila e hoʻohana ma waho o Excel a he koi ʻo UTF-8, a laila, mai hoʻololi i ka pepa a mai mālama hou iā ia ma Excel, no ka mea hiki ke pilikia i ka heluhelu ʻana i ke code. Inā ʻaʻole i hōʻike ʻia kekahi hapa o ka ʻikepili ma Excel, e wehe i ka faila like ma Notepad a hoʻoponopono i ka ʻikepili i loko. Mai poina e mālama hou i ka faila ma ka ʻano UTF-8.

Pehea e hoʻololi ai i ka faila Excel i CSV UTF-16

ʻOi aku ka wikiwiki a me ka maʻalahi o ka lawe ʻana aku i kahi faila UTF-16 CSV ma mua o ka lawe ʻana i UTF-8. ʻO ka mea ʻoiaʻiʻo, hoʻohana ʻo Excel i ka format UTF-16 ke mālama ʻoe i ka faila kikokikona unicode (Unicode kikokikona).

No ka hana ʻana i kēia, mālama i ka faila me ka hoʻohana ʻana i ka hāmeʻa E mālama i (Save as) ma Excel a laila ma Windows Explorer, hoʻololi i ka hoʻonui o ka faila i hana ʻia . Csv. Hana ʻia!

Inā makemake ʻoe i faila CSV me kahi semicolon a i ʻole semicolon ma ke ʻano he delimiter, e hoʻololi i nā huaʻōlelo tab āpau me nā koma a i ʻole semicolons ma Notepad a i ʻole kekahi mea hoʻoponopono kikokikona āu e koho ai (e ʻike ma mua o kēia ʻatikala no nā kuhikuhi kikoʻī i ka hana ʻana i kēia).

Nā ala ʻē aʻe e hoʻohuli ai i nā faila Excel i CSV

ʻO nā ʻano hana i hōʻike ʻia ma luna nei no ka lawe ʻana i ka ʻikepili mai Excel a i CSV (UTF-8 a me UTF-16) he ākea, ʻo ia hoʻi, kūpono no ka hana ʻana me nā ʻano kikoʻī kūikawā a i kēlā me kēia mana o Excel mai 2003 a 2013.

Nui nā ala ʻē aʻe e hoʻololi i ka ʻikepili mai Excel i ka format CSV. ʻAʻole e like me nā hoʻonā i hōʻike ʻia ma luna nei, ʻaʻole e hopena kēia mau ʻano i kahi faila UTF-8 maʻemaʻe (ʻaʻole pili kēia iā OpenOffice, hiki ke hoʻokuʻu aku i nā faila Excel i kekahi mau koho hoʻopili UTF). Akā i ka hapanui o nā hihia, e loaʻa i ka faila ka hopena i ka hoʻonohonoho ʻano kūpono, a laila hiki ke hoʻololi ʻia i ka format UTF-8 me ka hoʻohana ʻana i kekahi mea hoʻoponopono kikokikona.

E hoʻololi i ka faila Excel i CSV me ka hoʻohana ʻana i nā palapala Google

E like me ka mea i ʻike ʻia, maʻalahi loa ka hoʻololi ʻana i kahi faila Excel i CSV me ka hoʻohana ʻana i nā Google Sheets. Inā ua hoʻokomo ʻia ʻo Google Drive ma kāu kamepiula, e hahai i kēia mau hana maʻalahi 5:

1. Ma Google Drive kaomi i ke pihi Hoʻoulu (Hana) a koho papaʻaina (Pāpalapala).
2. Ma ka papa kuhikuhi File (Filet) kawili Import (Hoʻokomo).
3. Bus Download (Hoʻouka) a koho i ka faila Excel e hoʻouka mai kāu kamepiula.
4. I ka pahu kamaʻilio Impwaihona ort (Kai waihona) koho E pani i ka papaʻaina (Hoʻololi i ka pāpalapala) a kaomi Import (Hoʻokomo).

mana'o kōkua: Inā liʻiliʻi liʻiliʻi ka faila Excel, a laila e mālama i ka manawa, hiki iā ʻoe ke hoʻololi i ka ʻikepili mai ia mea i kahi pālahalaha Google me ka hoʻohana kope / paʻi.

5. Ma ka papa kuhikuhi File (Filet) kawili Hoʻoiliʻia ma (Download as), koho i ke ʻano faila CSV - e mālama ʻia ka faila ma ke kamepiula.

ʻO ka hope, wehe i ka faila CSV i hana ʻia i loko o kekahi mea hoʻoponopono kikokikona e hōʻoia i ka mālama pono ʻana o nā huaʻōlelo āpau. ʻO ka mea pōʻino, ʻaʻole hōʻike pololei nā faila CSV i Excel.

E mālama i ka faila .xlsx ma ke ʻano he .xls a laila e hoʻololi i ka faila CSV

ʻAʻole koi kēia ʻano i nā manaʻo ʻē aʻe, no ka mea ua maopopo nā mea āpau mai ka inoa.

Ua loaʻa iaʻu kēia hoʻonā ma kekahi o nā ʻaha kūkā i hoʻolaʻa ʻia iā Excel, ʻaʻole wau e hoʻomanaʻo i kahi. ʻO kaʻoiaʻiʻo, ʻaʻole wau i hoʻohana i kēia ʻano, akā e like me ka nui o nā mea hoʻohana, nalowale kekahi mau kikoʻī kūikawā ke mālama pololei mai . Xlsx в . Csv, aka e noho ina mua . Xlsx koe wale nō .xls, a laila like . Csv, e like me kā mākou i hana ai ma ka hoʻomaka ʻana o kēia ʻatikala.

Eia nō naʻe, e hoʻāʻo i kēia ʻano hana o ka hoʻokumu ʻana i nā faila CSV mai Excel nou iho, a inā hana ia, e lilo ia i mea mālama manawa maikaʻi.

Mālama i kahi faila Excel ma CSV me OpenOffice

ʻO OpenOffice kahi papa hana open source o nā noi e loaʻa ana kahi palapala pālahalaha e hana nui i ka lawe ʻana i ka ʻikepili mai Excel a i ka format CSV. ʻO ka ʻoiaʻiʻo, hāʻawi kēia noi iā ʻoe i ke komo ʻana i nā koho hou aʻe i ka wā e hoʻohuli ai i nā pāpalapala i nā faila CSV (encoding, delimiters, a pēlā aku) ma mua o Excel a me Google Sheets i hui pū ʻia.

E wehe wale i ka faila Excel ma OpenOffice Calc, kaomi File > E mālama i (File > Save as) a koho i ke ʻano faila kikokikona CSV (Kimo CSV).

ʻO ka hana aʻe, ʻo ia ke koho ʻana i nā waiwai parameter Hoʻopā'ālua (Hōʻano pūʻulu) и Māhele hoʻokaʻawale (Ka mea wehewehe kahua). ʻOiaʻiʻo, inā makemake mākou e hana i kahi faila UTF-8 CSV me nā koma ma ke ʻano he mea hoʻokaʻawale, a laila koho UTF-8 a e hookomo i ke koma (,) ma na kahua kupono. ʻĀpana Mea hoʻokaʻawale kikokikona (Text delimiter) waiho ʻia ʻaʻole i hoʻololi ʻia – kaha puanaʻi (“). Kaomi aʻe OK.

Ma ke ala like, no ka hoʻololi wikiwiki a me ka ʻeha ʻole mai Excel i CSV, hiki iā ʻoe ke hoʻohana i kahi noi ʻē aʻe - LibreOffice. ʻAe, maikaʻi inā hāʻawi ʻo Microsoft Excel i ka hiki ke hoʻoponopono i nā hoʻonohonoho i ka wā e hana ai i nā faila CSV.

Ma kēia ʻatikala, ua kamaʻilio wau e pili ana i nā ala aʻu i ʻike ai e pili ana i ka hoʻololi ʻana i nā faila Excel i CSV. Inā ʻike ʻoe i nā ala ʻoi aku ka maikaʻi no ka lawe ʻana mai Excel i CSV, e ʻoluʻolu e haʻi mai iā mākou ma nā ʻōlelo. Mahalo iā ʻoe no ka nānā ʻana!