If you export a CSV file from SKULabs and all of the data appears in a single column when opened in Microsoft Excel, the issue is typically related to your computer's regional settings rather than the export itself.
This most commonly occurs on systems configured for regions that use a semicolon (;) as the default list separator instead of a comma (,).
Symptoms
You may experience one or more of the following:
All exported data appears in Column A.
Fields are separated by commas when viewed in Notepad.
Importing the file through Excel's "From Text/CSV" feature works correctly.
The issue only occurs on specific computers or user accounts.
Verify the Export File
Before changing any settings, confirm the CSV file is properly formatted:
Right-click the CSV file.
Select Open With → Notepad.
Review the contents.
A properly formatted CSV should look similar to:
"SKU","Warehouse","Location","On Hand","Alert" "400-01347","DC Cookeville","S2A11",5,0
If you see commas separating the values, the export file is valid.
Temporary Solution
Import the file directly into Excel:
Open Microsoft Excel.
Select the Data tab.
Click From Text/CSV.
Select your exported file.
Ensure the Delimiter is set to Comma (,).
Click Load.
This method will correctly separate the data into columns regardless of your regional settings.
Permanent Solution
To make CSV files open correctly when double-clicked:
Windows 10 / Windows 11
Open Control Panel.
Navigate to Clock and Region → Region.
Click Additional settings...
Locate the field labeled List separator.
Change the value from:
;
to:
,
Click Apply.
Click OK.
Close and reopen Excel.
CSV files should now open correctly when double-clicked.
Notes
Changing the List Separator affects how Windows and some applications interpret CSV files.
If you frequently work with files that use semicolons as delimiters, you may prefer to leave the regional setting unchanged and continue importing CSV files using Excel's Data Import feature.
This issue is caused by Excel's interpretation of the file and does not indicate a problem with the SKULabs export.
Need Additional Help?
If the issue persists after updating the List Separator setting, provide the following information:
Windows version
Excel version
Screenshot of the Regional Settings window
Screenshot of the CSV file opened in Notepad
Our support team can help verify the file format and identify any additional configuration issues.