need help importing a Market Samurai CSV file into Excel

Jacky Chase · 05-08-2011, 08:01 PM

Hello! This is my very first post.

I did some keyword research in Market Samurai and saved the results as a CSV file. Now I would like to open the file in Excel (2003), but it looks very chaotic because all the infos and numbers (keyword, SEOT, SEOC, SEOV etc) are in the same cell! Same goes for every keyword.

I tried the importing Wizard (Data -> Import External Data) and followed the Importing wizard, but it's all very complicated and in the end it still looks totally garbled.

Could anyone help? I attached a screenshot.

timpears · 05-08-2011, 09:22 PM

It should open up in Excel with no problem. CSV is Comma Seperated Values file, and you can open or save that type of file with Excel. I use the 2003 version myself, and I use a lot of CSV files.

Excel can open text files also, so if you have a list of data or URLs, it will also open up in Excel and then you can manipulate it. If you arrange your data in a text file and separate the data with commas, you can use Excel to sort and arrange it also.

So, just open the file with Excel and don't worry.

Jacky Chase · 05-08-2011, 10:14 PM

Hi Tim

Thanks for trying to help! But did you click the screenshot I attached, at the bottom of my post? I can open the CSV file with Excel, no problem with that..but I can't actually do work with the table looking like that, because all the information is crammed into one cell. I can't sort data like that.

Please click the screenshot thumbnail, it will give you an idea of what I'm talking about!

Charlie A · 08-04-2011, 04:06 AM

Hey Jacky, did you ever figure that out? I'm having the same problem.

05-08-2011, 08:01 PM	#1
Jacky Chase Warrior Member Join Date: Mar 2011 Posts: 6 Thanks: 3 Thanked 0 Times in 0 Posts	need help importing a Market Samurai CSV file into Excel Hello! This is my very first post. I did some keyword research in Market Samurai and saved the results as a CSV file. Now I would like to open the file in Excel (2003), but it looks very chaotic because all the infos and numbers (keyword, SEOT, SEOC, SEOV etc) are in the same cell! Same goes for every keyword. I tried the importing Wizard (Data -> Import External Data) and followed the Importing wizard, but it's all very complicated and in the end it still looks totally garbled. Could anyone help? I attached a screenshot. Attached Thumbnails

05-08-2011, 09:22 PM	#2
timpears Senior Warrior Member War Room Member Join Date: Jul 2008 Location: Vancouver, WA, USA. Posts: 3,500 Thanks: 327 Thanked 584 Times in 408 Posts	Re: need help importing a Market Samurai CSV file into Excel It should open up in Excel with no problem. CSV is Comma Seperated Values file, and you can open or save that type of file with Excel. I use the 2003 version myself, and I use a lot of CSV files. Excel can open text files also, so if you have a list of data or URLs, it will also open up in Excel and then you can manipulate it. If you arrange your data in a text file and separate the data with commas, you can use Excel to sort and arrange it also. So, just open the file with Excel and don't worry.
	Tim Pears

05-08-2011, 10:14 PM	#3
Jacky Chase Warrior Member Join Date: Mar 2011 Posts: 6 Thanks: 3 Thanked 0 Times in 0 Posts	Re: need help importing a Market Samurai CSV file into Excel Hi Tim Thanks for trying to help! But did you click the screenshot I attached, at the bottom of my post? I can open the CSV file with Excel, no problem with that..but I can't actually do work with the table looking like that, because all the information is crammed into one cell. I can't sort data like that. Please click the screenshot thumbnail, it will give you an idea of what I'm talking about!

08-04-2011, 04:06 AM	#4
Charlie A Active Warrior Join Date: Sep 2010 Location: Sweden/Canada Posts: 74 Thanks: 12 Thanked 10 Times in 8 Posts	Re: need help importing a Market Samurai CSV file into Excel Hey Jacky, did you ever figure that out? I'm having the same problem.
	Dallas Movers