I cant import csv file to database

Igor Remeniuk

It is error - Sorry but this file doesn't appear to be a valid CSV. Please try again.[new.csv]

Michael Udinski

 https://docs.xano.com/database/importing-data/csv-file-import#valid-csv-file-format

Igor Remeniuk

I saw it and online csv validator says that it is ok, but xano no

Michael Udinski

 - Can you please follow what it says in the documentation and the instructions to check with something like a text/code editor as an online tool might not be checking for a valid import format

Michael Udinski

 - I just looked and your file is not comma separated, instead it is semi colon separated - please change this to comma separated for the import to work

[CleanShot 2022-01-07 at 11.32.36.png]

David Richardson

Hi Michael
I have a similar issue. I've used the search and replace in Excel to remove all commas and “#” characters and saved two rows of data as CSV UTF-8 to no avail. Then to meet the XANO criteria of the file upload requirements I saved the file as txt in notepad++.

data set us-500 business short normal text file.txt

What am I missing?

Jeff Strang

I am also having this issue with simple csv files produced on a mac in excel or via Google Sheets, or even edited and saved from VSCode. Several csv validators all say no problem. The issue doesn't appear for more complex files, only super simple ones when I am trying to speed-up the creation of tables by importing a simple CSV.