---
title: "Opening the Supplier File"
canonical: "https://kb.myframeworks.com.au/space/PROSTIXV48DOC/31101682/Opening%20the%20Supplier%20File"
format: markdown
---
It is time to bring the supplier file into Excel.  The file can be in the format .csv or .txt. It may not have been created in Excel but is merely output created by the Supplier with each field separated by a comma or of fixed length. From Microsoft Excel, perform the following: 1. Select  Open  and browse your hard drive for the location chosen to store the file that was given to you by your supplier.  You may notice that your file is not displayed. This is because Excel defaults to display files that were created in Excel. That is, with a format of .xls.  You need to click on the drop-down box beside File of Type and change to ALL FILES ( . ) to display other files or Text Files to display just text (.txt) and comma separated variable (.csv) files only.  All text files (*.txt) in the selected location are displayed.   2. Select the file you wish to import. If it is a text file, Excel will launch into a Text Import Wizard because it recognises that this file was not created or saved in the standard Excel format. Today most Suppliers give you a file they have created in Excel and it is a .csv format. For this reason we concentrate on processing the import using a .csv format data file. 3. A preview of the data is also displayed and you can use the vertical and horizontal scroll bars to view the rest of the data.  The File Type that suits this data is delimited. That is, each field is separated by a character such as a comma and Excel has detected this. 4. Check the  Preview  pane as some data files may have header rows containing information that should be ignored, that is, the supplier name, creation date and so on.  These rows should be ignored by changing the Start Import at Row to the row that contains the first product. In this case, we chose to export a header row. That is, field names, so nothing needs to be changed. 5. Click  Next  to proceed with the next step in the Text Import Wizard. i. Change the delimiter to Comma. ii. Change the Text Qualifier to None. iii. Use the horizontal scroll bar to check that the fields and the column line up. 6. The vertical line in the Data Preview pane depict the field separators. If this is in the incorrect position, the mouse pointer can be used to move (drag and drop) the vertical lines to the correct position. It is a good policy to scroll down your data because the data lower in the list may be slightly different to the data at the top of the list and a slight adjustment may need to be made to the columns. A typical example of this is where they have a trailing - (minus) sign. 7. When all of the data appears to be correct, click  Next  to proceed with the last step of the Text Import Wizard. 8. This step allows you to select which fields to import into Excel and to review the format of each field that was created in the previous step.  It is recommended that ALL columns are imported to take the guesswork out of future imports - remember, all work in Excel must be repeated EVERY time you import this suppliers information. That is, future updates.  Even though the Wizard allows formatting, it is easier to check formats in Excel. 9. Click  Finish  to display the information in an Excel worksheet. 10. For further information, refer to:  Editing your Data .