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

learn more… | top users | synonyms (1)

0
votes
0answers
14 views

Replacement of a string in excel with another string, taken from a csv file [on hold]

Say I have a CSV file which looks like "5.2", "Blah Blah Blah" "5.3", "Bleh" "5.4a", "Unicorns" Now, how would I go about creating a script or macro of sorts(?) so that whenever I type ...
0
votes
1answer
24 views

Is There an .xml Format File that Excel Can Read

I'd like to use C++ to generate an Excel file. I know that Excel can read .csv files, but I was looking for something with more power. For example, the ability to create separate sheets and insert ...
0
votes
2answers
34 views

Data validation in Excel- all values in comma-delimited list within cell range

I have a reference table of memos and some information about them, including what other memos they reference and are referenced by. I want to make a data validation rule that will appear red if any of ...
1
vote
1answer
18 views

Information lost during format conversion from .csv to .cap

I have my data from an experiment in .cap form (created using Pasco Scientific Capstone software), which I exported to comma-delimited form. When I tried to convert the comma-delimited form back to ...
1
vote
1answer
29 views

Replace returns wrong capturing group

I have a text file that looks something like this: ,'','a','bc','def','ghi','lmn','op','qr','stu' I'm trying to replace groups of 5 with the match and a line break for easy readability. So, I'm ...
0
votes
0answers
23 views

Excel Data Connection Always Has 1 Extra Row

