Forum Discussion

Ramsee's avatar
Ramsee
Copper Contributor
Sep 07, 2021

Csv file

When i download a csv file in excel all data is in one column. How do I change it do data is reflected in collumns

1 Reply

  • mathetes's avatar
    mathetes
    Gold Contributor

    Ramsee 

    Excel can import csv files and convert them into columns based on whatever separators are used in that csv file. "CSV" means "comma separated values," for starters, so the question back to you is "Are commas used as the separator in the file you're talking about?"

     

    Here's a YouTube video link on the normal "how to" 

    https://www.youtube.com/watch?v=ebnNy5yEkvc

     

     

     

Resources