--- 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%3A30%3A06Z&se=2026-11-17T06%3A30%3A06Z&sr=b&sp=r&sig=k4dX6c%2Bbo%2FJVNSBiHGYp%2BJR6cCCWZvkyw0lvb2e9U5Q%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%3A30%3A06Z&se=2026-11-17T06%3A30%3A06Z&sr=b&sp=r&sig=lu4lk8O5h3V%2F%2F0cmLnDU5MnjNtv%2FicBPrxF9C6b8AZQ%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%3A30%3A06Z&se=2026-11-17T06%3A30%3A06Z&sr=b&sp=r&sig=pf6p55O53jmzbZ0g%2B1SbgDcTCOAQ1PLmWss6nUAA1HI%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%3A30%3A06Z&se=2026-11-17T06%3A30%3A06Z&sr=b&sp=r&sig=ji7SQbWZkxA3hqlQ5EwTwxtU41HyDrCLtwNK3KM968o%3D)