How to properly import csv file into Numbers Mac OS?

Question

csv

The essence of the problem is this, in office packages from MS, LibreOffice, etc., there is a choice of separator when importing, but in Numbers on MacOS it opens very strange, but in most cases everything is written line by line, but without columns and in the first cell, which is why terribly inconvenient to use.
Actually interested in how to choose a separator when viewing csv in Numbers

Answer 1

Numbers takes the separator settings from the regional settings. Therefore, in order to open csv with a tab as a separator, you need to switch the regional settings to North America, open the file and switch back. Or first open csv through a text editor and replace all tabs with semicolons or commas.
Well, or another option is to install LibreOffice. He eats everything with no problem.