| Saving EXCEL spreadsheet as a CSV in Office |
1. In your Excel window go to the top menu and click on File followed by "Save as" in the drop down menu.
2. In the next window type in the name of your file in the file name box.
In the Save as file box use the scroll down to navigate through the files extension and choose either Text Csv (CSV) or Comma Separated (CSV) depending on your version of office. Please note that both are the same type of files.
3. On saving the file you may encounter one or two alerts informing you on two important thing that you must know when creating a cvs file.
You must delete any cells that are not to be displayed. E.g any blank cells to the right or at the bottom of the rows of data
You must delete any commas in the data cells. Replace with hyphens if necessary.
You set the text delimiters to "none".
Saving a file in csv format will save only one spreadsheet at a time so if your books contains multiple spreadsheet you will have to save them one by one as a different file.
|
|
Email this page to a friend
|
View our short introductory movie on how to use the Toolkit