I have an Excel file with a data connection to another Excel workbook. Every time that I refresh the connection, there seems to be one extra blank row in the table (with formulas, but there is no ...
0
votes
2answers
27 views

Rename CSV header using command line tools

Given a CSV file, h1 h2 h3 a b c z x b how to rename the first header to One and the third header to Three using command line tools, namely One h2 Three a b c z x b
0
votes
1answer
41 views

Batch file to get the domain name of hundreds of servers in a multi domain environment

In a multi-domain environment, I need to get the "Domain Name" the servers are joined to. I have a list of hundreds of Windows servers with the hostname only (not FQDN). I was wondering if there is ...
0
votes
1answer
27 views

Add custom category type column to an Excel 2016 Power Query

Used the power query feature of Excel 2016 to import several CSV files containing personal financial history and trying to use the power pivot thing. Problem is I really need to group the ...
0
votes
1answer
36 views

Macro exports date column to csv as numeric value rather than dd/mm/yyyy

The following code has achieved what I require except that the date [cell B2] is exported as as five digit numeric value rather than dd/mm/yyyy. How to I amend the code to force B2 to export as ...
1
vote
0answers
31 views

What's the most convenient way to edit multi-card vcard files (.vcf)?

I have my contacts exported to a VCF file (a vCard) file. But they're partially messed up for reasons I won't go into. I'd like to edit them, making some changes to individual entries and some changes ...
0
votes
1answer
47 views

Excel export batch of columns from one worksheet

I am a very new user to VBA and am trying to create a macro to do a batch export of selected columns to a csv and then increment and loop that selection to continue exporting csv until end of dataset. ...
0
votes
1answer
42 views

How to find/export only one value (primary SMTP) from multi-valued Proxy Addresses

I have a script which search values in attribute Company and Proxy Addresses. Get-ADUser -Filter * -SearchBase 'OU=Stu,OU=LOWA,OU=IDLOWA,DC=ad,DC=ju,DC=com' -Properties company,proxyaddresses | ...
0
votes
2answers
28 views

Excel incompatible with itself

So I have a csv I created with excel in this format: col1;col2;col5 a;b;c d;e;f I want to change it to the more usual " and , how can I do that as of now every change either changes the encoding or ...
1
vote
2answers
33 views

Excel: comma in tab-delimited csv file

I have a tab-delimited csv file: "a" "b" "c,d" "e" Excel renders the second row until comma and the rest of the row is not rendered. I enclose each cell in double-quotes but it doesn't help. Is ...
0
votes
0answers
57 views

Convert a txt file into csv using powershell

The document that I am trying to convert is Formatted like so: 2012/12/09 REPORT OF USERS PAGE 1 HRS RG POSITION OPTIONAL ADDITIONAL USER # ...
0
votes
0answers
49 views

I can't import contacts into Outlook 2013 using vcf file and csv file

Help! I've backed up my phone with an app called "My Contacts Backup" emailed them to myself in vcf format. I tried to import it into my Outlook contacts but keep getting a permissions error. " We ...
0
votes
2answers
32 views

CSV file has dates formatted e.g 20140530 that are not recognised as dates

CSV file has dates formatted e.g 20140530 ( should be 30/05/2014) that are not recognised as dates. Is there a quick fix to convert them to a date format without retyping whole column? Thank you!
1
vote
1answer
18 views

Is there a command or way on how to retrieve or directly download a .csv file from raspberry pi to windows 7 using putty?

I am trying to remotely retrieve a .csv file from my raspberry pi using putty. Is that possible? If so, is there any command that allows me to automatically download or transfer that .csv to my ...
0
votes
1answer
20 views

Error running macro after trying to run it from pesonal workbook

So I wrote a macro. The scenario of use is: I open a fresh and new CSV file downloaded from somewhere My macro runs and does some magic with the data Since I don't want to copy-paste my macro to ...
0
votes
0answers
19 views

Have Excel search CSV's and mark where he finds names

Sorry about the confusing question title, it's kinda confusing me to explain in the right way, so hopefully this text will do a better job with it. My company has multiple CSV files pertaining the ...
1
vote
0answers
14 views

Locked between MailChimp and European Windows for CSV export?

I have a CSV export for our application that is being used by end users (not tech-savvy). For some European regional settings Excel expects a semicolon ; for delimiting (comma is used for decimals). ...
0
votes
2answers
55 views

Turning CSV into rows not columns

I have a file with unique references in column A (e.g.company names) and one or more values returned related to that unique value in column B (e.g.accounts). These are comma separated, some companies ...
0
votes
1answer
248 views

Command Prompt output to CSV

I'm using the forfiles command to list files and folders (included sub folders) which is piped to a text file. My subsequent process requires this output to be in comma delimited format (.csv). This ...
1
vote
0answers
46 views

Regex to find commas, excluding commas inside a string demarcated by double quotes

I would like to manipulate a closed .csv file without opening it through a button on an Excel AddIn. I am able to complete all the steps but am having a problem with finding a regex that would ...
1
vote
0answers
106 views

Properly import all fields from 'Windows Contacts' to Thunderbird

I want to migrate/import ALL information of my contacts to Thunderbird. On my Windows 7 system I carefully managed my contacts including birthday, gender, spouses and children. But I'm having trouble ...
0
votes
0answers
30 views

Pasting Paragraphs into Excel cells with Automatic HTML line breaks

Hello All Excel masters, Using Microsoft Excel I'm Working with Magento & creating large product lists in a .CSV format. The Problem I'm having is when I Paste Ex. paragraph LEGO movie ...
0
votes
0answers
9 views

Export CSV list of reverse links in Tuleap

I'd like to export the reverse links for my artefacts in CSV (i.e. having a list of all artefacts linking to the artefact I'm exporting the data from). Is it doable without having to trick it manually ...
0
votes
2answers
30 views

Reference cells in column of .csv from command line

I have a column B in my.csv in which each cell references the filename of a document in a directory source_directory/. I'd like to grab each of those names so I can use them as args for other shell ...
0
votes
0answers
31 views

Libre Office Calc Issue: Summarizing columns with too many rows

I'm writing a script that reads data taken from a database. THe data is modified (de-duplicated) and put into a .csv file I have a problem as I want to find the sum of a particular column in excel. ...
3
votes
2answers
147 views

How to make date YYYY-MM-DD (ISO-8601) the default in Excel?

In Excel how can I make the ISO8601 date format, yyyy-mm-dd, the default? Windows locale is English(CA) or English(US). We're using Excel 2013, though a generic answer for as many versions as possible ...
0
votes
1answer
180 views

How can you change Mac excel 2011 to separate using commas, not semicolons?

I have Excell 2011 on my Mac, and when I try to export a .xls file into .csv I end up having a semicolon separated file instead of .csv. p.s. The System preferences for my keyboard input is italian ...
0
votes
0answers
49 views

Capturing the MAC addresses of associated clients of a specific access point

I am trying to capture the MAC addresses of associated clients of specific access points as an experiment to see which type of device (by way of OUI lookup) most commonly connects to different access ...
0
votes
0answers
19 views

Spline drawing to CSV

