Monday, March 31, 2014

Convert Excel to CSV using UTF-8 encoding

On my mac OS X, Excel itself cannot directly save file as UTF-8 encoding. Here are the steps we can workaround.
  • 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