Hello,
yes you can use Excel to export CSV’s, however, it should be rather easy and very convenient if they added permanent sorting support to modify data tables rows!
That point stays valid in my humble opinion and should be a TO DO for the staff at Epic.
How to modify Data Tables and Re-Import to Editor
-
go to content browser, right click, export data table as CSV
-
next to your exported CSV, on desktop, create a new EXCEL sheet.
-
in EXCEL, go to Data /Import from Text or CSV, and choose your CSV sheet
-
check the detected data selection, and if needed, adjust, should usually be fine;
separation by comma.
HINT: I would suggest you do not use comma inside the cells as data in the head row;
Because it will be detected as cell separator falsly then easily, and generate empty columns. Happened to me.
-
then modify your data table contents as needed in EXCEL, for example,
in this case, click the top row top colum cell and select “sort from A to Z”. -
export as CSV from EXCEL
-
open same exported CSV again in Google Office, Open Office or Notepad, and save again as CSV. I have tried 4 different Excel CSV formates, they will not be successfully imported to UNREAL.
But Google Table CSV worked for me (simply open your CSV there online for free and download again!), and (link below) in another thread Open Office and Notepad had been confirmed by some Unreal Users. Apparently, Microsoft Excel does something to the basic structure of the CSV when saving that UE does not support on import.
Trouble importing csv from Excel - #6 by JaredTherriault -
re-import a new Data Table.
HINT: you cannot import, as long as the file is opened in EXCEL, it seems write-protected,
so close EXCEL when importing to Unreal.
You import by right-click in your folder in content browser and “import to (path)”.
Simply select data table, and the original struct you used for the unmodified data table, assuming that your structure is still the same. Be careful that it still matches the underlying STRUCT of your Data Table.
Worked for me 
Cheers