Monday, December 19, 2011

How do i export csv files into openoffice spreadsheet?

I'm having problems exporting a fairly long list of keywords from google keyword tool into my openoffice spreadsheet.


thanx|||Assuming you have a file named "keyword.csv"





Select the File menu.


Select the Open sub-menu.





In the Open dialog box:


Select the File of type: drop down menu and choose Text CSV [*.csv,*.txt,*.xls] option.


Select the "keyword.csv" file


Click the Open button.





In the Text Import dialog box:


Select the required Separator options i.e. tab, comma, etc.


Click OK button.

No comments:

Post a Comment