Csv file

%3CLINGO-SUB%20id%3D%22lingo-sub-2728041%22%20slang%3D%22en-US%22%3ECsv%20file%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2728041%22%20slang%3D%22en-US%22%3EWhen%20i%20download%20a%20csv%20file%20in%20excel%20all%20data%20is%20in%20one%20column.%20How%20do%20I%20change%20it%20do%20data%20is%20reflected%20in%20collumns%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2728041%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor
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

@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

 

 

 

In this video we are going to see How to Import CSV Files into Excel . Importing CSV Files into Excel is easy. We will see step by step process of Importing...