How to import a csv file into MySQL workbench?

I guess you're missing the ENCLOSED BY clause

LOAD DATA LOCAL INFILE '/path/to/your/csv/file/model.csv'
INTO TABLE test.dummy FIELDS TERMINATED BY ','
ENCLOSED BY '"' LINES TERMINATED BY '\n';

And specify the csv file full path

Load Data Infile - MySQL documentation

In case you have smaller data set, a way to achieve it by GUI is:

1. Open a query window
2. SELECT * FROM [table_name]
3. Select Import from the menu bar
4. Press Apply on the bottom right below the Result Grid

Reference: http://www.youtube.com/watch?v=tnhJa_zYNVY

In the navigator under SCHEMAS, right click your schema/database and select "Table Data Import Wizard"

Works for mac too.