How do I Copy/ Paste a YAML.txt file text into Excel and keep the format?



  • I need help to get my YAML game code .txt file Copied into an Excel file to edit and track my game changes.
    The side by side columns in Excel makes it easier to track corrections, additions and deletion Edits.
    Then a paste back into NotePad++ to clean the excel format back into a game.txt file. I use to do this when it was JSON.
    When I try to Paste YAML into a Column in Excel, Excel adds = sign just before minus sign =- Text line and eliminates the 2 space between the - minus signs to the number Coords: and cuts off the last numbers to my coordinates after the 15th decimal place.
    I used NotePad++ in the past to clean off the excel formatting before uploading it back into my game.
    I can’t recall how or what I had done to make the JSON code copy/ paste into Excel. I assume whatever it was, I need to do the same again for the YAML code text?

    EXCEL PASTE EXAMPLE:

    name: Simon Templer’s Kadish Quest
    markers:

    • text: 4 letter name with a dash in it.
      age: Kadish
      coords:
      -68.8165130615234
      -174.776794433593
      -0.448601782321929
      =- text: I was wandering through the cavern city
      age: Kadish
      coords:
      -56.6250762939453
      -188.299011230468
      -16.009910583496
    • text: and ran into a player named ? ???
      age: Kadish
      coords:
      -167.317031860351
      -230.59422302246
      -17.1006202697753

    YAML .txt COPY to PASTE

    name: Simon Templer’s Kadish Quest
    markers:

    • text: 4 letter name with a dash in it.
      age: Kadish
      coords:
      • 68.81651306152344
      • 174.77679443359375
      • 0.44860178232192993
    • text: I was wandering through the cavern city
      age: Kadish
      coords:
      • 56.62507629394531
      • 188.29901123046875
      • 16.009910583496094
    • text: and ran into a player named ? ???
      age: Kadish
      coords:
      • 167.31703186035156
      • 230.59422302246094
      • 17.10062026977539

    I need to get a clean copy of the YAML Text into the Excel Column that I can edit and later Copy/ Paste back into NotePad++ and then Copy/ Paste back into the Game file for upload into my game.
    Sorry about example. The submit changes the - minus to dot and I don’t know why or how to prevent that



  • @Jahmen-Myst said in How do I Copy/ Paste a YAML.txt file text into Excel and keep the format?:

    I need help to get my YAML game code .txt file

    Excel will try to interpret any input. So if text it will look for columns and this can result in text that looks like numbers being made into numbers. Other changes can also occur. To prevent this I suggest having double quotes (that’s the default character to tell Excel not to alter the content) around each line. Then import and hopefully the line will remain unaltered. Then you can cut the pieces out of column A into the other columns as you require.

    Terry