All Questions
12
questions
0
votes
0
answers
207
views
Managing utf8 CSV on Mac
I use Excel on macOS and when I try to combine CSV files downloaded from SaaS platforms, it messes things up on the first lines. I don't have this problem when using Excel with Windows.
For now, I ...
0
votes
1
answer
2k
views
How to convert a CSV’s timestamp format?
I am trying to convert a CSV file that returns the time stamp as hh:mm:s.mmm into hhmmssmmm with the added s for second.
For example I pulled a CSV file in which the time came back as 10:15:7.123 but ...
0
votes
2
answers
1k
views
How to merge multiple Mac excel files all with headers that are the same but out of order
I am using a Mac. My excel files have headers that match but are out of order. They all start with a header named "query" and then it gets mixed after that.
Here are some header examples:
...
2
votes
0
answers
42
views
Import csv file in excel scrambles characters
I'm trying to import a csv file that I created myself out of a python script. I'm struggling with encoding. The csv file is encoded in utf-8 with unix style line endings. TI"m on a german macos ...
0
votes
0
answers
196
views
Excel for MacOS drops decimal separators when importing csv file
I regularly work with csv files that use semicolons as the separator when I import these into Excel the decimal points are lost.
The values are displayed with the decimal place in the import wizard ...
2
votes
1
answer
828
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 ...
0
votes
3
answers
7k
views
Excel - take two csv files and map them
I have two csv files. One has a list of emails, another has a long list of emails with first names, last names, addresses, etc. What I am looking to do is take both of these files and map the emails ...
5
votes
4
answers
14k
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 ...
0
votes
1
answer
144
views
CSV - Microsoft office for mac 2008 doesn't add all the commas?
Let's say I have 5 column headings and I only complete the first 2 values. I then save the file as CSV (Windows). It ends up looking like this:
ID,Product,Name,Value,Interest
1,PC
Which is no good ...
2
votes
3
answers
3k
views
Change line endings and delimiter format (permanently) when saving to CSV from Excel
I'm using Excel on Mac and it's always painful to have to reopen all exported CSVs in another text editor just to change the line endings from "CR" to "LF" and the delimiter from ";" to ","
Is there ...
1
vote
1
answer
12k
views
How to import (and view correctly) Chinese UTF-8 encoded CSV file with Excel 2011 on Mac OS X
I have a CSV file which I can open and view the column with Chinese letters normally with TextMate.
However, when I try to import this file into Excel 2011, the field comes with unreadable fonts. ...
1
vote
1
answer
368
views
My computer isn't loading my massive Excel file…are there any tricks?
I have an 11,000 row Excel file (in Japanese) that I have saved as an xlsx file. I need it to be saved in UTF-8 format, so I went in and tested a few rows in OpenOffice (the reason for this apparent ...