[FIXED] How to properly import .csv file into Tableau?

Issue

I've exported a dataframe from R into a .csv file and then tried to open it in Tableau. What is the correct way to import these files? I've done connect to data source > to a file > text file then simply clicked on the csv.

However, the columns and rows are all mixed up and I'm not sure what's gone wrong as the files can open in Numbers and Excel just fine!

Please see the incorrectly imported data rem_posts.csv and correctly imported data kylie_posts.csv.

Solution

It was an issue with some columns having string data with commas in it so it was messing up the import when using csv format. I resolved this by exporting it in excel instead.

Answered By - Amanda Lim

Answer Checked By - Katrina (PHPFixing Volunteer)