Transactions
How do I convert my Excel spreadsheet to a CSV file?
You can convert an Excel spreadsheet to a CSV file by using the Save As command.
- Go to File > Save As
- The Save As dialog box will appear
- In the Save as type box, choose the CSV (Comma delimited) format
- Select the location that you wish to save the file to, then click Save
- You'll be shown a message reminding you that a CSV cannot have multiple worksheets, you can press OK on this.
- You may be prompted about features that may not be supported, you can press Yes. If you'd like to learn more you can click Help.
A CSV file cannot have multiple worksheets, so you should repeat the steps above to save each of your worksheets.