Skip to main content
All CollectionsContact Management
Tutorial Open CSV in Excel
Tutorial Open CSV in Excel
S
Written by Support Mailtarget
Updated over 2 weeks ago

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.

Did this answer your question?