Using CSV with Excel - eisclimber/ExPresS-XR GitHub Wiki

Using CSV with Excel

If you are trying to read a normal CSV file on a German Windows OS, it will not be loaded correctly. CSV uses commas as separators, while (German) Excel and the DataGatherer use ";" as separators. This is to prevent interferences with commas inside the text, which will be generated, e.g., by Unity's ToString()-Methods.

How to load the CSV (in Excel after 2016):

  1. Create a new empty Excel-File.
  2. Select a cell where the data should be inserted.
  3. Go to "Data > Get Data > From File > From Text/CSV" (German: "Daten > Daten abrufen > Aus Datei > Aus Text/CSV") and select the file.
  4. Click Load & You are done.
⚠️ **GitHub.com Fallback** ⚠️