About 13,700 results
Open links in new tab
  1. Excel 2019 not opening CSV correctly - not parsing columns

    Mar 13, 2019 · But I have just installed Excel 2019 and it is opening files without recognizing that they are CSV. I am not trying to import data from a CSV file I opening it directly.

  2. Easiest way to open CSV with commas in Excel - Super User

    Mar 31, 2012 · CSV files are automatically associated with Excel but when I open them, all the rows are basically in the first column, like this: It's probably because when Excel thinks …

  3. How to set character encoding when opening a CSV file in Excel?

    Jun 6, 2017 · Is it possible to set the default encoding for Excel (any version, e.g. 2010) when opening files like csv files (like you can in Open Office Calc)? I When I try to open a csv file …

  4. Excel destroying special character when saved as CSV

    Aug 24, 2012 · The problem is, whenever the client saves the excel spreadsheet as an MS-DOS .csv file, many of the special characters get converted to question marks "?" (symbols such as …

  5. How to make excel open CSV files and automatically split the …

    I am working on Excel in France and the default delimiter is " [tab]". I don't know how to change it in the software but there is a trick: For example, let's say that your .csv file is delimited with ";" …

  6. True difference between Excel CSV and Standard CSV

    Jun 26, 2011 · What is the true difference between an Excel CSV and a standard CSV? For example, when handling columns with line breaks inside one cell, how do they encode it …

  7. How do you force excel to quote all columns of a CSV file?

    Apr 13, 2010 · Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?

  8. How to turn off excel auto formatting for csv files? Again

    Apr 29, 2020 · 1 Excel works with CSV as text file. Just recognises some characters for data distribution into columns and rows. If you want excel to import data from CSV correctly, you …

  9. microsoft excel - .csv did not save all tabs - Super User

    Apr 25, 2022 · I downloaded a database in .csv and made pivot tables in different tabs. I saved the file without complications, but when I went to open it, only the tab with the database …

  10. How to force Excel to open CSV files with data arranged in columns

    I generate a CSV file with an extension .csv in which every piece of data in one line is separated with a comma: 1,2,3,4 1,2,3,4 The file is sent via email and I want that when a customer opens …