How to Fix a Messy CSV File

·

Hello! I upload a sorted csv file and it ends up being really messy. Anyone that knows how to fix this?

· Sorted by Oldest

Embla K.
·
·
https://app.clay.com/workspaces/206623/tables/t_ciQRd05djyPg/views/gv_5vOB0YFefBTw
Clay Team
APP
·
·
Hey, thanks for reaching out!
:thumbsup_all:1
Clay Team
APP
·
·
Based on the screenshot, it looks like the tool from where you're downloading the CSV from, it's downloading a semi-colon ";" separated list instead of a regular comma which may have caused this behavior. Also, make sure that the column header from your data set are the very first row in the CSV file so they get populated correctly.
Embla K.
·
·
Hello again! No mather what i do my files ends up like this. I have saved it as comma in a csv file but it sill ends up like this, do you have any tips?
Clay Team
APP
·
·
Sorry for the delay, what tool are you downloading this from, excel or another platform? Usually, google sheets tends to default to comma so we often recommend that but depends on the tool and their settings

Embla K.
·
·
https://app.clay.com/workspaces/206623/tables/t_ciQRd05djyPg/views/gv_5vOB0YFefBTw
Clay Team
APP
·
·
Hey, thanks for reaching out!
:thumbsup_all:1
Clay Team
APP
·
·
Based on the screenshot, it looks like the tool from where you're downloading the CSV from, it's downloading a semi-colon ";" separated list instead of a regular comma which may have caused this behavior. Also, make sure that the column header from your data set are the very first row in the CSV file so they get populated correctly.
Embla K.
·
·
Hello again! No mather what i do my files ends up like this. I have saved it as comma in a csv file but it sill ends up like this, do you have any tips?
Clay Team
APP
·
·
Sorry for the delay, what tool are you downloading this from, excel or another platform? Usually, google sheets tends to default to comma so we often recommend that but depends on the tool and their settings