A comma-separated value (CSV) file exported from Excel won load. Whats wrong?
If you are using Microsoft Excel to build up a comma-separated value (CSV) file to import into BioTapestry, you need to save it as a “CSV” file to load it in. But it turns out in some configurations, Excel will create a comma-separated value file that doesn’t use commas to separate the values. In at least some versions of Windows, it turns out that Excel chooses to use the regional settings for formatting the CSV file. In some European localizations, this means that semicolons are used instead of commas. If you computer is regionalized to a European setting that doesn’t use commas, the following fix seems to work. Change the separator in a CSV text file: 1. Click the Windows Start menu. 2. Click Control Panel. 3. Open the Regional and Language Options dialog box. 4. Click the Regional Options Tab. 5. Click Customize. 6. Type a new separator in the List separator box. 7. Click OK twice. So if you think this might be an issue, take a look at your CSV file in a text editor make sure it is
Related Questions
- I have my records in a CSV file exported from Excel or some other software/application that I would like to bring them to aCar. What should I do?
- Can I import a comma-separated value (CSV) file that lists a courses events into my desktop email client calendar?
- Can I set experimental evidence levels for links in the comma-separated value (CSV) input file?
