CODEWITHSUNDEEP
ioscsvparse-platform
saner
saner

Reputation: 821

Uploading Data With CSV File to Parse

I am trying to upload a csv file to my parse database. I created all versions of CSV files (mac, windows, comma delimited vs.) but whenever I try to import, all the columns are merged as one column in parse. Below are the views of my csv file and the view in parse. How can I distribute them separately to separate columns. Any ideas?

excel image

parse view

Upvotes: 0

Views: 376

Answers (1)

Nils Ziehn
Nils Ziehn

Reputation: 4331

The reason why you have this problem is because you have ';' as your separator, not a ',' how it is supposed to be in CSV.

This can unfortunately only be changed through the operating system settings and not on excel export (on both mac and windows machines).

The most feasible way for you would be to export to a 'tab-separated' file and then just Find-Replace the 'tabs' with ','

(You can find and replace 'tabs' in most editors by just copy pasting an existing tab into the search field)

Upvotes: 1

Related Questions