One way you can fix this is by highlighting the UPC’s column, right click and select “Format Cells”. One thing to note that might happen, is your UPC’s will most likely change during this conversion process. You now need to “Save As” and change the file extension to CSV and save.Ħ. At this point, you’ll notice at the top of the screen it still will have the txt file extension, even though it’s opened in Excel.

You’ll then see the Excel sheet fill up as a completed CSV.ĥ. On the next step, leave everything on default, and click “Finish”.Ĥ. On the next screen, under “Delimiters”, uncheck the default selection (which is usually “Tab”), and select “Other:” and enter the Pipe symbol in the box (“|” on your keyboard, usually shift +, on some MAC keyboards it will be to the left of the return key.) then click “Next”.Ĭ. Check “Delimited” for the file type description, then click “Next”.ī. Next, you’ll see a Text Import Wizard pop-up. Then select your file, and click “Open”.ģ. If you don’t see your file listed, make sure that the file extension is broadened to show “All Files”. Navigate to the txt file you are looking to convert. If you have a newer version of Excel, simply click on “File” in the upper left-hand corner, and “Open”.Ģ. If you have an older version of Excel, click on the office button in the upper left-hand corner, then click on “Open”: Firstly, you’ll need to open a new blank Excel document, then open the txt file in that new document.

Then you can use the variable as content of a excel file.1. You just need to replace the and tags with semicolons (' ') for each row.Īnd then write back the info line by line into a variable or whatever. Now you have an array with each 'csv line' And I know that all my info is inside my new array field. So in the next compose I use the output of the previous compose (but the array field). Then I start splitting the information out of the html like that:įirst I split out my tables ID and I know that my result is on the 'right side' of my splitted string.

How to convert a file to csv format