Opening and saving CSV files in Excel
A CSV file or “Comma Separated Values” file is used to store information in plain text form. This format is widely used for moving or updating data between systems like ecommerce stores. Microsoft Excel allows you to easily view and edit CSV files as spreadsheets with info placed into columns, that’s often more convenient compared to working in a text editor.
Here’s how the same CSV file looks when viewed in a plain text editor and in Excel:
If you have Microsoft Excel installed on your device or you are subscribed to the online version of Microsoft 365, you can use Excel to open and edit your CSV files.
To open a CSV file:
- Open a new blank document in Excel.
- Navigate to the Data tab and click From Text:
- Locate and select the CSV file that you want to edit and click Import.
- In the Text Import Wizard, choose Delimited, then click Next.
- In the Delimiters section, choose the delimiter used in your file and click Next.
Once you have chosen the right delimiter, you’ll see that your data is parsed into columns on the preview.
- For Column data format, choose General.
- Click Finish.
- Choose where you want to put the data — on the existing sheet or on a new one, then click OK.
That’s it! The file will be opened as a spreadsheet in Excel. You can now edit it. To check what columns you can add there to import catalog into your Ecwid store, see Format guidelines for the CSV file for reference.
The steps described in the instructions can slightly alter for different operating systems and their versions. For more details on how to import a CSV file into Excel on different versions of Windows, refer to the article in Microsoft Office support helpdesk (see the “Import a text file by connecting to it” section). Optionally, you can import CSV files from the File tab.
After you’re done editing your import file in Excel, you need to save it as CSV before proceeding with the import process.
To save a spreadsheet as CSV:
- Open your spreadsheet in Excel.
- Click File → Save As.
- Under Save as type box, choose CSV UTF-8 or CSV (Comma delimited).
- Click Save.
Values in CSV files are divided by delimiters (also called “separator characters”). For example, a delimiter can be a comma (,), a semicolon (;), a tab ( ), or a pipe (|).
Sometimes when you open CSVs in Excel, you need to specify what delimiter is used in your file so that the file is processed correctly. After that, delimiters will be converted into table borders, and you can view the CSV file as a spreadsheet.
To see what delimiter is used in your CSV file, simply open the file in a plain text editor — right-click on the file and choose your editor (Notepad, TextEdit or alike).
When creating a CSV file Excel uses a default delimiter set at the operating system level that can be changed in your device regional settings. The delimiter you have configured will be applied not only to your Excel settings but to all apps and programs.
To change the default delimiter in Excel:
You can change the character back to the default by following the same procedure.