I am trying to generate a csv file for a spline curve drawn on LibreCAD. I see that the drawing can be saved as dxf/dwg, but not as point data. I was wondering if anyone has managed to export into ...
0
votes
1answer
35 views

Split name column to csv file

How can I easily transform columns information to CSV line or file output? Input (From file or excel column): ABC1 ABC2 ABC3 ABC4 Output (To file or excel line): ABC21,ABC2,ABC3,ABC4 I don't ...
0
votes
1answer
20 views

Preserve existing tags in Anki CSV import/batch-add tags

I have downloaded the complete 2012 HSK vocabulary from here, where it is available as an excel file. I have then converted it to .CSV and changed it to this form: 爱;HSK:1 … 做主;HSK:6 The first ...
0
votes
1answer
20 views

Similar Excel Extensions as CSV

This query is related to Mainframes & Excel. If we have to transfer a file from mainframes to excel and it is .CSV, then automatically excel delimits the contents with comma. I need to know how to ...
0
votes
1answer
52 views

Why is Excel (sometimes) changing casing of a text in an imported file?

So this is a bizarre problem some users of ours are seeing, that I've been able to confirm, and that makes absolutely no sense to me. Basically, I work on an application that will export files in CSV ...
1
vote
1answer
30 views

Generate CSV from NS Zone File

I have a large file that contains records in multilines. ex: domain1 NS ns1 domain1 NS ns2 domain1 NS ns3 domain2 NS dnsx What might be the fastest way to generate a CSV of the form ...
2
votes
0answers
154 views

PowerShell Script to Rename - Copy - Move

I am trying to write a PowerShell script to do the following. step 1 Rename files in source (FTP folders) directories with it's "current_name_datetime.csv" as per a source file "Source_list.csv" ...
0
votes
1answer
62 views

Transform a CSV with Notepad++

Suppose I have a CSV file like this: 1,"abc",,,, 2,"def",,,"ghi", 3,,"jkl",,,"mno" Now I need to transform it in 3 steps: Replace all empty spaces with the String NULL Add at the beginning of ...
-6
votes
2answers
142 views

How to create a batch file to ftp files in the directory with the name realated to yesterday? [closed]

I have a set of directories with encoded in their names the date. Inside those directories there are files named files.csv. The directories have a standard name as, for example, ...
1
vote
1answer
221 views

How can I make Excel save a .csv using commas and quotes?

I am trying to save file as a .csv, however, Excel is not using the standard comma separator and quotes. Here is an example of what I want: "0","70","0","4/29/2012 ...
0
votes
0answers
35 views

Most reliable or widely used standard for CSV file formatting

I'm wondering what are the most common standards for CSV file, and is there any OFFICIAL one ? I just did several searches on google, SO and other sources, and the best I found is Wikipedia : No ...
3
votes
3answers
417 views

How to export a spreadsheet to a UTF-8 .csv from Excel 2016 on mac?

Hoping you can help me out with this one... For my work, I've been assisting a DBA for the last few weeks and we've now been given the task of uploading a very large spreadsheet which has several ...
0
votes
1answer
82 views

Export multiple (specific) worksheets to CSV files in a specified directory

I'm new to VBA. I'm trying to do the following but the code isn't quite working as expected. Export/Copy particular sheets in the workbook (any sheet name that contains "Upload") to a particular ...
3
votes
2answers
87 views

Which delimiter allows major spreadsheet programs to open CSV files by double-clicking?

I'm writing an iOS 8 app that allows you to export data to be sent as an email attachment. Currently, I'm exporting the data to a CSV file with 7 columns and x number of rows. When I first created it, ...
0
votes
2answers
666 views

UTF-8 File is not showing Chinese characters in Excel

I am creating a CSV file with UTF-8 encoding. It displays the Chinese characters properly if I open it using Notepad++. It displays the Chinese characters properly if I open it using Notepad. But, ...
1
vote
1answer
54 views

How can I automatically segment a mp4 video based on a list of frames

I have a 7 hour long h.264 video made up of 1600 shorter videos and I have a csv file with a list of frames at which I need the longer video to be cut at. Is there any way that I can automatically ...
1
vote
1answer
124 views

How can I write only certain rows of an Excel worksheet to CSV?

I have created an Excel (2010) workbook that takes information from various CSV files and puts them into a format that can be understood by my office's scheduling program. Using a macro I found ...