Tutorial Open CSV in Excel
If you want to open CSV files in MS. Excel (.xls or .xlsx), you can do the following steps:
1. Open Excel
On the data menu, click “From Text” at the top left, select the file that was downloaded. The Automatic Text Import Wizard dialog will appear.
2. Guide to Import Dialog Text
After the dialog box appears, you only need to click next. The second step in the Delimiter box, make sure Tab and Comma be checked. Click Next, Finish, and then OK. You can edit your CSV file in MS. Excel. Now you can easily edit which ones are needed, and which ones you want to delete. The final step is to save the file, and then import it in the MTARGET system.