Select the CSV file and click "Open" to display the Text Import window. You can visualize how the data will be displayed in OpenOffice using the Preview pane near the bottom of the window.

The import feature in Numbers for iOS, iPadOS, and macOS can take data in the common comma-separated values (CSV) and tab-separated values (TSV) formats and parse that right into a spreadsheet’s ...