Linked Questions

1
vote
1answer
14k views

Excel - Disable AutoFormatting on Import [duplicate]

How can I stop Microsoft Excel from auto formatting data when imported from a text file? Specifically, I want it to treat all of the values as text. I am auditing insurance data in excel before it ...
2
votes
2answers
4k views

can I make Excel always open a delimited text file with “text” translation? [duplicate]

Opening a tab-delimited data file in Excel to view & manipulate the data is a very common operation around here. However, by default Excel (2003/4 or 2007/8) will read the columns in a "General" ...
0
votes
2answers
1k views

Excel - how to stop automatic destructive re-formatting of fields on document load [duplicate]

I am trying to edit a csv file in excel, but am running into issues with its supposedly-helpful automatic format detection, and I don't know how to turn it off. I have a field with an original value "...
3
votes
1answer
534 views

How to Disable Auto-Formatting of All Column Values when opening CSV Files in Microsoft Excel [duplicate]

How can I stop Microsoft Excel from auto formatting data when imported from a csv/text file? Specifically, I want it to treat all of the values as text. The files come to me as tab delimited text ...
0
votes
0answers
34 views

How do I stop Excel from reformatting when reopening a CSV file? [duplicate]

In one of my cells I have the number 00780. I formatted it as text so it would not change to 780. I need to save the file as a CSV but every time I reopen the file it changes the formatting of the ...
0
votes
0answers
21 views

Problems when an excel file is saved as .csv file [duplicate]

I have an excel (.xlsx) file , with only one sheet. This sheet have only 2 columns. All the cells in both columns are formatted as Text. The columns have this format : Name........Phone number Name1....
125
votes
6answers
107k views

How can I stop Excel from eating my delicious CSV files and excreting useless data?

I have a database which tracks sales of widgets by serial number. Users enter purchaser data and quantity, and scan each widget into a custom client program. They then finalize the order. This all ...
11
votes
6answers
28k 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 ...
8
votes
4answers
42k views

Why is Excel removing leading zeros when displaying CSV data?

I have a CSV text file with the following content: "Col1","Col2" "01",A "2",B "10", C When I open it up with Excel, it displays as shown here: Note that Cell A2 attempts to display "01" as a number ...
0
votes
1answer
13k views

Editing CSV file in Excel always converts number column to scientific notation [duplicate]

I have a CSV file that I'm editing in Excel 2013. In the file there is a column that contains numbers e.g 688087123456789. Everytime I open the CSV file in Excel, it converts the number to scientific ...
0
votes
3answers
11k views

Run excel macros (vba) from vbscript file

I have a vbs file that pulls information from my database and exports the data to an Excel file (C:\file.csv). Once this is done, I run a series of macros (vba) to format this data. These macros are ...
4
votes
1answer
4k views

How do I completely turn off Excel 2010 autoformatting?

I am using a lot of csv files at work with excel 2010. These have no formatting so Excel 2010 autoformats all the cells. I've found workarounds but the ones I have found require action for each file ...
2
votes
1answer
4k views

Merge CSV files to one Excel file in different sheets

I want to merge CSV files to one Excel workbook in different sheets. I want each file in one sheet with the CSV file name as sheet name.
2
votes
1answer
2k views

Why don't I see this code as a macro in Excel?

I tried using a bit of code provided from this previous Super User Answer: Sub OpenCsvAsText(ByVal strFilepath As String) Dim intFileNo As Integer Dim iCol As Long Dim nCol As Long ...
4
votes
0answers
1k views

How can I easily split a CSV into two Excel worksheets with PowerShell? [closed]

I recently found out that PowerShell can be used to write Excel documents. The first use I thought of for this was to (at least partially) automate parsing of some CSV reports that I regularly have to ...

15 30 50 per page