Main menu:
Annex 20: Various IT Advices
Level of expertise required for this Chapter: Intermediate
A20.1 Convert to CSV
For many Tools, you need data in CSV format. From Excel, you can create a CSV file:
Before you save it as a CSV file, be sure there are NO COMMAS in the entire table. You can search with the Find command, and replace all commas e.g. with hyphen (-) or similar.
Save As > Other Formats:
Save as type: CSV
There might be a warning message about multiple sheets: OK
Message for not compatible features: Yes
Saved!