1
vote
1answer
45 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
1answer
22 views

Is it possible to specify the decimal separator on Excel refreshable web queries?

When you create an Excel Web Query that points to a text file located in a web server, Excel doesn't ask for the decimal separator as it commonly does when using the Import Text File or Text to ...
1
vote
1answer
70 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 ...
0
votes
0answers
148 views

Macro to Import CSV files into Excel

I have a bunch of CSV files in a folder. I'd like to import each file into Excel using the 'Import from Text' tool by typing the name of the file into a cell. I then need to format all of the data ...
1
vote
0answers
26 views

Excel 2010 won't remember password when importing data

After connecting an Excel workbook with an SQL server (within a company network, over a static IP address, using the data connection wizard within Excel), if I close the workbook and reopen it, it ...
1
vote
1answer
488 views

Importing Text in Excel 2010 - Overwrite previous imports

I created a macro, using the recorder, to add a specific .txt file in my Excel file, using a specific shortcut key, in a specific area of the open excel file. However, I've got this problem: when I ...
-1
votes
1answer
164 views

Convert a line graph into data [duplicate]

Am looking for a tool that will import a line graph (chart) image and convert the line into numerical data, either in a spreadsheet or a database. For example, given an image like this: It might ...
2
votes
3answers
2k 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" ...
1
vote
2answers
3k 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 ...
4
votes
1answer
221 views

Excel - including data from a remote (web) sheet?

As a part of providing dynamic dashboards / reports, I've been investigating having a static Excel workbook that would contain a raw data sheet periodically updated from a web source. I'm currently ...
1
vote
5answers
9k views

Stop excel from converting copy-pasted number/text values to date

I'm copy-pasting some data from html table into excel. But excel automatically converts some text or number values to date! When I change the format, the number is perversed, the number is something ...
2
votes
1answer
260 views

Import data in Excel that doesn't have a row delimiter, but number of columns is known

So i have this text file that looks something like this: Header1 Header2 Header3 Header4 A1 B1 C1 D1 A2 B2 C2 D2 and so on. When imported, I'd want the data to format itself in 4 columns. I ...
0
votes
1answer
180 views

Microsoft Excel maintain formatting when importing

I am using a CSV to import data. The column of data has different and sometimes multiple numbers in one field. For example... 2924,2925, 2926 in one field 2927,2928, 2929 in another field. I ...
0
votes
4answers
330 views

Importing long numerical identifiers into Excel

I have some data in a database that uses ids that have the form of 16 digit numbers. In some situations i need to export the data in such a way that it can be manipulated in excel. So i export the ...
2
votes
2answers
1k views

Generating a pdf using data rows from excel and an image as the template with placeholders

I have lots of data rows in excel, each row has columns such as first name, last name, gender...etc. I also have an image as the template, I would like to define some placeholders on it. And then for ...
1
vote
1answer
1k views

Easy way to one-off import data with different decimal separator in Excel?

My OS's locale uses the comma as a decimal separator. However, once in a while I need to process data in Excel which is formatted with a point as decimal separator. Depending on the source of the ...
4
votes
6answers
1k 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 ...
1
vote
2answers
5k views

Is importing one Excel spreadsheet into another Excel spreadsheet possible?

Can I import an Excel spreadsheet into another spreadsheet (two separate files) by linking in certain cells from one to show in other cells in a different file? I'm not sure if I can do this or where ...
0
votes
2answers
527 views

Get External Data with carriage returns

I am trying to find a way to properly import a text file into excel that contains a carriage return using the Get External Data option. The file has a text qualifier and is pipe delimited. Here is ...
3
votes
2answers
856 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 ...
1
vote
2answers
512 views

How to have a whole, refreshable MySQL database inside Excel

I have a MySQL database and have a lot of users that want to use Excel to process this data. I know how to do two things that I don't want: I know how to import a MySQL database into Excel. I know ...
15
votes
3answers
61k 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" ...
3
votes
2answers
5k views

Import data into excel that doesn't use a line break as a row delimiter?

Is there any simple method that doesn't resort to macros whereby a plain text file or string can be imported into excel without using a line break as a row delimiter? Example ...
2
votes
1answer
170 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 ...
0
votes
3answers
3k views

Export spreadsheet and import as table into mysql

What's the easiest way to export a table from either MS-Excel or OpenOffice calc and import it into a mysql database, where: The table will be imported as a table in Mysql The headers of the table ...
1
vote
1answer
642 views

Make excel recognize foreign date format

I am trying to import a text file (tab-separated columns) into excel. The log file uses MM/DD/YYYY HH:MM:SS,mmmm (where mmmm is milliseconds), which excel treats as string. How can I get excel to ...
1
vote
1answer
331 views

Import exponetial fixed width format data into Excel

I've received a bunch of text data files consiting of Lots of records (>30K/file) of 3 fields each of 5-place numbers in exponential format: s0.nnnnnEsee (where s is +/-, n is a digit and ee is the ...
5
votes
4answers
6k 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 ...
8
votes
1answer
8k 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 ...