仔细看看里面的数据是怎么排的,特别要注意它们是怎么隔开的,比如是用逗号、空格还是Tab键。启动Excel,准备搬家:打开Excel,在上面找到“数据”这个小栏目,点进去,再找到“从文本获取数据”的按钮,点它!
Choose cell A1 - TAB - 【 】 from the text to find the file to import, select file > import > choose any a kind of simplified Chinese character in the original format - - choose the appropriate separator to the next step, set the column data type.