All Questions
24
questions
44
votes
3
answers
262k
views
How do you change default delimiter in the Text Import in Excel?
I want to import a CSV file to Excel. The CSV file has comma separated data (go figure), but the delimiter in the Text Import Wizard is set to "Tab" by default. How can I change the default to "Comma" ...
22
votes
5
answers
32k
views
How can you make Excel 2007 stop formatting large numbers as scientific notation?
Kind of the inverse of this question.
I frequently download CSVs from outside sources as part of my programming work. I like to examine their data in Excel because, let's face it, Excel is an ideal ...
19
votes
8
answers
38k
views
Increase size limit of data import from csv into Excel
I have a load of data in a csv file that I'm importing into Excel, most of it is fine, but one of my columns contains up to 1000 characters of data. Unfortunately, Excel has taken it upon itself to ...
17
votes
9
answers
104k
views
How do I get Excel to import a CSV file with commas in some of the content fields?
How do I get Excel to import my CSV file?
File
I have a file claiming to be CSV. It contains 10 fields, all of which are surrounded by double quotes (yes, even the dates and numbers.) 2 or 3 of these ...
16
votes
6
answers
46k
views
Excel CSV import treating quoted strings of numbers as numeric values, not strings
I've got a web application that is exporting its data to a CSV file. Here's one example row of the CSV file in question:
28,"65154",02/21/2013 00:00,"false","0316295","8316012,8315844","MALE"
Since ...
5
votes
1
answer
3k
views
Excel 2010 - Get CSV wizard to open by default
I'd like to set Excel 2010 to open the import wizard each time I double click on a CSV file rather than have Excel open the file without the wizard. Previous versions of Excel did this but 2010 ...
4
votes
2
answers
3k
views
Excel 2007 save import steps on csv file?
I have a csv file that constantly needs opened into Excel and then have the data copied over to a separate workbook.
I find the process of having to click through all of the dialogs, setting the text ...
4
votes
6
answers
4k
views
Transform Fixed Width to CSV?
I have a whole bunch of data files with different content but identical layout. I need to convert them to CSV before importing them into a CRM application.
I usually open the tab-delimited file in ...
2
votes
1
answer
17k
views
Excel How to make Text Qualifier editable or add a new entry in the existing list?
I have a CSV file which is not properly formatted because one of the columns contains HTML code which use the same character as the Text Qualifier: the double quote.
Example:
"col1","col2","col3"
"...
2
votes
1
answer
698
views
Import CSV data with units into Excel
I've got a bunch of CSV files that contain values with trailing units. This makes Excel think it's text so I can't sum them in a pivot table.
The data looks something like this:
Date; Text; Amount;
...
2
votes
1
answer
3k
views
Reversing Excel's Text Import Wizard for CSV Export
I have a CSV file that I want to import to excel, edit, and save back as CSV.
The problem that I encounter is with Text Import Wizard: I open a new Excel file, then Data > From Text, and in The text ...
2
votes
1
answer
274
views
Excel Help: Data Input Help
Everyday I download data from a site that will have rows each filled with individual data for clients. I'm able to input the data into excel as a whole but after that I'm having trouble figuring out ...
2
votes
1
answer
830
views
How to specify semi colon character ';' as a line ending character when importing CSV to Excel on Mac
(Using Microsoft Excel form Mac version 15.18)
Can see delimiters for the columns in the import steps, but no-where is there an option for defining what the line ending character is.
I need this so ...
1
vote
1
answer
1k
views
Import from tab delimited text file in Excel - CR character in quote marks is ignored
I have a large TXT file delimited with TAB.
Text is enclosed with quotation marks, but Excel still breaks the values into two rows when a CR character appears within the encapsulated string.
Is there ...
1
vote
0
answers
931
views
How can I automatically import csv files into SQL Server?
My goal
Automated aggregation of data so that I can use a tool (Microsoft Power BI or equivalent) to automatically update dashboards and or reports with the new data.
The situation
I work with an ...