Excel – Plain text to tab-delimited

Excel on non-English systems can suffer a bad limitation, namely it’s inability to properly interpret the csv format (comma separated value). Here is a tiny AppleScript code to fix this problem. It parses plain text from the first column of any csv opened in Excel into a tab-delimited layout, likely to be saved as a native Excel file.

tell application "Microsoft Excel"
    text to columns (range "A:A" of active sheet of active workbook) with comma
end tell

Posted by Benjamin

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.