- Save file to UTF-16 text file
Excel - Save as ... select "UTF-16 Unicode Text (.txt)" - Convert .txt file to UTF-8 format
Sublime Text -> Save with Encoding -> Select UTF-8 - Replace Tab with comma
Sublime Text -> Replace using regular expression (\t to replace ,) - Rename file from .txt to .csv extension
No comments:
Post a Comment