--- title: "Convert a .csv or .tsv file to columns in Microsoft Excel" slug: "convert-a-csv-or-tsv-file-to-columns-in-microsoft-excel" updated: 2023-10-04T13:52:14Z published: 2023-10-04T13:52:14Z canonical: "help.dsp.samsungads.com/convert-a-csv-or-tsv-file-to-columns-in-microsoft-excel" --- > ## Documentation Index > Fetch the complete documentation index at: https://help.dsp.samsungads.com/llms.txt > Use this file to discover all available pages before exploring further. # Convert a .csv or .tsv file to columns in Microsoft Excel 1. Once you have opened your .csv or .tsv file into Excel, select the column containing the Comma-Separated Values (or Tab-Separated Values). ![](https://cdn.document360.io/287afab9-a086-4024-a782-6cbdb167f005/Images/Documentation/image-1687772533889.png?sv=2026-02-06&spr=https&st=2026-11-17T05%3A53%3A56Z&se=2026-11-17T06%3A53%3A56Z&sr=b&sp=r&sig=S9QF3Tuv%2F5%2BlDn3cDDZYgR016VAmNNkiXMb1G0xNsh8%3D) 2. Under **Data**, click on Text to Columns. Make sure that **Delimited** is selected. Click on **Next**. ![](https://cdn.document360.io/287afab9-a086-4024-a782-6cbdb167f005/Images/Documentation/image-1687772635548.png?sv=2026-02-06&spr=https&st=2026-11-17T05%3A53%3A56Z&se=2026-11-17T06%3A53%3A56Z&sr=b&sp=r&sig=mWt9N0upv0SBWiJHf4mR%2BcUbq6r0DR3y5VQIttGkEc4%3D) 3. Select **Comma** (for .csv file) or **Tab** (for .tsv file). Click on **Next**. ![](https://cdn.document360.io/287afab9-a086-4024-a782-6cbdb167f005/Images/Documentation/image-1687772643987.png?sv=2026-02-06&spr=https&st=2026-11-17T05%3A53%3A56Z&se=2026-11-17T06%3A53%3A56Z&sr=b&sp=r&sig=e8HHbXB6PRy8gRxwA5b9f1h%2FUT%2BAJsqmav8NkmXv%2FqM%3D) 4. Once you have confirmed by clicking on **Finish**, your Excel will display the data into separate columns. ![](https://cdn.document360.io/287afab9-a086-4024-a782-6cbdb167f005/Images/Documentation/image-1687772662106.png?sv=2026-02-06&spr=https&st=2026-11-17T05%3A53%3A56Z&se=2026-11-17T06%3A53%3A56Z&sr=b&sp=r&sig=yM3f66YPexmLFBks2KdR%2FWev3Y1c1uL8%2BTVT4sb0xNM%3D)