How to correctly import data from a csv file into Google Sheets?

Question

csv

I'm trying to import a table with data from a csv file into Google Sheets.
The problem is that all data that can be converted to dates are automatically converted to these dates.
Instead of 3.8 (three point eight) the table shows 08/03/2014, which I don't need at all. Values ​​where the integer part is 0 or where there is no fractional part are displayed correctly.
I did not find an option similar to Excel, offering to choose a data format for each column during import.
Chrome browser.
Help me please.

Answer 1

Unfortunately, there is no elegant solution.
I had to do it in a crutch way:
1. Normal data import File - Import.
2. Select the desired columns and through Edit - Find and Replace... first replace ".2014" with "0" and then replace dots with commas.
Excel gives you more options in this regard.

Answer 2

And what about changing the dot to a comma with handles or what?
div by three seconds through substitution