Year: 2013

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 in Software, 0 comments