How to Fix CSV File

Watch this video to fix CSV file :

If you don’t like the video or need more instructions, then continue reading. Follow these steps to fix CSV file :

1. Click “Save Result To CSV” 

fix csv simpleaudien

2. Block All Columns A, select data and choose “Text to Columns”

fix csv simpleaudien3

3. Select Delimited then Click Next

fix csv simpleaudien4

4. Select Tab & Comma, then Click Next

fix csv simpleaudien5

5. Click Finish

fix csv simpleaudien6

6. It’s Done

7. For the Phone Number, Do as Above. Then Block All Column D, Select Number on the Top Bar

fix csv simpleaudien8

8. It’s Done

fix csv simpleaudien9