.xlsx -> ServerDB ?

[Rivers]

Hello, I was wondering how I can either do one of two thing:
1) Pretty much just copy-paste my Excel formulas and information into the item and monster database (probably not possible)
2) Manually change monster's ATK~ATK, HP, FLEE (95%), HIT (100%), etc etc the easiest way. Number for number, regardless of what the stats (STR, DEX, INT, etc) say.

 

Is there anyway to do this?

(Sorry, I'm pretty new to this whole thing.)

Here's two examples of what it looks like:
 

[Winz]

If there is no cell depend on other cells, then you can copy everything and paste it to another text editor, like Notepad or Notepad++

 

After you paste them to your text editor (I'll explain only notepad and notepad++), you will see that each cells are separated by a single tab.

if you're using notepad, copy each one of those tabs, press Ctrl + H (find and replace), paste the tab on the "Find", and paste a comma [  ,  ] on the replace with.

then, replace all.

If you're using notepad++, press Ctrl + H (Find and replace), type [   \t   ] on the Find, and type a comma [  ,  ] on the "replace with". then, select search mode: extended.

 

don't just copy paste the thing I write. the things you put there shall have no white space, except the tab you copied.

 

make sure you copy everything properly. at last, do some cleaning up if needed.

number 2 is possible. just modify the values.

[Rivers]

Thank you.