excel

How To Change Delimiter In Excel For CSV

Boost your productivity with Sourcetable's AI spreadsheet assistant. Work like a spreadsheet power user and answer all your questions in seconds.


Learn more
Jump to

Changing the delimiter in a CSV file is a common task for those working with data in Excel. This guide provides a straightforward approach to modify the delimiter from commas to other characters.

While Excel offers native functionality for this purpose, users often encounter challenges due to its intricate steps. This article will delve into the process and also explore why Sourcetable is a more user-friendly alternative for changing delimiters.

excel

Changing Delimiter in Excel for CSV Files

Adjusting List Separator in Windows Regional Settings

To change the delimiter globally for CSV files in Excel, modify the List separator in Windows Regional settings. Access this setting via Control Panel > Region settings, ensuring it differs from the Decimal symbol to prevent conflicts.

Changing Delimiter When Saving CSV in Excel

Alter the CSV delimiter by changing the default List separator before saving the file. This adjustment affects all programs that use the List separator setting.

Specifying Delimiters for Individual CSV Files

Indicate the desired delimiter directly within a specific CSV file. This practice overrides the default List separator for that file alone.

Using Excel's Text Import Wizard

For Excel versions prior to 2016, use the Text Import Wizard to set a custom delimiter when importing a CSV file. In Excel 2016, enable the From Text (Legacy) feature to access this tool.

Employing Power Query for Delimiter Selection

Power Query provides a delimiter choice when connecting to a CSV file. This feature is especially useful for managing data imports without altering global settings.

Manual Delimiter Replacement

If Excel 365 fails to save CSV files correctly with comma delimiters, manually replace commas with semicolons using a text editor. Ensure all dots used as decimal symbols are also replaced accordingly.

excel

Common Use Cases

  • excel

    Importing CSV files with non-standard delimiters into Excel

  • excel

    Exporting Excel data to a CSV file with a custom delimiter for specific software requirements

  • excel

    Converting CSV data with complex fields that include commas into Excel without disrupting the data structure

  • excel

    Facilitating data exchange between systems that use different delimiter standards

  • excel

    Improving data readability by using a delimiter that separates data more clearly in Excel

sourcetable

Excel vs Sourcetable: The Modern Spreadsheet Showdown

Discover the key differences between Excel and Sourcetable in data management. Excel, a long-standing leader in spreadsheets, stands contrasted with Sourcetable's innovative approach to data integration.

Excel's robust functionality meets a variety of user needs, but Sourcetable introduces a unified data source solution, simplifying the complex task of data consolidation.

While Excel relies on user proficiency for formula creation, Sourcetable's AI copilot delivers an intuitive experience, assisting users in formula generation and template creation with ease.

Opt for Sourcetable for a streamlined data query experience through its spreadsheet-like interface, a step beyond Excel's traditional data manipulation methods.

Choose Sourcetable when seeking an efficient, AI-enhanced workflow, a contrast to Excel's conventional, manual approach to spreadsheet management.



Sourcetable Logo

Work smarter, not harder

Boost your productivity with Sourcetable's AI spreadsheet assistant. Answer all your questions about spreadsheets in seconds. Try for free to get started.

Learn More
Drop CSV