Follow

CSV Opened in Excel has everything in the first cell

Excel has a function that is called "text to columns" that you can use to separate the values if they are separated by commas. For macOS you can use the function, opening Microsoft Excel, then click on the "Data" tab and select: "Text To Columns" option, as follows: 

For Windows and Microsoft Office 2019, works pretty similar: 

1. On the Data tab, in the Data Tools group, click Text to Columns:

Click Text to Columns

2. The following dialog box appears. Choose Delimited and click Next:

Convert Text to Columns Wizard - Step 1

4. Clear all the checkboxes under Delimiters except for the Comma check box. Then, click Finish.

mceclip0.png

5. Select "General" as data format and click on finish: 

mceclip1.png

Note: This example has commas and spaces as delimiters. You may have other delimiters in your data. Experiment by checking and unchecking the different check boxes. You get a live preview of how your data will be separated.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments