Comma-separated values: a rudimentary plain-text spreadsheet. Also includes tab, space, semicolon or other-separated values.

learn more… | top users | synonyms (1)

1
vote
1answer
914 views

How to convert two columns into one column of CSV?

This is how my columns currently look. There are two columns, each having a name. I want something as shown below in the expected section, for better processing of a parsing task. Current Col A ...
1
vote
2answers
2k views

Cyrillic export from Excel to CSV

I have an application where I upload some content in CSV format, however the main document where I have my data is an Excel document. I use Save As » CSV in order to make a CSV file, but it is not ...
2
votes
4answers
14k views

How to set a character limit and remove characters over that limit excel 2007

I have to provide a CSV file for a telephone system with names and numbers on for a directory. The numbers cannot contain any spaces, and the names must be 20 characters max. I have a list of ...
0
votes
1answer
26 views

Have a very large fixed width .txt file, have column widths for the records to guide me, and need .CSV out of it [on hold]

The text file is a tax roll off the tax assessor website, and it is 2.63 GB. Every program that I have tried, including UltraEdit, Convert XLS, didn't find anything helpful in excel because we're ...
7
votes
1answer
8k views

Can I create an Anki deck from a .CSV file?

Can I convert my CSV file into an Anki deck? I can't find any options in the program.
2
votes
2answers
2k views

How to convert Excel file with multiple sheets to a set of CSV files?

I have an Excel file with 20 sheets on it. Is there a way to quickly convert the file into 20 CSV files - one for each sheet? I can do it manually of course, but I'll have to be processing these ...
1
vote
0answers
31 views

Properly extracting from an array

I have a CSV with one column, numbers formatted as 111-0000, that I'm reading in to process one at a time. I'm trying to import the column of information from the CSV, but I'm having trouble figuring ...
-2
votes
1answer
17 views

How to find the unique values in 2 columns of different sheets in which the values in each sheets were not in order [closed]

I have two sheets with same data in columns(Lets say column A) but the data insdie the columns were misplaced, i just need to find the unique data in each column of two different sheet. Help me in ...
0
votes
1answer
33 views

Automate spreadsheet (Excel/CSV) workflow

I'm looking for a tool or process to help automate repetitive workflow tasks that require with an Excel or CSV file to be in a specific format. For example, we work with vendors that send us a list ...
1
vote
2answers
3k views

Getting Excel to handle CRLF's correctly in CSV

I am creating CSV files to be opened in Excel. The rows are separated by CRLF and that's fine, but some of the input data contains CRLF data in it as well. Per the usual standards, I surround them ...
2
votes
0answers
21 views

How to output a CSV file from a matrix of Excel formulas using multiple files?

I am receiving on a weekly basis a list of Excel spreadsheets from a supplier (around 40 spreadsheets) with data in a specific format. Since the format is a bit complex and can't be converted to CSV ...
5
votes
2answers
5k views

Importing multiline cells from csv file into excel

I have a csv file (comma delimited and quoted). When csv file is opened directly from explorer excel correctly interprets the cells that are mutliline, but it messes up the character encoding (utf-8). ...
1
vote
1answer
48 views

Why doesn't my Python script save the file when I use Task Scheduler?

I have a Python script that uses csv.writer to create a csv file. This works fine when I run it from the command line, but no file is created when I run the script using Windows Task Scheduler. The ...
0
votes
1answer
17 views

Remove a specific string common in multiple lines in a CSV file using shell script

I have a CSV file which contains 65000 lines (size approximately 28 MB). On each of the lines they have a path in the beginning in the format of: c:\abc\bcd\def\123\456. Now let's say the path ...
3
votes
2answers
4k views

Export Office Excel table to csv using a macro

I'm using Excel Tables in Excel 2010. I would like to quickly export the contents of these tables to *.csv. My current workflow: 1. Select table manually 2. Copy the contents into a new workbook ...
0
votes
0answers
25 views

Excel formula returning different results on different machines

For a piece of work I'm doing, I use a formula that calculates the difference between two dates for each row in the report that the system generates. Essentially, the software I'm using generates the ...
1
vote
0answers
176 views

Images in CSV file don't show up in Anki

I'm trying to import a CSV set of notes that include image references into Anki. I have a file with Cloze substitutions and in one note I am using an image in the text: <img src=”duck.jpg”> ...
1
vote
1answer
42 views

Windows Batch to read TXT and parse lines to CSV

I've made a good deal of headway by searching this site and learning the ridiculous language that is Windows batch scripting, but frankly I'm stuck. The sample below is from our lab's old radiometer ...
0
votes
1answer
16 views

Mail Merge comparison between fields

I have a meeting merge document which is populated from a CSV file with data entered online from a facilitator. I am unable to work out how to do multiple conditions, there are a maximum of 10 clients ...
0
votes
0answers
23 views

Create Xbox Music Playlist from excel list (csv)

I created a few playlists in Excel (just the artist & song title) that I wanted to Import into Xbox Music. Unfortunately the only way I could find was to search for each song indivdually and then ...
0
votes
1answer
33 views

csv file formatting issue in excel

I have a csv file when opened in notepad looks like this: sep=, ProgramXX, PXXXXX, .... IDXXXXX, XYZXXXXX, .... This should open well formatted as csv file in excel program but what I see is this: ...
0
votes
0answers
12 views

Export specific results of Access 2010 query determined by checkbox

I am working on a planning tool which provides information about how long particular tasks should take. Everything was working as expected but I have just been informed that the user would like to ...
0
votes
0answers
14 views

phpmyadmin wordpress export only showing postmeta columns

Trying to export - and the import - a Wordpress MySQL DB using phpmyadmin. I've done this quit a bit in the past and I'm completely perplexed at this point! I have a fairly standard Wordpress DB with ...
7
votes
6answers
26k views

How to export selected columns into csv file

I want to export specific number of columns from excel into .csv file. I have around 10 columns like lname, fname, phone, address, email and so on. what should i do to export certain columns like ...
48
votes
11answers
87k views

Easiest way to open CSV with commas in Excel

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 "comma-separated values", ...
0
votes
0answers
12 views

Styling multiple files on Libre Office Calc [duplicate]

Here's what I do now: Get CSV file from extrenal source Open it in Calc Apply style (set colors, fonts, etc.) Export as PDF Is it possible to get rid of step 3? Somehow loading data to already ...
1
vote
1answer
576 views

How to enable the 'Save and Open' option in Internet Explorer

I've recently upgrade to Internet Explorer 11 and now when I try to download/open a *.csv file from the internet I get the following options in IE. The Save and Open option is disabled/greyed out. ...
3
votes
1answer
310 views

Open only the first 10 lines of large CSV file in LibreOffice Calc

I will start receiving many large CSV files, of which only the first few lines are of interest to me. I was hoping to open them by piping only the first few lines to Calc, but this doesn't work: $ ...
23
votes
15answers
17k views

Querying a CSV file

Does anyone know of a simple tool that will open up a CSV file and let you do basic, SQLesque queries on it? Like a graphical tool of sorts, one that is easy to use. I know I could write a small ...
3
votes
4answers
12k views

Merging columns in Excel with “;” separator

I'm new here and I hope to seek for your assistance on converting data format of my excel to csv. This is my raw data in excel in different row and cells: A B C D E F 1 2 3 4 5 6 ...
1
vote
3answers
282 views

XY Diagram/Data Browser for mid-sized CSV files

I have a set of CSV files with about a 100k records in them. The records need to be visualized in an x-y diagram. Specifically, I'm looking for: Seamless zooming in and out of the data Navigation ...
0
votes
0answers
20 views

LibCurl: FTP, wildcard file inside wildcard directory

I am using LibCurl looking to download one file. The problem is that the server will regularly updating new directory, and inside that directory, I am looking to download SINGLE file end with *.CSV ...
0
votes
0answers
41 views

Convert CSV to an MP3 Playlist, then merge the MP3 into a single audio file based on playlist order

I have a Japanese language learning app, which contains several MP3s. I'd like to merge these MP3s into a single file, so I can take the course without using the app (as the App has a terrible ...
0
votes
1answer
31 views

PowerQuery to parse fixed width csv

I have fixed width csv.txt, e.g. Martin Junger 12 John Wing 124 To load it with PowerQuery this syntax is used: let Source = ...
2
votes
0answers
29 views

Convert UPPERCASE to PascalCase [closed]

I have 50+ CSV files (50 to 100 columns each) to load into the database using SSIS. Most of these CSV files have all uppercase headings (primarily because my Oracle exports only with all UPPERCASE ...
1
vote
0answers
43 views

Excel 2010 - Merge multiple connections into single worksheet

I have an Excel workbook containing several worksheets. Each worksheet has an external connection to a unique .csv file that is updated several times a day from different PCs. This is done so that ...
1
vote
2answers
1k views

Data Validation of a Comma Delimited List

I need a simple way of taking a comma seperated list in a cell, and providing a drop down box to select one of them. For Example, the cell could contain: 24, 32, 40, 48, 56, 64 And in a further ...
0
votes
0answers
19 views

Right click a csv file to read in RStudio?

I would like the ability to right click on a .csv file and read it in RStudio (an IDE for the statistical language R). When I say "read it in RStudio" I mean open up RStudio with the line ...
1
vote
1answer
3k views

Excel: change data source with macro

I'm using a CSV file (generated by a thing party program) as an external datasource, and I'd like to change its path from a macro... How can I do that ? Another acceptable answer to my problem would ...
0
votes
2answers
172 views

Autoload CSV for batch printing labels (Brother P-touch Editor v5.1)

My goal is to automatically print shipping labels for an e-commerce website based on periodically created .csv-files. I have the .csv-files ready. I also have the shipping label template ready in ...
5
votes
6answers
11k 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 ...
61
votes
5answers
44k 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 ...
3
votes
2answers
4k views

Set CSV import default to UTF-8 in Calc

Every time I open a CSV (comma separated values) document in OpenOffice.org Calc I get a dialog with CSV preferences. The current default character set is "Eastern Europe (ISO-8859-2)". I would ...
0
votes
2answers
42 views

How to remove rows that match?

I have a csv file with list of people (first name, last name, email) and then later on I will get a list of people in another csv file that unsubscribed ( only one column with email). Q: How can I ...
2
votes
2answers
297 views

Manually “draw” data for chart, output to CSV

I need a service that will allow me to draw a chart line by hand and generate data points for what I drew. This might sound crazy, but I need some data (preferably in CSV output) that will only ...
6
votes
2answers
10k views

Compare two spreadsheets and get missing records

I have 2 CSV documents. one has 10.000 rows with 50 columns, first row is a unique SKU. Now I have a second document with 9.500 rows using the same identifiers. I simply want to create a third ...
1
vote
1answer
31 views

Manually editing Excel worksheet, need my edits to save as written in .csv without reformatting back

Here is my issue: I have exported about 2000 records from a database to manually clean up the dates attached to them. (It appears that someone exported these records before, then re-imported them ...
35
votes
10answers
103k views

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

Excel only places quotes around certain fields, how do I force excel to save a CSV file with quotes around every column?
2
votes
2answers
118 views

excel: export csv file with japanese character

In my excel file, the Japanese character is shown correctly, while when I export it as csv, the character become question marks How should I output so that the character can be shown correctly?
3
votes
4answers
3k views

Mass Convert .xls and .xlsx to .txt (Tab Delimited) on a Mac

I have about 150 .xls and .xlsx files that I need converting into tab-delimited. I tried using automator, but I was only able to do it one-by-one. It's definitely faster than opening up each one ...