.csv export to excel?

Post author
Clara Hilgenfeld

Hello all,

I'm trying to turn my Crunchbase .csv export into an excel file but I'm facing the problem that, when using Excel's text to columns function, the commas used in the company description are detected as dividers. The description is then split up into several columns, which I obviously don't want. I've tried to manually add quotation marks around the description, which works, but I'm thinking that there has to be a better way to solve this problem. Does anyone have a solution?

Comments

1 comment

  • Comment author
    Veronica Robert

    I have faced the same problem I soved it importing CSV file directly from stata. Also Numbers (mac's spreadsheet) also works fine.

    0

Please sign in to leave a comment.