Jan-04-2021, 01:10 PM
How to Convert a TXT file to CSV
Regards,
Caleb
- Open Excel and create a new spreadsheet.
- Select the Data tab.
- On the far right, click “Get External Data”, then select the “From Text” option.
- Find the TXT file on your computer and click “Open”.
- In the first step of the Import Wizard, select “Delimited”
- Make sure to select that your data has headers (check the box) then click next.
- In the second step, select “Tab” if you’re working with the Amazon All Products Report, or “Comma” if you’re using another file. The best way to tell is to take a look at the contents of the file and see how they’re divided. If there is just a bunch of space between one field and another, then Tab is the right choice. If you look at the file and there are commas after each entry, then Comma is the right choice.
Regards,
Caleb